Qlik® | Support Portal
Quick Links
Contact
Find Answers

Join Qlik Community

Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.

Join Us
Get Support

Have a Question?

Search Qlik's Support knowledge database or request assisted support for your highly complex issues.

Submit a Case
Talk with a Representative

Critical Issues

Experiencing a serious product issue? Please Contact us by phone. Click here to view phone numbers and hours by region.

Contact Us
My Account
Welcome Guest
×
Knowledge

How to load Excel sheet names

Article Number: 000055231 | Last Modified: 2019/01/17

Description

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

User-added image

Refer to this community post https://community.qlik.com/message/589469 for a working example of loading sheet names.

Environment: 

  • QlikView all versions
  • Qlik Sense all versions


 

Was this content helpful?

   

Get Answers

Find Answers

Qlik Community

Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.

Join Us
Get Support

Have a Question?

Search Qlik's Support Knowledge database or request assisted support for highly complex issues.

Submit a case
Talk with a Representative

Critical Issues

Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.