LibXL C++ API reference version 5.1.0
Index Book Sheet Format Font AutoFilter FilterColumn RichString FormControl ConditionalFormatting ConditionalFormat CoreProperties Table ### AutoFilter class reference bool getRef(int* rowFirst, int* rowLast, int* colFirst, int* colLast) Gets the cell range of AutoFilter with header. Returns false if error. Get error info with Book::errorMessage(). void setRef(int rowFirst, int rowLast, int colFirst, int colLast) Sets the cell range of AutoFilter with header. FilterColumn column(int colId) Returns the AutoFilter column by zero-based index. Creates it if it doesn't exist. int columnSize() const Returns the number of specified AutoFilter columns which have a filter information. FilterColumn columnByIndex(int index) Returns the specified AutoFilter column which have a filter information by index. bool getSortRange(int* rowFirst, int* rowLast, int* colFirst, int* colLast) Gets the whole range of data to sort. Returns false if error. Get error info with Book::errorMessage(). bool getSort(int* columnIndex, bool* descending) Gets the zero-based index of sorted column in AutoFilter and its sort order. Returns false if error. Get error info with Book::errorMessage(). bool setSort(int columnIndex, bool descending = false) Sets the sorted column in AutoFilter by zero-based index and its sort order. Returns false if error. Get error info with Book::errorMessage(). bool addSort(int columnIndex, bool descending = false) Adds the sorted column in AutoFilter by zero-based index and its sort order. Used for multiple level sorting. Returns false if error. Get an error info with the Book::errorMessage(). Index Book Sheet Format Font AutoFilter FilterColumn RichString FormControl ConditionalFormatting ConditionalFormat CoreProperties Table