
Digital Support
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to load Excel sheet names in QlikView and Qlik Sense
Last Update:
Jul 26, 2021 9:31:23 AM
Updated By:
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
Environments:
4,621 Views