topic Re: excel upload in QlikView

excel upload

Fri, 29 Aug 2014 12:37:32 GMT

Hi all

i have tried to upload in xlsx files (about 6 or seven excel file) , but Qlikview shows file not found error message.

Please find the script below

Directory f:\Finance\monthly_summaries;
For each ExcelFile in filelist ('*.xlsx')
EOM_HISTORY:

Load * From $(ExcelFile) (ooxml, embedded labels, table is [EOM_SHEET$]);
Next ExcelFile;

Re: excel upload

jagan — Fri, 29 Aug 2014 12:49:25 GMT

Hi,

Try like this

EOM_HISTORY:

Load *

From

[f:\Finance\monthly_summaries\*.xlsx] (ooxml, embedded labels, table is [EOM_SHEET$]);

Is F: drive is your local machine drive? If yes it will work otherwise if it is shared drive the you need to give the actual path like \\10.10.29.38\SomeFolder.

No need of Loop, hope it helps you.

Regards,

Jagan.

Re: excel upload

Sat, 30 Aug 2014 02:29:30 GMT

i following error

Re: excel upload

Sat, 30 Aug 2014 02:30:23 GMT

i get the above error message when i load them, what could be the reason

Re: excel upload

Sat, 30 Aug 2014 04:51:50 GMT

hi Jagan

issue is resolved with the support of Evan Kurowski

please find below thread for further details

http://community.qlik.com/thread/131307

Re: excel upload

engishfaque — Sat, 30 Aug 2014 04:58:06 GMT

Dear Jayanthan,

here is the problem "[EOM_SHEET$]", remove dollar sign [EOM_SHEET]. I hope this will help you.

Kind regards,

Ishfaque Ahmed

Re: excel upload

Sat, 30 Aug 2014 05:21:11 GMT

Dear Isfaque

True .I have changed and executed

Thank You

Best Regards

Jayanthan