格式化列表对象
Contents
[
Hide
]
格式化列表对象
表是包含相关数据的一系列行和列,可以独立于其他行和列中的数据进行管理。默认情况下,表中的每一列都在标题行中启用了过滤,因此您可以快速过滤或排序列表对象数据。您可以向列表对象添加总行(列表中提供一系列与数值数据处理有用的聚合函数有关的特殊行),以便为每个总行单元格提供聚合函数的下拉列表。
Aspose.Cells支持格式化列表对象。为此,API提供了 ListObject 和 TableStyleType 类。TableStyleType 类包含表示内置表样式的常量。以下代码片段创建一个新的列表对象并将其表样式类型设置为 TABLE_STYLE_MEDIUM_10。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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") |