Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER 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);

jebamalai
Specialist
Specialist

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.

jebamalai
Specialist
Specialist

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.