ListObject Class

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.

type ListObject struct  {
	ptr unsafe.Pointer
}

Constructors

Method	Description

Methods

Method	Description
IsNull	Checks whether the implementation object is nullptr.
GetStartRow	Gets the start row of the range.
GetStartColumn	Gets the start column of the range.
GetEndRow	Gets the end row of the range.
GetEndColumn	Gets the end column of the range.
GetListColumns	Gets ListColumns of the ListObject.
Resize	Resize the range of the list object.
PutCellValue_Int_Int_Object	Put the value to the cell.
PutCellValue_Int_Int_Object_Bool	Put the value to the cell.
PutCellFormula_Int_Int_String	Put the formula to the cell in the table.
PutCellFormula_Int_Int_String_Bool	Put the formula to the cell in the table.
GetShowHeaderRow	Gets and sets whether this ListObject show header row.
SetShowHeaderRow	Gets and sets whether this ListObject show header row.
GetShowTotals	Gets and sets whether this ListObject show total row.
SetShowTotals	Gets and sets whether this ListObject show total row.
GetDataRange	Gets the data range of the ListObject.
UpdateColumnName	Updates all list columns’ name from the worksheet.
GetQueryTable	Gets the linked QueryTable.
GetDataSourceType	Gets the data source type of the table.
Filter	Filter the table.
GetAutoFilter	Gets auto filter.
GetDisplayName	Gets and sets the display name.
SetDisplayName	Gets and sets the display name.
GetComment	Gets and sets the comment of the table.
SetComment	Gets and sets the comment of the table.
GetShowTableStyleFirstColumn	Indicates whether the first column in the table should have the style applied.
SetShowTableStyleFirstColumn	Indicates whether the first column in the table should have the style applied.
GetShowTableStyleLastColumn	Indicates whether the last column in the table should have the style applied.
SetShowTableStyleLastColumn	Indicates whether the last column in the table should have the style applied.
GetShowTableStyleRowStripes	Indicates whether row stripe formatting is applied.
SetShowTableStyleRowStripes	Indicates whether row stripe formatting is applied.
GetShowTableStyleColumnStripes	Indicates whether column stripe formatting is applied.
SetShowTableStyleColumnStripes	Indicates whether column stripe formatting is applied.
ApplyStyleToRange	Apply the table style to the range.
ConvertToRange	Convert the table to range.
ConvertToRange_TableToRangeOptions	Convert the table to range.
GetTableStyleType	Gets and the built-in table style.
SetTableStyleType	Gets and the built-in table style.
GetTableStyleName	Gets and sets the table style name.
SetTableStyleName	Gets and sets the table style name.
GetXmlMap	Gets an XmlMap used for this list.
GetAlternativeText	Gets and sets the alternative text.
SetAlternativeText	Gets and sets the alternative text.
GetAlternativeDescription	Gets and sets the alternative description.
SetAlternativeDescription	Gets and sets the alternative description.