extracting part of excel file name in QLIK

[arusanah]

Hello Qlikers,

when i load a file from a location and need to get table information from file type part of file.

e.g below is my file . i need to extract Sheet1  from file type to store in a variable.

FROM [lib://AttachedFiles/abc.xlsx]
(ooxml, embedded labels, table is Sheet1);

Any help is much appreciated.

thanks

Arusana