I have downloaded the component from exchange and have imported the component as per below link http://www.talendforge.org/forum/viewtopic.php?id=25721 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
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.
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.
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.
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.