topic Re: Load Excel files with multiple sheets in Water Cooler

Load Excel files with multiple sheets

Mon, 28 Apr 2014 13:12:29 GMT

Hi everybody! I need load some Excel files and each one with sheets that have differents names. I have seen diferents topics related with this but I don't understand. I don't have a conection with a SQL database. I attach an example of Excel file.

Thank you!

Re: Load Excel files with multiple sheets

Roop — Mon, 28 Apr 2014 14:11:16 GMT

http://community.qlik.com/docs/DOC-4452 gives a very good example on how you do this in a script. It should be simple to follow

Hope this helps

Re: Load Excel files with multiple sheets

Mon, 28 Apr 2014 14:23:20 GMT

Yes, I have seen it, but the problem, is that in my case all sheets have differents name! Buenos Aires, Catamarca, etc.

I used this topic when de sheets names are numerations or similar.

Re: Load Excel files with multiple sheets

maxgro — Mon, 28 Apr 2014 14:26:05 GMT

try here

Re: Loading from multiple Excel files and multiple sheets

Re: Load Excel files with multiple sheets

Mon, 28 Apr 2014 15:54:23 GMT

It works now! I had to create a conection odbc to Excel files.Thank you!