Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can any one please let me know option to load multiple excel sheets(Having multiple sheets) with out using ODBC connection
Sasi - Kindly check the below link.
How to extract Sheet Names from an Excel XLSX-f... | Qlik Community
Have you checked chrwolf64 suggestion?
Thank you.
By seeing the code I can understand that the input should be .xml file and then only the script will work out
Christian Wolf solution works great. Please check.
Hi Sasi,
there are two ways to extract sheet names from an Excel file using a macro.
One uses Excel in the background to get the sheet names (as shown above). This works for xls and xlsx files.
If there is no Excel installed on the server, there is another method only for xlsx files.
An xlsx file is nothing more than a zip archive that contains xml files. The idea is now to extract the right xml file to get the sheet names from that.
The Qvw in the appendix contains both variants. The macros are JScript macros!
Hi @Christian Wolf
thank you so much for multiple alternatives.
But unfortunately we are not are not supposed to macros.
And so now trying with other options.
If you have no info on the names of the sheets and other ways of automation are not acceptable by you, you will have to create manual solution.
Peter
have you tried logic implemented here
Hi Kushal,
Thank you.
But unfortunately we cant use ODBC connection in our server and so looking for manua set of code to load all sheets from multiple workbooks .
tresesco Can please suggest your input on the same.
Sasi,
would you please clarify:
Do you know the correct spelling of the workbooks to load, or do they follow a certain pattern or are you supposed to load all workbooks in a certain directory?
Do you know the number or the worksheets in each workbook? Do you know the name of the sheets?
Peter