Question-How can I read only certain cells from Excel File and sheet?

One Star

Question-How can I read only certain cells from Excel File and sheet?

Hello.
I have a question, I need to read only certain cells from an excel file, but the file contains several sheets. The point is that I need to read on each sheet only columns c6 and c7 (each sheet can have thousands of rows) and make a row with these two values and the sheet name, so if the excel file has 9 sheets I would have 9 rows with the sheet name and the values of each sheet's c6 and c7 columns.
I've searched around here and I found this: https://help.talend.com/search/all?query=Extracting+data+from+specific+Excel+cells&content-lang=en and it's almost what I need but this example works only when the excel file has one sheet, or when you only need to read one sheet.
Can you help me?
Sixteen Stars

Re: Question-How can I read only certain cells from Excel File and sheet?

I've not done this, but I can suggest you try the following. It will only work if the columns are in exactly the same place on every sheet....
1) Create a schema for one columns in the tFileInputExcel component
2) Tick the "All Sheets" tick box in the component
3) Tick the "Affect each sheet (Header and Footer" tick box
4) Set your header number to 5 and your limit to 2 (to handles rows 6 and 7)
5) Set the First Column and Last Column to 3 (to only look at C)

That *should* just pick rows 6 and 7 and column C from every sheet. 
I'd be interested to know if it works :-)
Community Manager

Re: Question-How can I read only certain cells from Excel File and sheet?

Hi
Take a look at community component tFileExcelSheetList shared by Jlolling, this component can be used to iterate all sheets. About how to install a custom component, see
https://help.talend.com/pages/viewpage.action?pageId=190513200
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Question-How can I read only certain cells from Excel File and sheet?

I followed all steps but I can't use that custom component.
Community Manager

Re: Question-How can I read only certain cells from Excel File and sheet?

What do you meant "I can't use that custom component"? You don't find the custom component in the palette after you installed it or you don't know how to use the component correctly?
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Question-How can I read only certain cells from Excel File and sheet?

Sorry, I can't find the component in the palette, if you see the second screenshot I uploaded yesterday you can check it at the right side (Paleta).
Community Manager

Re: Question-How can I read only certain cells from Excel File and sheet?

I have tried to install this component and it is successfully installed, I can see it in the palette, please try again, maybe put the component to a folder without blank space?
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Question-How can I read only certain cells from Excel File and sheet?

I've tried changing folder name without blank space but still doesn't work Smiley Sad
Seventeen Stars

Re: Question-How can I read only certain cells from Excel File and sheet?

Could you please try the Exchange view (on to the top of the studio). Here you should be able to select the components.
Which version of Talend do you run?