TExcelFile.CopyColFormats Method
Copies the column definitions, that is formats, widths, hidden/visible, etc from one workbook or sheet to another.
Syntax
Unit: FlexCel.Core
procedure TExcelFile.CopyColFormats(const sourceWorkbook: TExcelFile; const sourceSheet: Integer; const sourceCol: Integer; const destCol: Integer; const colCount: Integer); virtual; abstract;Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| const | sourceWorkbook | TExcelFile | The workbook from where the column formats will be copied. If you set this to null, the column formats will be copied from the same file. |
| const | sourceSheet | Integer | Sheet in the source workbook from where we will copy the column formats. |
| const | sourceCol | Integer | First column format to copy |
| const | destCol | Integer | First column where the format will be copied. |
| const | colCount | Integer | Number of columns to copy. |