How to import multiple sheets from multiple excel files?

[peterderrington]

Hi,

Now i'm sure this has been asked before but having had a quick look i cant see an obvious answer....

• I have several spreadsheets
• Each spreadsheet covers a different Organisational Unit
• Each spreadsheet has sheets named the same (although not necessarily in the same order)
• They are all monthly data that is filled in daily

I need to be able to import the data and then manipulate it in the same way i can with Excel - e.g. view all totals, separate by month or organisational unit etc etc

I know that QlikView can do this but i just don't know the best way to do it. I've seen something about qvd's but again i don't fully understand how to use these.

Can anyone help?

Many thanks,

Peter

[prieper]

see my reply from Apr 24th.

Might be more helpful, if you could post an example

[peterderrington]

The above is an example of the error message - it lasts about 100 pages printed out on Word. I have attached that Document.

It throws the error message on every sheet (almost).

[prieper]

Hi Peter,

no, I did not mean the Errors, but the underlying tables.

For sure you should exclude all the internal tables used in Excel (... FilterDatabase).

So you may check the content of the vSheetName for some specific characters:

IF NOT WILDMATCH(vSheetName, '*#*') THEN

CONCATENATE LOAD ...

END IF

Or you refer to a positive list of possible entries for the monthly data.

[peterderrington]

Hi Peter,

I can attach a copy of one of the spread sheets if that would help?

There are 31 files, 23 of the Spread sheets are identical in terms of sheet names etc., the only difference being the name of the file. A further 7 are older versions that again are identical to themselves but structured differently to the main and the final one is a spread sheet that we currently use to pull together data out of the other 30.

QlikView fails to do anything with the import and just fails with those error messages.