TXlsFile.SetColOptions Method
Sets all Column options at once (if the column is hidden, etc).
Remarks
To set individual values, use the corresponding methods (i.e. TExcelFile.SetColHidden(Integer, Integer, Boolean)) Use this method only to copy the options from one column to another.
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.SetColOptions(const col: Integer; const options: Integer); override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | col | Integer | Column Index (1 based) |
const | options | Integer | A flag with all column options. |
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.