topic Re: Extracting data from specific excel cells in multiple sheet in Talend Studio

Extracting data from specific excel cells in multiple sheet

yau1656602455 — Fri, 01 Jul 2022 03:45:09 GMT

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

Re: Extracting data from specific excel cells in multiple sheet

Anonymous — Sat, 02 Jul 2022 09:37:58 GMT

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

Re: Extracting data from specific excel cells in multiple sheet

yau1656602455 — Sat, 02 Jul 2022 15:28:56 GMT

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.

Re: Extracting data from specific excel cells in multiple sheet

InfoCraft — Sat, 02 Jul 2022 18:36:56 GMT

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.