read Tab name from an excel dynamically

[sushantkapoor19]

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.

[Antoine04]

Hello,

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

Regards,

Antoine

[Shicong_Hong · Accepted solution]

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

[sushantkapoor19]

yes 1 worked fine . thanks