ListObject Class

ListObject class

Represents a table in 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 the ListColumn list of this table.
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 Table shows header row.
SetShowHeaderRow	Gets and sets whether this Table shows header row.
GetShowTotals	Gets and sets whether this TAble shows total row.
SetShowTotals	Gets and sets whether this TAble shows total row.
GetDataRange	Gets the data range of the Table.
UpdateColumnName	Updates all list columns’ name to cells in the table.
GetQueryTable	Gets the linked QueryTable.
GetDataSourceType	Gets the data source type of the table.
GetHasAutoFilter	Indicates whether auto filter is applied to this table.
SetHasAutoFilter	Indicates whether auto filter is applied to this table.
RemoveAutoFilter	Removes auto filter which is applied to this table.
GetAutoFilter	Gets auto filter of this table.
GetDisplayName	Gets and sets the display name of the table.
SetDisplayName	Gets and sets the display name of the table.
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 is the style applied to.
SetShowTableStyleFirstColumn	Indicates whether the first column in the table is the style applied to.
GetShowTableStyleLastColumn	Indicates whether the last column in the table is the style applied to.
SetShowTableStyleLastColumn	Indicates whether the last column in the table is the style applied to.
GetShowTableStyleRowStripes	Indicates whether row stripe formatting is applied to.
SetShowTableStyleRowStripes	Indicates whether row stripe formatting is applied to.
GetShowTableStyleColumnStripes	Indicates whether column stripe formatting is applied to.
SetShowTableStyleColumnStripes	Indicates whether column stripe formatting is applied to.
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.