TLocationOptions Class

Defines which rows and columns to export from the grid and into which rows and columns in Excel.

Syntax

Unit: UAdvGridExcelBridgeCore

TLocationOptions = class(TPersistent);

Constructors

Name	Description
Create	Creates a new TLocationOptions object.

Methods

Name	Description
Assign	Copies source into this object.

Properties

Name	Description
GridStartRow	The first row of the grid to export. Note that this is 0-based, but the first row is normally the headers of the grid. As you normally want to export just the data and not the headers, the default value is 1.
GridStartCol	The first column of the grid to export. Note that this is 0-based, but the first column is normally the headers of the grid. As you normally want to export just the data and not the headers, the default value is 1.
XlsStartRow	Row in Excel where the first row of the grid will go. This is 1-based, so 1 means the first row in Excel.
XlsStartCol	Column in Excel where the first column of the grid will go. This is 1-based, so 1 means column "A" in Excel.