loading the data from Excel book with multiple sheets

[#1]

I have the data in sheet 1 , sheet 2 sheet 3 like this but  column names having only in sheet 1  so how can i load the data in the script

[Anonymous · Accepted solution]

you load from sheet1 using file wizard from table files and define Embedded Labels

you load from sheet2 and sheet3 without labels

from sheet2 and sheet3 the scrpt Looks like

Load

@1,

@2,

etc.

you Need to give them the same column names manually

Load

@1 as ColumnName1,

@2 as ColumnName2,

etc.

I suppose that there is no automatic way