topic Re: read Tab name from an excel dynamically in Talend Studio

read Tab name from an excel dynamically

sushantkapoor19 — Mon, 10 Jun 2024 09:06:38 GMT

Hello,

I have the below requirement to read the data from 2nd tab of an excel. Tab name is something like "COMP BPC CoA v12.1". Now the version name will change every time. this time it is 12.1, next time, i could be 13.1 or something else. so, i would like to pass string "COMP BPC CoA*" in sheetlist of my texcelfileinput component. i tried several ways, but it did not work. i passed sheet number 2 and it did not work. i dont want to hard copy the tab name in sheet (name or position).

Can you please help me how to give this in regex expression or how can i pass sheet number ?? pls help.its urgent.

Re: read Tab name from an excel dynamically

Antoine04 — Mon, 10 Jun 2024 12:49:44 GMT

Hello,

Where is your Excel file ? Is it on a Sharepoint ? Or directly in a DataFile ?

Regards,

Antoine

Re: read Tab name from an excel dynamically

Shicong_Hong — Thu, 13 Jun 2024 09:44:15 GMT

The position starts with 0, so set the number to 1 for the 2nd tab of an excel.

Re: read Tab name from an excel dynamically

sushantkapoor19 — Thu, 13 Jun 2024 09:50:50 GMT

yes 1 worked fine . thanks