Iterate excel sheet name

One Star

Iterate excel sheet name

hi
i have a excel file with many sheets, the sheet name like 'a..','b..','8..','8..','8..' .
i want extract data from sheet name like '8..'
what can i do? can i iterate sheets?
Moderator

Re: Iterate excel sheet name

Hi,
Have you already checked component TalendHelpCenter:tFileInputExcel with
the sheet list option to extract data from specific sheet.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Iterate excel sheet name

Hi,
You can iterate on sheets and also can use regular expression to define name of input sheet or can have a name like "8*.*".
Whether the metadata for all the sheets is going to be same??
If your sheet names are constant, you can put it in one csv file and iterate through each sheetname to read that sheet from excel file,.. this is also possible.
Thanks
Vaibhav

Calling Talend Open Studio Users

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

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

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

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog