Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.Join Us
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.
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.