LibXL C++ API reference version 5.2.0
- Index Book Sheet Format Font AutoFilter FilterColumn RichString FormControl ConditionalFormatting ConditionalFormat CoreProperties Table ### Table class reference const wchar_t* name() const Returns the name of the table. void setName(const wchar_t* name) Sets the name of the table. const wchar_t* ref() const Returns the range on the sheet for this table. void setRef(const wchar_t* ref) Sets the range on the sheet for this table. bool isAutoFilter() const Returns true if the AutoFilter already exists. AutoFilter* autoFilter() Returns the AutoFilter of the table. Creates it if it doesn't exist. void removeFilter() Removes the AutoFilter from the table. TableStyle style() const Returns the table style. void setStyle(TableStyle tableStyle) Sets the table style.
  TableStyle value | View | TableStyle value | View
  TABLESTYLE_NONE |  | TABLESTYLE_MEDIUM10 |
  TABLESTYLE_LIGHT1 |  | TABLESTYLE_MEDIUM11 |
  TABLESTYLE_LIGHT2 |  | TABLESTYLE_MEDIUM12 |
  TABLESTYLE_LIGHT3 |  | TABLESTYLE_MEDIUM13 |
  TABLESTYLE_LIGHT4 |  | TABLESTYLE_MEDIUM14 |
  TABLESTYLE_LIGHT5 |  | TABLESTYLE_MEDIUM15 |
  TABLESTYLE_LIGHT6 |  | TABLESTYLE_MEDIUM16 |
  TABLESTYLE_LIGHT7 |  | TABLESTYLE_MEDIUM17 |
  TABLESTYLE_LIGHT8 |  | TABLESTYLE_MEDIUM18 |
  TABLESTYLE_LIGHT9 |  | TABLESTYLE_MEDIUM19 |
  TABLESTYLE_LIGHT10 |  | TABLESTYLE_MEDIUM20 |
  TABLESTYLE_LIGHT11 |  | TABLESTYLE_MEDIUM21 |
  TABLESTYLE_LIGHT12 |  | TABLESTYLE_MEDIUM22 |
  TABLESTYLE_LIGHT13 |  | TABLESTYLE_MEDIUM23 |
  TABLESTYLE_LIGHT14 |  | TABLESTYLE_MEDIUM24 |
  TABLESTYLE_LIGHT15 |  | TABLESTYLE_MEDIUM25 |
  TABLESTYLE_LIGHT16 |  | TABLESTYLE_MEDIUM26 |
  TABLESTYLE_LIGHT17 |  | TABLESTYLE_MEDIUM27 |
  TABLESTYLE_LIGHT18 |  | TABLESTYLE_MEDIUM28 |
  TABLESTYLE_LIGHT19 |  | TABLESTYLE_DARK1 |
  TABLESTYLE_LIGHT20 |  | TABLESTYLE_DARK2 |
  TABLESTYLE_LIGHT21 |  | TABLESTYLE_DARK3 |
  TABLESTYLE_MEDIUM1 |  | TABLESTYLE_DARK4 |
  TABLESTYLE_MEDIUM2 |  | TABLESTYLE_DARK5 |
  TABLESTYLE_MEDIUM3 |  | TABLESTYLE_DARK6 |
  TABLESTYLE_MEDIUM4 |  | TABLESTYLE_DARK7 |
  TABLESTYLE_MEDIUM5 |  | TABLESTYLE_DARK8 |
  TABLESTYLE_MEDIUM6 |  | TABLESTYLE_DARK9 |
  TABLESTYLE_MEDIUM7 |  | TABLESTYLE_DARK10 |
  TABLESTYLE_MEDIUM8 |  | TABLESTYLE_DARK11 |
  TABLESTYLE_MEDIUM9 |  |  |
bool showRowStripes() const Returns whether row stripe formatting is applied. void setShowRowStripes(bool showRowStripes = true) Turns on/off row stripe formatting. bool showColumnStripes() const Returns whether column stripe formatting is applied. void setShowColumnStripes(bool showColumnStripes = true) Turns on/off column stripe formatting. bool showFirstColumn() const Returns whether the first column in the table should have the style applied. void setShowFirstColumn(bool showFirstColumn = true) Sets whether the first column in the table should have the style applied. bool showLastColumn() const Returns whether the last column in the table should have the style applied. void setShowLastColumn(bool showLastColumn = true) Sets whether the last column in the table should have the style applied. int columnSize() const Returns the number of columns in the table. const wchar_t* columnName(int columnIndex) const Returns the unique name of the table column with the specified index. bool setColumnName(int columnIndex, const wchar_t* name) Sets the unique name of the table column with the specified index. Please note that if you write the name of the column with the Sheet::writeStr(), the workbook will be corrupted, because the Sheet::writeStr() doesn't check if the specified cell belongs to a table. Index Book Sheet Format Font AutoFilter FilterColumn RichString FormControl ConditionalFormatting ConditionalFormat CoreProperties Table