How to load Excel sheet namesArticle Number: 000055231 | Last Modified: 2019/01/17
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 QlikView help site at https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptRegularStatements/SQLTables.htm
Refer to this community post https://community.qlik.com/message/589469 for a working example of loading sheet names.
- QlikView all versions
- Qlik Sense all versions
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.