Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
sushantkapoor19
Contributor II
Contributor II

read Tab name from an excel dynamically

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.

Labels (2)
1 Solution

Accepted Solutions
Shicong_Hong
Support
Support

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

View solution in original post

3 Replies
Antoine04
Partner - Creator III
Partner - Creator III

Hello,

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

Regards,

Antoine

Shicong_Hong
Support
Support

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

sushantkapoor19
Contributor II
Contributor II
Author

yes 1 worked fine . thanks