TQImport3XLS.Map

property Map: TStrings;

设置数据集字段和Excel单元格之间定义映射属性以下列方式:

FieldName=CellRange

导入单独的单元格

Field1=A1

Field1=A1;B2;C3;

导入整列或者它的一部分

Example	Imported cells
Field1=A1-A10	从A1到 A10
Field1=A10-A1	从 A10 到 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

导入整行或者它的一部分

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

定义特定的表

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

你可以根据需要混合单元范围

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

SkipFirstCols属性

property SkipFirstCols: integer; 

SkipFirstCols 属性定义哪列不导入. 如果你设置 SkipFirstCols=4那么Excel表第4列将不会被导入.

SkipFirstRows属性

property SkipFirstRows: integer; 

SkipFirstRows 属性定义哪行不导入. 如果你设置 SkipFirstRows=4 那么EXCEL表第4行将不会被导入.