Online Documentation for Advanced Data Import for RAD Studio VCL

TQImport3XLSx.Map

 

TQImport3XLSx


 

property Map: TStrings;

 

Description

To set the correspondence between the dataset fields and the Excel 2007 table cells you should define the Map property in the following way:

 

FieldName=CellRange

 

You can define the CellRange string depending on your needs.

 

Separate cells

To import separate cells, define the CellRange string as set of cell identifiers, e.g. A1, B2, C3, separated by semicolon.

 

Example

 

Field1=A1

Field1=A1;B2;C3;

 

Column

To import entire column or its part, define the string in the following format:

 

FieldName=FirstCell-LastCell

 

Example

Imported cells

Field1=A1-A10

From A1 up to A10

Field1=A10-A1

From A10 down to A1

Field1=COLSTART-A10

From the first cell with data in the column A up to A10

Field1=A10-COLSTART

From A10 down to the first cell with data in the column A

Field1=A10-COLFINISH

From A10 up to the last cell with data in the column A

Field1=COLFINISH-A10

From the last cell with data in the column A down to A10

Field1=A1-COLFINISH

From the first up to the last cell with data in the column A

Field1=A1-COLSTART

From the last down to the first cell with data in the column A

 

 

Rows

To import entire row or its part, define the string in the following format:

 

FieldName=FirstCell-LastCell

 

Example

Imported cells

Field1=A1-D1

From A1 up to D1

Field1=D1-A1

From D1 down to D1

Field1=ROWSTART-F1

From the first cell with data in the row 1 up to F1

Field1=F1-ROWSTART

From F1 down to the first cell with data in the row 1

Field1=A10-ROWFINISH

From A10 up to the last cell with data in the row 10

Field1=ROWFINISH-A10

From the last cell with data in the row 10 down to A10

Field1=10-ROWFINISH

From the first up to the last cell with data in the row 10

Field1=10-COLSTART

From the last down to the first cell with data in the row 10

 

 

Defining sheets

To define the speciefic sheet, use the following string format:

 

FieldName=[SheetName]FirstCell-LastCell

or

FieldName=[:SheetNumber]FirstCell-LastCell

 

Example

Imported cells

Field1=[Sheet1]A1-A10

From A1 up to A10 at the sheet named Sheet1

Field1=[:3]A1-A10

From A1 up to A10 at the sheet number 3

 

You can mix cell ranges as you need.

 

Example

 

Field1=A1;A3;A10-A15;A15-D15;D15-COLFINISH;[Sheet1]COLFINISH-A1