Filename and Sheetname

[kash04kk]

Hi All,

I've used the function of getting the filename of Excel workbook in the script like this:

Filename() as Filename

Is there a similar function to get sheet name?

If not, how can I get the name of the sheet of Excel from which the data is loaded?

Thanks

[Clever_Anjos]

You can do that using something like this ODBC to EXCEL in SENSE

[trdandamudi]

Please follow the below link for Qlikview. This link will help you to capture filename and tab names. Hope this helps...

Use Excel Sheet name | Qlik Community