TXlsFile.GetColOptions Method
Returns all Column options at once (if the column is hidden, etc).
Remarks
To get individual values, use the corresponding methods (i.e. TExcelFile.GetColHidden) Use this method only to copy the options from one column to another.
Syntax
Unit: FlexCel.XlsAdapter
function TXlsFile.GetColOptions(const col: Integer): Integer; override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | col | Integer | Column Index (1 based) |
Examples
To copy all the column options from column 1 to 2, use
xls.SetColOptions(2, xls.GetColOptions(1));
This is faster and simpler than assigning each option alone.