Formateo del Objeto de Lista

Formateo del Objeto de Lista

Una tabla es una serie de filas y columnas que contienen datos relacionados y se gestionan de forma independiente de los datos en otras filas y columnas. Por defecto, cada columna en la tabla tiene habilitado el filtrado en la fila del encabezado para que pueda filtrar o ordenar rápidamente los datos del objeto de lista. Puede agregar una fila de totales (una fila especial en una lista que proporciona una selección de funciones de agregado útiles para trabajar con datos numéricos) al objeto de lista que proporciona una lista desplegable de funciones de agregado para cada celda de la fila de totales.

Aspose.Cells admite el formateo de objetos de lista. Para esto, la API proporciona las clases ListObject y TableStyleType. La clase TableStyleType contiene constantes que representan los estilos de tabla integrados. El siguiente fragmento de código crea un nuevo Objeto de Lista y establece su tipo de estilo de tabla en TABLE_STYLE_MEDIUM_10.

output_directory = "Examples/SampleFiles/OutputDirectory/"
# Create a workbook
workbook = Workbook()
# Obtaining the reference of the default(first) worksheet
worksheet = workbook.getWorksheets().get(0)
# Obtaining Worksheet's cells collection
cells = worksheet.getCells()
# Setting the value to the cells
cell = cells.get("A1")
cell.putValue("Employee")
cell = cells.get("B1")
cell.putValue("Quarter")
cell = cells.get("C1")
cell.putValue("Product")
cell = cells.get("D1")
cell.putValue("Continent")
cell = cells.get("E1")
cell.putValue("Country")
cell = cells.get("F1")
cell.putValue("Sale")
cell = cells.get("A2")
cell.putValue("David")
cell = cells.get("A3")
cell.putValue("David")
cell = cells.get("A4")
cell.putValue("David")
cell = cells.get("A5")
cell.putValue("David")
cell = cells.get("A6")
cell.putValue("James")
cell = cells.get("A7")
cell.putValue("James")
cell = cells.get("A8")
cell.putValue("James")
cell = cells.get("A9")
cell.putValue("James")
cell = cells.get("A10")
cell.putValue("James")
cell = cells.get("A11")
cell.putValue("Miya")
cell = cells.get("A12")
cell.putValue("Miya")
cell = cells.get("A13")
cell.putValue("Miya")
cell = cells.get("A14")
cell.putValue("Miya")
cell = cells.get("A15")
cell.putValue("Miya")
cell = cells.get("B2")
cell.putValue(1)
cell = cells.get("B3")
cell.putValue(2)
cell = cells.get("B4")
cell.putValue(3)
cell = cells.get("B5")
cell.putValue(4)
cell = cells.get("B6")
cell.putValue(1)
cell = cells.get("B7")
cell.putValue(2)
cell = cells.get("B8")
cell.putValue(3)
cell = cells.get("B9")
cell.putValue(4)
cell = cells.get("B10")
cell.putValue(4)
cell = cells.get("B11")
cell.putValue(1)
cell = cells.get("B12")
cell.putValue(1)
cell = cells.get("B13")
cell.putValue(2)
cell = cells.get("B14")
cell.putValue(2)
cell = cells.get("B15")
cell.putValue(2)
cell = cells.get("C2")
cell.putValue("Maxilaku")
cell = cells.get("C3")
cell.putValue("Maxilaku")
cell = cells.get("C4")
cell.putValue("Chai")
cell = cells.get("C5")
cell.putValue("Maxilaku")
cell = cells.get("C6")
cell.putValue("Chang")
cell = cells.get("C7")
cell.putValue("Chang")
cell = cells.get("C8")
cell.putValue("Chang")
cell = cells.get("C9")
cell.putValue("Chang")
cell = cells.get("C10")
cell.putValue("Chang")
cell = cells.get("C11")
cell.putValue("Geitost")
cell = cells.get("C12")
cell.putValue("Chai")
cell = cells.get("C13")
cell.putValue("Geitost")
cell = cells.get("C14")
cell.putValue("Geitost")
cell = cells.get("C15")
cell.putValue("Geitost")
cell = cells.get("D2")
cell.putValue("Asia")
cell = cells.get("D3")
cell.putValue("Asia")
cell = cells.get("D4")
cell.putValue("Asia")
cell = cells.get("D5")
cell.putValue("Asia")
cell = cells.get("D6")
cell.putValue("Europe")
cell = cells.get("D7")
cell.putValue("Europe")
cell = cells.get("D8")
cell.putValue("Europe")
cell = cells.get("D9")
cell.putValue("Europe")
cell = cells.get("D10")
cell.putValue("Europe")
cell = cells.get("D11")
cell.putValue("America")
cell = cells.get("D12")
cell.putValue("America")
cell = cells.get("D13")
cell.putValue("America")
cell = cells.get("D14")
cell.putValue("America")
cell = cells.get("D15")
cell.putValue("America")
cell = cells.get("E2")
cell.putValue("China")
cell = cells.get("E3")
cell.putValue("India")
cell = cells.get("E4")
cell.putValue("Korea")
cell = cells.get("E5")
cell.putValue("India")
cell = cells.get("E6")
cell.putValue("France")
cell = cells.get("E7")
cell.putValue("France")
cell = cells.get("E8")
cell.putValue("Germany")
cell = cells.get("E9")
cell.putValue("Italy")
cell = cells.get("E10")
cell.putValue("France")
cell = cells.get("E11")
cell.putValue("U.S.")
cell = cells.get("E12")
cell.putValue("U.S.")
cell = cells.get("E13")
cell.putValue("Brazil")
cell = cells.get("E14")
cell.putValue("U.S.")
cell = cells.get("E15")
cell.putValue("U.S.")
cell = cells.get("F2")
cell.putValue(2000)
cell = cells.get("F3")
cell.putValue(500)
cell = cells.get("F4")
cell.putValue(1200)
cell = cells.get("F5")
cell.putValue(1500)
cell = cells.get("F6")
cell.putValue(500)
cell = cells.get("F7")
cell.putValue(1500)
cell = cells.get("F8")
cell.putValue(800)
cell = cells.get("F9")
cell.putValue(900)
cell = cells.get("F10")
cell.putValue(500)
cell = cells.get("F11")
cell.putValue(1600)
cell = cells.get("F12")
cell.putValue(600)
cell = cells.get("F13")
cell.putValue(2000)
cell = cells.get("F14")
cell.putValue(500)
cell = cells.get("F15")
cell.putValue(900)
# Adding a new List Object to the worksheet
listObject = worksheet.getListObjects().get(worksheet.getListObjects().add("A1", "F15", True))
# Adding Default Style to the table
listObject.setTableStyleType(TableStyleType.TABLE_STYLE_MEDIUM_10)
# Show Total
listObject.setShowTotals(True)
# Set the Quarter field's calculation type
listObject.getListColumns().get(1).setTotalsCalculation(TotalsCalculation.COUNT)
# Save the excel file.
workbook.save(output_directory + "FormatListObject_out.xlsx")