ListObject Class |
Namespace: Aspose.Cells.Tables
The ListObject type exposes the following members.
Name | Description | |
---|---|---|
![]() | AlternativeDescription |
Gets and sets the alternative description.
|
![]() | AlternativeText |
Gets and sets the alternative text.
|
![]() | AutoFilter |
Gets auto filter.
|
![]() | Comment |
Gets and sets the comment of the table.
|
![]() | DataRange |
Gets the data range of the ListObject.
|
![]() | DataSourceType |
Gets the data source type of the table.
|
![]() | DisplayName |
Gets and sets the display name.
|
![]() | EndColumn |
Gets the end column of the range.
|
![]() | EndRow |
Gets the end row of the range.
|
![]() | ListColumns |
Gets ListColumns of the ListObject.
|
![]() | QueryTable |
Gets the linked QueryTable.
|
![]() | ShowHeaderRow |
Gets and sets whether this ListObject show header row.
|
![]() | ShowTableStyleColumnStripes |
Indicates whether column stripe formatting is applied.
|
![]() | ShowTableStyleFirstColumn |
Indicates whether the first column in the table should have the style applied.
|
![]() | ShowTableStyleLastColumn |
Indicates whether the last column in the table should have the style applied.
|
![]() | ShowTableStyleRowStripes |
Indicates whether row stripe formatting is applied.
|
![]() | ShowTotals |
Gets and sets whether this ListObject show total row.
|
![]() | StartColumn |
Gets the start column of the range.
|
![]() | StartRow |
Gets the start row of the range.
|
![]() | TableStyleName |
Gets and sets the table style name.
|
![]() ![]() | TableStyleType |
Gets and the built-in table style.
|
![]() | XmlMap |
Gets an XmlMap used for this list.
|
Name | Description | |
---|---|---|
![]() | ApplyStyleToRange |
Apply the table style to the range.
|
![]() | ConvertToRange |
Convert the table to range.
|
![]() | ConvertToRange(TableToRangeOptions) |
Convert the table to range.
|
![]() | Equals | (Inherited from Object.) |
![]() | Filter |
Filter the table.
|
![]() | Finalize | (Inherited from Object.) |
![]() | GetHashCode | (Inherited from Object.) |
![]() | GetType | (Inherited from Object.) |
![]() | MemberwiseClone | (Inherited from Object.) |
![]() | PutCellValue |
Put the value to the cell.
|
![]() | Resize |
Resize the range of the list object.
|
![]() | ToString | (Inherited from Object.) |
![]() | UpdateColumnName |
Updates all list columns' name from the worksheet.
|
[C#] Workbook workbook = new Workbook(); Cells cells = workbook.Worksheets[0].Cells; for (int i = 0; i <5; i++) { cells[0,i].PutValue(CellsHelper.ColumnIndexToName(i)); } for (int row = 1; row <10; row++) { for (int column = 0; column <5; column++) { cells[row, column].PutValue(row * column); } } ListObjectCollection tables = workbook.Worksheets[0].ListObjects; int index = tables.Add(0, 0, 9, 4, true); ListObject table = tables[0]; table.ShowTotals = true; table.ListColumns[4].TotalsCalculation = Aspose.Cells.Tables.TotalsCalculation.Sum; workbook.Save(@"Book1.xlsx"); [Visual Basic] Dim workbook As Workbook = New Workbook() Dim cells As Cells = workbook.Worksheets(0).Cells For i As Int32 = 0 To 4 cells(0, i).PutValue(CellsHelper.ColumnIndexToName(i)) Next For row As Int32 = 1 To 9 For column As Int32 = 0 To 4 cells(row, column).PutValue(row * column) Next Next Dim tables As ListObjectCollection = workbook.Worksheets(0).ListObjects Dim index As Int32 = tables.Add(0, 0, 9, 4, True) Dim table As ListObject = tables(0) table.ShowTotals = True table.ListColumns(4).TotalsCalculation = Aspose.Cells.Tables.TotalsCalculation.Sum workbook.Save("Book1.xlsx")