topic how to use basic setting of tFileInputExcel in Talend Studio

how to use basic setting of tFileInputExcel

Anonymous — Fri, 24 Jun 2016 11:41:54 GMT

Hi everybody,
here it is my excel file
i want to use 2 tFileInputExcel the first one will read from E2 to Q2 and the second one will read from E3 to Q3
I think, to do this i have to use the basic settings :Header, Footer, first column and last column
someone can tell if i am right?
Mallee

Re: how to use basic setting of tFileInputExcel

Anonymous — Mon, 27 Jun 2016 04:36:17 GMT

Hi,
You can use Header, Footer, first column and last column to adjust the positions.
In addition, the Sheet list section of tFileInputExcel gives you the option to specify a regular expression to match the sheet names.
Best regards
Sabrina