Formatera listobjekt
Contents
[
Hide
]
Formatera 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 aktiverad i rubrikraden så att du snabbt kan filtrera eller sortera dina listobjektdata. Du kan lägga till en totalrad (en speciell rad i en lista som ger ett urval av aggregerade funktioner som är användbara för att arbeta med numerisk data) till listobjektet som tillhandahåller en rullgardinslista med aggregerade funktioner för varje total radcell.
Aspose.Cells stöder formatering av listobjekt. För detta tillhandahåller thee APIListObject ochTableStyleType klasser. DeTableStyleTypeklass innehåller konstanter som representerar de inbyggda tabellstilarna. Följande kodavsnitt skapar ett nytt listobjekt och ställer in det tabellstilstyp tillTABELL_STIL_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") |