Extracting data from specific excel cells in multiple sheet

[yau1656602455]

Hi All,

I need to extract specific cells in multiple sheet (also in multiple files with same schema), and follow this documentation

https://help.talend.com/r/en-US/8.0/excel/extracting-data-from-specific-excel-cells, and already success with single sheet. But how to do this in multiple sheet? the cells that I want to extract only in red box.

I try to enable All sheets and Affect each sheet(header&footer) in tFileInputExcel, but the result from tLog is only 1 row. Is there any doc related to my case, please drop the link. Thanks

[Anonymous]

Hi

You will have only the last row, because it will extract data from all sheets and then iterate the data row by row. One question, do you have the fixed number of sheets or the number may change.

Regards

Shong

[yau1656602455]

Hi @Shicong Hong​ ,

The number of sheets is not fixed, dynamically can change. Do you suggest to create component to each sheets? or is it possible to use something like looping to execute job by list of sheets? many thanks.

[Covid19 · Accepted solution]

Hi @bagus dwiyanu​,

If it works fine for a sheet, just iterate over each sheet name

 

Otherwise here is a second tip

 

Kind regards,

😷19.