topic Loading Dynamically Multiple Excel Sheets in QlikView

Loading Dynamically Multiple Excel Sheets

tresB — Mon, 02 Aug 2010 06:27:27 GMT

Hi All,

I need to load all sheets of a excel document dynamically. Is this possible using "*" symbol? If possible then how? If not then also please show me a way out.

Thanks.......all helpful guys.

Loading Dynamically Multiple Excel Sheets

Mon, 02 Aug 2010 07:00:31 GMT

It has been discussed in here, several times, so a search in the forum, would probably have helped you 🙂

Have a look at Rob Wunderlich's cookbook. There is a nice example on how to load multiple sheets from Excel.

http://robwunderlich.com/Download.html

If all the sheet is name with a number, like year or month eg. 201003,201004,201005 etc, it is also possible, to do a loop, using "For each".

/Martin

Loading Dynamically Multiple Excel Sheets

tresB — Mon, 02 Aug 2010 10:59:01 GMT

Thanks Martin.

I went through the blog. But i am still struggling with it. I have a workbook with many sheets which are having identical fields. My excel is 2007. That is it is not BIFF but "ooxml ". I don't know if this only is making me struggling. I tried the blog suggested way but with vain. Can you please help me further.

Thanks and regards,

tresesco

Loading Dynamically Multiple Excel Sheets

Mon, 02 Aug 2010 11:27:52 GMT

Can you post an example of your file - then I will try and see if I can come up with a solution on this.

/Martin

Loading Dynamically Multiple Excel Sheets

tresB — Mon, 02 Aug 2010 11:37:33 GMT

Hi,

Look at the sample attachment(Excel). It has three sheets, but in reality it may contain many sheets which would not necessarily be named as Sheet1, Sheet2,....

Now i need all those sheet loaded at one go(dynamically). Hope this would let you understand better.

Thanks and regards,

tresesco

Loading Dynamically Multiple Excel Sheets

Mon, 02 Aug 2010 13:13:36 GMT

Have a look at the attached file - remember to change the ODBC connection. Furthermore, you need to install a driver that accepts Excel 2007

http://www.microsoft.com/downloads/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en

I hope it helps.

/Martin

Loading Dynamically Multiple Excel Sheets

Mon, 23 Aug 2010 11:22:31 GMT

Hi,

I had the same problem and used this method. Give it a try.

http://community.qlik.com/blogs/qlikviewblogs/archive/2008/09/29/loading-multiple-excel-sheets.aspx

Regards,