Online Documentation for Advanced Data Import for RAD Studio VCL
TQImport3XLS.Map
property Map: TStrings;
Description
To set the correspondence between the dataset fields and the Excel 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=A-COLFINISH |
From the first up to the last cell with data in the column A |
|
Field1=A-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
See also:
Map property (TQImport3)
