ListObject

ListObject class

Represents a list object on a worksheet. The ListObject object is a member of the ListObjects collection. The ListObjects collection contains all the list objects on a worksheet.

public class ListObject

Properties

Name Description
AlternativeDescription { get; set; } Gets and sets the alternative description.
AlternativeText { get; set; } Gets and sets the alternative text.
AutoFilter { get; } Gets auto filter.
Comment { get; set; } Gets and sets the comment of the table.
DataRange { get; } Gets the data range of the ListObject.
DataSourceType { get; } Gets the data source type of the table.
DisplayName { get; set; } Gets and sets the display name.
EndColumn { get; } Gets the end column of the range.
EndRow { get; } Gets the end row of the range.
ListColumns { get; } Gets ListColumns of the ListObject.
QueryTable { get; } Gets the linked QueryTable.
ShowHeaderRow { get; set; } Gets and sets whether this ListObject show header row.
ShowTableStyleColumnStripes { get; set; } Indicates whether column stripe formatting is applied.
ShowTableStyleFirstColumn { get; set; } Indicates whether the first column in the table should have the style applied.
ShowTableStyleLastColumn { get; set; } Indicates whether the last column in the table should have the style applied.
ShowTableStyleRowStripes { get; set; } Indicates whether row stripe formatting is applied.
ShowTotals { get; set; } Gets and sets whether this ListObject show total row.
StartColumn { get; } Gets the start column of the range.
StartRow { get; } Gets the start row of the range.
TableStyleName { get; set; } Gets and sets the table style name.
TableStyleType { get; set; } Gets and the built-in table style.
XmlMap { get; } Gets an XmlMap used for this list.

Methods

Name Description
ApplyStyleToRange() Apply the table style to the range.
ConvertToRange() Convert the table to range.
ConvertToRange(TableToRangeOptions) Convert the table to range.
Filter() Filter the table.
PutCellValue(int, int, object) Put the value to the cell.
Resize(int, int, int, int, bool) Resize the range of the list object.
UpdateColumnName() Updates all list columns’ name from the worksheet.

Examples


[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")

See Also