Formatering av Listobjekt
Formatering av Listobjekt
En tabell är en serie rader och kolumner som innehåller relaterade data som hanteras oberoende av data i andra rader och kolumner. Som standard har varje kolumn i tabellen filtrering aktiverat i huvudraden så att du snabbt kan filtrera eller sortera din listobjektsdata. Du kan lägga till en totalrad (en specialrad i en lista som ger ett urval av aggregeringsfunktioner som är användbara för att arbeta med numeriska data) till listobjektet som ger en nedrullningsbar lista med aggregeringsfunktioner för varje totalradscell.
Aspose.Cells stödjer formatering av Listobjekt. För detta tillhandahåller API:et klasserna ListObject och TableStyleType. Klassen TableStyleType innehåller konstanter som representerar de inbyggda tabellstilarna. Följande kodsnutt skapar ett nytt Listobjekt och anger dess tabellstiltyp till 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") |