6 Replies Latest reply: Sep 3, 2013 5:58 AM by Sudeep Mahapatra RSS

    How to automatically load .xlsx file into Qlikview

      I've tried below script and it works for .xls :

       

      SET MODELED_Folder="C:\Users\Administrator\Desktop\MY_Report";


      for each file in filelist('$(MODELED_Folder)\*.xls')

      load*

      from $(file)(biff, embedded labels, table is Sheet1$);

      next file

       

      However, I cannot change it for .xlsx file.

      I tried to change the format to "ooxml", but it doesn't work.......

       

      Anybody has the solution for .xlsx?

       

      Will be much appreciated.... thank you