Load multiple Excel's sheets

Wed, 04 May 2016 07:55:57 GMT

Good Morning,

After searching, her in the community, such as making a load of several sheets of Excel, I found none that worked or did not know I make them work.

My case is the following, have an Excel where users from different server are save, if users are users local machine are stored in a sheet with the following nomenclature “Resumen_nameserver” and if the serve also has LDAP users are stored in a sheet called “Resumen_LDAP_nameserver”, we must also keep in mind that the order of these sheets can be “randomized”, ie not all servers have because to have LDAP users , so they can come followed several sheets of local users.

Leave attached an Excel sample to make it look clearer,

Thanks in advance for the answer,

Roger A. Reina Hdez.

P.s.: I’m new to this world of QLIKVIEW, so forgive any mistake to talk about something referred to it and sorry for the English of Google translate.

Re: Load multiple Excel's sheets

Gysbert_Wassenaar — Thu, 05 May 2016 14:58:34 GMT

You need an odbc connection to the excel file to load a table of the excel sheets. Then you can use that table to iterate through the sheets and read the data on the sheets. See this discussion: Loading Multiple Excel Files and Multiple Excel sheets

topic Re: Load multiple Excel's sheets in App Development

Load multiple Excel's sheets

Re: Load multiple Excel's sheets