Table$1

type Table$1 = {
  columns: TableColumn[];
  headerRowCount?: integer;
  name: string;
  ref: CellRange;
  sheet: string;
  style?: TableStyle;
  totalsRowCount?: integer;
  totalsRowShown?: boolean;
};

Properties

Property	Type	Description
columns	TableColumn[]	An array of column objects. They shall be ordered from left to right, so that the first column corresponds to the leftmost column in the referenced range and the last column corresponds to the rightmost column.
headerRowCount?	integer	A non-negative integer specifying the number of header rows at the top of the table. Default to 1 if absent. Default 1
name	string	The name of the table. This name must adhere to the same restrictions as defined names in Excel. In particular, it cannot contain spaces.
ref	CellRange	A non-prefixed range reference to the area containing the table. The range shall include the column headers.
sheet	string	The name of the sheet in which the table is located.
style?	TableStyle	Presentation information for the table. When not present tables should be rendered using "TableStyleMedium2" style with TableStyle.showRowStripes set to true.
totalsRowCount?	integer	A non-negative integer specifying the number of totals rows at the bottom of the table. Default to 0 if absent. Default 0
totalsRowShown?	boolean	Whether the totals row is shown. When false, the totals row is hidden. Default true