Get the sheet names into a Field

[#1]

Hi All,

I have a excel which contains 1000 sheets with different names, So i want to bring that excel sheet names into a field, How can i achive this one.

Thanks,

Chandan.

[#2]

Hi Chandan,

One way of bringing the sheet name is;

For each a in 'SH1','SH2','SH3'

Load X, Y, Z, $(a) as SheetName from abc.xls (biff, embedded labels, table is $(a)$)

Next

[#3]

Hi,

One more option would be connecting Qlikview to excel via ODBC. Once you created a ODBC connection to excel then you can pull 'n' number of sheets from a excel with out specifying the sheet names any where in qlikview and you can get the name of the sheets as field information in qlikview.

For more details have a look at the below link.

http://qlikviewnotes.blogspot.com/2008/09/loading-multiple-excel-sheets.html

-Sridhar

[#4]

Hi Rajesh/Sridhar,

Thank you for your quick reply.Let me try and get back to You.

Thanks,

Chandan.