topic Re: Loading multiple excel sheets without ussing a connection in QlikView

Loading multiple excel sheets without ussing a connection

Mon, 28 Oct 2013 23:55:40 GMT

Hi,

I need help to load multiple excel sheets to QlikView without using any connection because it is not allowed in the enterprise. Is there any way to do this only by programming in the script?

Thanks a lot!

Re: Loading multiple excel sheets without ussing a connection

Jason_Michaelides — Tue, 29 Oct 2013 00:38:43 GMT

What do you mean "without any connection"? To load an Excel doc you only have to point the script to the file location.

Re: Loading multiple excel sheets without ussing a connection

Tue, 29 Oct 2013 06:41:18 GMT

Please elaborate your question.

Re: Loading multiple excel sheets without ussing a connection

Tue, 29 Oct 2013 16:22:06 GMT

I'll try to explain myself better, what I'm trying to do is load all the sheets from an excel workbook without doing it one by one.

The only examples I found to do this was by connecting to the ODBC excel files or through OLE DB jet 4 or something like that, but I can't do either way because it ask me for a User and Password which I don't have.

I would like to know if there is a way to code this like an Excel macro that loops through all the sheets.

Thanks.

Re: Loading multiple excel sheets without ussing a connection

Jason_Michaelides — Tue, 29 Oct 2013 16:26:25 GMT

There're loads of threads on here on that - have a search and you'll find some!

Re: Loading multiple excel sheets without ussing a connection

Jason_Michaelides — Tue, 29 Oct 2013 16:32:02 GMT

Here's one...

http://community.qlik.com/message/308287#308287

Re: Loading multiple excel sheets without ussing a connection

Gysbert_Wassenaar — Tue, 29 Oct 2013 16:56:34 GMT

Afaik the only time you need a password for an odbc connection to an excel file is if the excel file is password protected. And if that's the case then an odbc connection is also the only way to load data from an excel file.