topic Re: [resolved] TFileExcelSheetList - possible to select on sheet name ? in Talend Studio

[resolved] TFileExcelSheetList - possible to select on sheet name ?

andymahieu — Tue, 02 Dec 2014 10:42:54 GMT

Hi Jan,
Is this possible with your component or do I have to try to catch that further in the job ?
Also, when I try to select with the sheet index, it doesn't seem to work but I think I use the wrong syntax.
Is it "Sheet.{1,2}" ? I took it over from Talend Exchange but on the screenshot it's not so clear...
Gr
Andy

Re: [resolved] TFileExcelSheetList - possible to select on sheet name ?

Anonymous — Tue, 02 Dec 2014 12:16:22 GMT

there are some costume components available to read and write excel sheet, if you are interested then check on below link.
tFileExcelSheetInput

Re: [resolved] TFileExcelSheetList - possible to select on sheet name ?

andymahieu — Tue, 02 Dec 2014 12:26:01 GMT

Hi Umesh,
Thanks for your reply. I'm already using the components of jlolling. They work good but I have questions on one of the components.
Gr
Andy

Re: [resolved] TFileExcelSheetList - possible to select on sheet name ?

Anonymous — Tue, 02 Dec 2014 13:32:44 GMT

The documentation of the component tFileExcelSheetList is not done yet. It is a to-do what I have.
The component tFileExcelSheetList iterates through the sheets of the workbook (it does not read the content of the sheets).
You can filter the sheets with regularly expressions (as the screenshot shows: in this case you would get all sheets which name starts with Store and a space and a 1- or 2-digit number).
The purpose is to use the iterate flow to a tFileExcelSheetInput and read here the content of the sheets you have chosen.

Re: [resolved] TFileExcelSheetList - possible to select on sheet name ?

andymahieu — Tue, 02 Dec 2014 14:02:37 GMT

Hi Mr Lolling,
I can't see your screenshot.
Gr
andy

Re: [resolved] TFileExcelSheetList - possible to select on sheet name ?

Anonymous — Tue, 02 Dec 2014 14:22:34 GMT

Sorry I mean the screenshot of the component and my text does also not match with this screenshot.
The screenshot shows as regex: Sheet.{1,2}
This means: filter all sheets which starts with the text "Sheet" + one arbitrary char + 1 or 2 numbers.
https://www.talendforge.org/exchange/index.php?eid=1263&product=tos&action=view&nav=1,1,1
You can for sure also simple name every sheet you need as one line in this list. Unfortunately a number is not possible (I will check how to enable it in the next release).

Re: [resolved] TFileExcelSheetList - possible to select on sheet name ?

andymahieu — Tue, 02 Dec 2014 22:13:53 GMT

Hi Mr Lolling,
Thanks for your answer. It worked for me.
I had to get the sheets starting with AFR-ZONE or AFR-MAG and followed by 2 numbers or characters...

Gr
Andy Mahieu

Re: [resolved] TFileExcelSheetList - possible to select on sheet name ?

Anonymous — Wed, 03 Dec 2014 06:04:47 GMT

Sorry, could you please repost your image, I can only see a huge Base64 code block.

Re: [resolved] TFileExcelSheetList - possible to select on sheet name ?

andymahieu — Wed, 03 Dec 2014 14:02:04 GMT

Hi Mr Lolling,
Thanks for your answer. It worked for me.
And the component is very usefull. I think I will use it a lot in the future.
I had to get the sheets starting with AFR-ZONE or AFR-MAG and followed by 2 numbers or characters...
These are the images that didn't seem to come through yesterday.
These are some of the different sheets in my excel :

This is the Talend job :

This is now the selection on the sheets in the TfileExcelSheetList component :

Gr
andy

Re: [resolved] TFileExcelSheetList - possible to select on sheet name ?

Anonymous — Wed, 03 Dec 2014 14:09:27 GMT

Hi Andy,
I cannot see any screenshot. But anyway, if it works it is ok. If you mind you could rate the component in Talend Exchange.
http://www.talendforge.org/exchange/index.php?eid=1263&product=tos&action=view&nav=1,1,1