Discussion Board for collaboration on QlikView Scripting.
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
For each ExcelFile in filelist ('*.xlsx')
Load * From $(ExcelFile) (ooxml, embedded labels, table is [EOM_SHEET$]);
Solved! Go to Solution.
Try like this
[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.