6 Replies Latest reply: Aug 30, 2014 1:21 AM by Jayanthan Sivaloganathan RSS

    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;