Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
The position starts with 0, so set the number to 1 for the 2nd tab of an excel.
Hello,
Where is your Excel file ? Is it on a Sharepoint ? Or directly in a DataFile ?
Regards,
Antoine
The position starts with 0, so set the number to 1 for the 2nd tab of an excel.
yes 1 worked fine . thanks