Reading Multiple Sheets Using tFileInputExcel

Four Stars

Reading Multiple Sheets Using tFileInputExcel

Hello, everyone. I am new to Talend and will really appreciate your help. I am using Talend 6.3. I have one excel file having multiple sheets(Total 4 sheets) and I want to read data data from all sheets and populate it in tGreenplumpOutput if possible. I have tried using:

tGreenplumConnection -> tParallelize -> tFileInputExcel(Total 4 components for 4 sheets) -> tGreenplumOutput(Total 4 components for 4 tFileInputExcel)


The rows count is getting paused whenever I run the job. Please help me to rectify this issue or suggest me an alternative solution for this in you have any Smiley Happy .

Nine Stars

Re: Reading Multiple Sheets Using tFileInputExcel

I am assuming for all the 4 sheets you have same number of columns, so the schema remains same. In that case why not select the option - "All Sheets" for tFileInputExcel. So, your job would look like:

tGreenplumConnection -> on subjobok -> tFileInputExcel -> main -> tGreenplumOutput

                                                                   tFileInputExcel -> on subjob ok -> tGreenplumCommit

Four Stars

Re: Reading Multiple Sheets Using tFileInputExcel

Thank you for your reply Abhishek.
All the 4 sheets are having different number of columns. So this approach will not work I guess.


Re: Reading Multiple Sheets Using tFileInputExcel

Hi Chirag,


      Could you please add tlogrow instead of Greenplum and see the result. I guess it will work fine in that case. So issue could be at the loading part to Greenplum.


       On a different note, are you trying to load the data from all sheets to same table? If you want to load Sheet1 to TableA, Sheet2 to TableB, etc. then you need to add the Sheet names in the excel input component. 


Warm Regards,


Nikhil Thampi



Four Stars

Re: Reading Multiple Sheets Using tFileInputExcel

Thank you Nikhil for your reply.

I will try this alternative solution as you suggested by using tlogrow instead of greenplum.

I am loading Sheet 1 to Table A, Sheet 2 to Table B, etc.. and I have mentioned the Sheet name in the tFileInputExcel's Sheet List.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey


Talend named a Leader.

Get your copy


Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables


How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration


Downloads and Trials

Test drive Talend's enterprise products.