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')


      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