Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Retrieving Spreadsheet names

Hi Experts,

How to get the excel spreadsheet names without ODBC .

Thanks & Regards,

Ramu.

4 Replies
MVP & Luminary
MVP & Luminary

Re: Retrieving Spreadsheet names

Read them yourself using your eyeballs. Otherwise you will need an ODBC connection.


talk is cheap, supply exceeds demand
Not applicable

Re: Retrieving Spreadsheet names

not sure what you mean

are you reading data from a spreadhseet?  If so, when you go through the tables file wizard, it will display the names of the spredsheets in the Excel file.  If there are more than 1 sheet that you need to read from, you will need to do a seperate load for each sheet, and change the name

gardenierbi
Contributor

Re: Retrieving Spreadsheet names

Like Gysbert said, only throught ODBC. In older versions you could reference to a sheet with @1 for the first sheet, @2 for the second sheet etc but this isn't working anymore!

MVP & Luminary
MVP & Luminary

Re: Retrieving Spreadsheet names

An external vbs-script triggered per execute-statement might be an alternatively:

Re: Re: Use excel sheet name in field.

Re: Run Excel from QMC

- Marcus