Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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.

thanks

Gloria

1 Solution

Accepted Solutions
jsn
Honored Contributor

Re: Excel data source

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.

2 Replies
jsn
Honored Contributor

Re: Excel data source

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.

Not applicable

Re: Excel data source

I am trying it now, thanks so much~~

Community Browser