Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

How to load Excel sheet names in QlikView and Qlik Sense

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

How to load Excel sheet names in QlikView and Qlik Sense

Last Update:

Jul 26, 2021 9:31:23 AM

Updated By:

Sonja_Bauernfeind

Created date:

Aug 22, 2018 6:00:19 AM

The native Excel reader in QlikView/ Qlik Sense can only read sheets by number (for example LOAD * FROM [./Sales.xls] (biff, no labels, table is @2); ) and not by name.

A solution is to read Excel files via an ODBC connection (for example the default "Excel Files" ODBC connection in Windows), and use SQLTables statement to load the list of sheet names as field TABLE_NAME. Documentation of this script statement can be found on the QlikView help site at SQLTables

Excel Files 64 bit platform User DSN.png

 

Environments:

Qlik Sense Enterprise on Windows 
QlikView 

Labels (1)
Contributors
Version history
Last update:
‎2021-07-26 09:31 AM
Updated by: