Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-06-17 12:35 PM

. If an excel file contains multiple sheets with different data\table . how to create a qvd for each sheet present in that excel file?

. If an excel file contains multiple sheets with different data\table . how to create a qvd for each sheet present in that excel file?

388 Views
0 Likes
1 Reply
Clever_Anjos
Employee
Employee
‎2014-06-17 12:40 PM

something like this

where workbook.xls is your file


CONNECT TO [Provider=Microsoft.Jet.OLEDB.4.0;Data Source=workbook.xls;Extended Properties="Excel 8.0;"];

tables:

SQLtables;


FOR i = 0 to NoOfRows('tables')-1
LET sheetName = purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39));
Sales:
LOAD *
FROM workbook.xls (biff, embedded labels, table is [$(sheetName)]);
NEXT

263 Views