How to Read all the sheets in a excel which follow a specific format.

[Ray0801]

Hi Team,

I have a excel which has multiple sheets I need to read some specific sheets that follow a format for

eg-MonthName_Sheet or Q1/Q2/Q3

How can I mention the sheet name dynamically in tinputExcel Component. So that it reads all the sheets with similar format.

[Anonymous]

Hello,

So far, Talend don't support the dynamic schema for tFileInputExcel component yet

Are you able to create a "File Excel" metadata to automatically set the schema?

Here is online documentation about: TalendHelpCenter: Centralizing File Excel metadata

Best regards

Sabrina

[Ray0801]

@Xiaodi Shi​  All my sheets have the same schema,so no issue with that.

I just want my talend job to search all the sheets in the file and extract only specific sheets that follows a pattern for eg:MMM_Sheet

[Ray0801]

@Xiaodi Shi​ I tried using regex ".*_Sheet" But it is reading only the first sheet while they are other sheets in the excel too with the same pattern.

[Anonymous]

Hello,

Please have a look at this documentation about: TalendHelpCenter: Extracting data from specific Excel cells

Feel free to let us know if it works for your case.

In addition to that, there are some tFileExcel-Components custom components from Talend Exchange. Hope it will help.

Best regards

Sabrina