Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error while loading excel file?


Hi,

Can anyone help me with below error please?

thanks.

16 Replies
amit_saini
Master III
Master III

Amelia ,

You can load all those excel sheet in one shot. Please follow my comment here below:

. If an excel file contains multiple sheets wit... | Qlik Community

Thanks,

AS

Not applicable
Author

I have used the below one

tables:
SQLTables;

DISCONNECT;

Tables1:
load
*,
replace(TABLE_NAME,chr(39),'') as NEW
resident tables;

DROP Table tables;



let var=NoOfRows('Tables1');


FOR i = 0 to $(var)-1
let sheetName=subfield(peek('NEW', i,'Tables1'),'$',1);

[$(sheetName)]:

Fact:
LOAD Id
    

FROM
[..\Source_Conversion\Creditor Meeting Split.xlsx]
(ooxml, embedded labels, table is [$(sheetName)]);

NEXT i

 
DROP Table Tables1;


STORE Fact into C:\Qlikview\table.qvd (qvd);

Anonymous
Not applicable
Author

ThornOfCrowns
Specialist II
Specialist II

And does this work?

Not applicable
Author

I used the same. But the problem is it is showing ODBC error. please help how to set this.

Anonymous
Not applicable
Author

send me the code you have used and the error details

jerrysvensson
Partner - Specialist II
Partner - Specialist II

Yes it works if you have installed Excel on your publisher machine.