topic Get the sheet names into a Field in QlikView

Get the sheet names into a Field

Wed, 21 Apr 2010 08:01:21 GMT

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.

Get the sheet names into a Field

Wed, 21 Apr 2010 08:07:09 GMT

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)$)

Get the sheet names into a Field

Wed, 21 Apr 2010 08:35:14 GMT

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

Get the sheet names into a Field

Wed, 21 Apr 2010 09:34:01 GMT

Hi Rajesh/Sridhar,

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

Thanks,

Chandan.