topic Re: Excel data source in QlikView

Excel data source

Wed, 24 Oct 2012 03:26:15 GMT

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.

thanks

Gloria

Re: Excel data source

Anonymous — Wed, 24 Oct 2012 03:29:03 GMT

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:

Load

Field1,

Field2,

etc.

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.

Re: Excel data source

Wed, 24 Oct 2012 03:30:27 GMT

I am trying it now, thanks so much~~