topic Re: in tFileInputExcel how to select the first sheet in Talend Studio

in tFileInputExcel how to select the first sheet

Anonymous — Sat, 16 Nov 2024 14:27:05 GMT

Hi
When using tFileInputExcel I have to gave the name of the sheet I want to use.
Is there a way to tell the component I want to use the first sheet of the excel file (actualy my excel file have only one sheet)
Regards

Re: in tFileInputExcel how to select the first sheet

Anonymous — Tue, 26 Feb 2008 01:37:12 GMT

Hi
There is a sheetName text in the setting panel.
Best regards
shong

Re: in tFileInputExcel how to select the first sheet

Anonymous — Tue, 26 Feb 2008 11:07:05 GMT

Hello Paulo,
I think there is no actual solution for your need. Isn't it possible to ensure that the sheet has every time the same name?
Bye
Volker

Re: in tFileInputExcel how to select the first sheet

Anonymous — Tue, 26 Feb 2008 14:34:47 GMT

I think there is no actual solution for your need. Isn't it possible to ensure that the sheet has every time the same name?

The best thing I could have is to have the sheet name to be PREFIXYYYYMMDD, with PREFIX a constant and YYYYMMDD a constant but could be another day (in the past) than Today.
Maybe I could try with YYYYMMDD with today's date then if error yesterday, then if error the day before....
But not sure it's easy to do
Regards

Re: in tFileInputExcel how to select the first sheet

Anonymous — Tue, 26 Feb 2008 14:48:05 GMT

Hello Paulo,
depending on your java knowledge you can have a look into the generated source. The workbook is accessed with jxl.Workbook. Take a look into the API http://docjar.com/docs/api/jxl/Workbook.html you will find a method getSheetNames().
I'm not sure, but it may be possible access the data in a tJavaFlex and extract the sheet-names.
Bye
Volker

Re: in tFileInputExcel how to select the first sheet

Anonymous — Tue, 26 Feb 2008 15:51:56 GMT

There is a sheetName text in the setting panel.

Shong, the request is to use the first sheet of the Excel workbook (not the one named "shhet1") should I post a feature request ?

Re: in tFileInputExcel how to select the first sheet

Anonymous — Tue, 26 Feb 2008 18:44:41 GMT

Try this:
1) define a context variable: context.firstSheetName
2) Use a tJava_1 component
3) The code inside the tJava_1 should be:

jxl.Workbook workbook = jxl.Workbook.getWorkbook(new java.io.File("C:/Documents and Settings/petrutz/My Documents/TOD-in.xls"));
java.lang.String firstSheetName = new java.lang.String(workbook.getSheetNames());
context.firstSheetName=firstSheetName;
workbook.close();
4) Use a tFileInputExcel
in the SheetName field you should use: context.firstSheetName
5) Use a tLogRow
activate the logging here
6) connect tJava to tFileInputExel with a onSubjobOK to the tFileInputExcel
7) connect the tFileInputExcel to the tLogRow with the main.
Hope it will help.

Re: in tFileInputExcel how to select the first sheet

Anonymous — Wed, 27 Feb 2008 00:32:42 GMT

Try this:
....
Hope it will help.

Yes thank's it's perfect