Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

excel upload

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;


Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: excel upload

hi Jagan

issue is resolved with the support of Evan Kurowski

please find below thread for further details

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

6 Replies
MVP & Luminary
MVP & Luminary

Re: excel upload

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.

Not applicable

Re: excel upload

Hi

i following error

Capture.JPG.jpg

Not applicable

Re: excel upload

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

Not applicable

Re: excel upload

hi Jagan

issue is resolved with the support of Evan Kurowski

please find below thread for further details

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

engishfaque
Valued Contributor III

Re: excel upload

Dear Jayanthan,

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

Kind regards,

Ishfaque Ahmed

Not applicable

Re: excel upload

Dear Isfaque

True .I have changed and executed

Thank You

Best Regards

Jayanthan