格式化列表对象

格式化列表对象

表是包含相关数据的一系列行和列,可以独立于其他行和列中的数据进行管理。默认情况下,表中的每一列都在标题行中启用了过滤,因此您可以快速过滤或排序列表对象数据。您可以向列表对象添加总行(列表中提供一系列与数值数据处理有用的聚合函数有关的特殊行),以便为每个总行单元格提供聚合函数的下拉列表。

Aspose.Cells支持格式化列表对象。为此,API提供了 ListObjectTableStyleType 类。TableStyleType 类包含表示内置表样式的常量。以下代码片段创建一个新的列表对象并将其表样式类型设置为 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")