リスト オブジェクトの書式設定
Contents
[
Hide
]
リスト オブジェクトの書式設定
テーブルは、他の行や列のデータとは独立して管理される関連データを含む一連の行と列です。既定では、テーブルのすべての列のヘッダー行でフィルター処理が有効になっているため、リスト オブジェクト データをすばやくフィルター処理または並べ替えることができます。各合計行セルの集計関数のドロップダウン リストを提供するリスト オブジェクトに、合計行 (数値データの操作に役立つ集計関数の選択を提供するリスト内の特別な行) を追加できます。
Aspose.Cells は、List オブジェクトの書式設定をサポートしています。このために、あなた API はListObjectと表スタイルの種類クラス。の表スタイルの種類クラスには、組み込みのテーブル スタイルを表す定数が含まれています。次のコード スニペットは、新しい List オブジェクトを作成し、テーブル スタイル タイプをテーブル_スタイル_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") |