Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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