2 Replies Latest reply: Oct 23, 2012 11:29 PM by Johannes Sunden RSS

    Excel data source

      Hi all


      How can I convert a bounch of same format Excel spreadsheets into qlikview


      data source like .qvd?


      I am a starter of qlikview, forgive my silliness.





        • Re: Excel data source
          Johannes Sunden

          Hi Gloria,


          It's fine to use Excel files as data sources.


          If you want to load a table from a number of Excel files, with the same structure, in a folder you can use a load statement like:






          From Path\*.xls;


          If you're new to QlikView, try using the load data from "Table Files..." button in the script editor to pull in one of the Excel files and then you can just replace the filename in the script with a * after you have gone through the steps of the load wizard.