topic Re: Read multiple Range data from excel in talend in Talend Studio

Read multiple Range data from excel in talend

Anonymous — Wed, 22 May 2013 17:44:27 GMT

Hi
Can we extract specific range of cells from excel in talend like from below excel sheet i have two data's in single sheet which needs to be extracted and inserted into two different tables.

Re: Read multiple Range data from excel in talend

Anonymous — Wed, 22 May 2013 18:11:05 GMT

You can try tFileExcelSheetInput component, this is a cutomer component on talend exchange:
http://www.talendforge.org/exchange/index.php?eid=663&product=tos&action=view&nav=1,1,1

Re: Read multiple Range data from excel in talend

Anonymous — Tue, 28 May 2013 17:06:33 GMT

I have downloaded the component from exchange and have imported the component as per below link
https://community.talend.com/t5/Design-and-Development/how-to-add-a-component-to-Talend/td-p/76494
but it is not showing in my pallette. i have closed and opened talend again but same thing.
can you suggest me on the same. i am using Talend Open Studio 5.1.1 r84309 version

Re: Read multiple Range data from excel in talend

Anonymous — Wed, 29 May 2013 03:56:04 GMT

Hi Aspirant,
Please see the talend official KB article on talend help center about Installing a custom component.
Best regards
Sabrina

Re: Read multiple Range data from excel in talend

Anonymous — Wed, 29 May 2013 10:50:49 GMT

Sabrina,
Thanks for the link now the components are available in my pallette.
Shong,
How can i read the named range cells like i have mentioned above. using tFileExcelSheetInput and tFileExcelWorkbookOpen components.
Can you help on the same.

Re: Read multiple Range data from excel in talend

Anonymous — Wed, 29 May 2013 12:15:39 GMT

Hi Aspirant
Can you capture a screenshot of your excel file and explain what data you want to extract?
Shong

Re: Read multiple Range data from excel in talend

Anonymous — Wed, 29 May 2013 12:47:56 GMT

Shong,
I have uploaded a screen shot , in that excel i have two data's which are available at different range of cells in same sheet.
i have to extract the two data's and insert into two different tables.
I have also named the range for two data's lets say for fist data named range is 'A' and for 2nd 'B'
suggest me on the same.

Re: Read multiple Range data from excel in talend

Anonymous — Thu, 30 May 2013 12:34:28 GMT

Your use case is terrible.
I would read the rows starting with the row 1.
Read without ignoring empty rows.
In a first tMap I would check about the word id and if you detect it set a particular boolean context var and use it to filter the next rows.
If you detect deptno, you can switch off the boolean context var and the flow should go to another flow.
tFileInputExcel -> tJavaRow (to detect the area and set bool context var) -> tMap (with 2 output flows and filter based on the bool context var).
This is a very weak input source and a better way is by far to talk to the author of this excel file to montivate use different tabs.

Re: Read multiple Range data from excel in talend

alevy — Fri, 31 May 2013 00:45:19 GMT

Since the two blocks of data are going to different tables, why not just use two separate subjobs i.e. separate tFileInputExcel components with the appropriate starting points?

Re: Read multiple Range data from excel in talend

Anonymous — Fri, 31 May 2013 07:04:45 GMT

Jlolling,
Thanks for the reply, the same thing with a slight change i.e if the column name is numeric and when i am tring to use tFileExcelSheetInput and tFileExcelWorkbookOpen components , i am getting error as attached in new images,
Is it something like tFileExcelSheetInput does not support numeric column names or is there any alternative for this to achive.