Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vardhancse
Specialist III
Specialist III

Multiple Excel sheets without ODBC/OLEDB connection

Hi,

Can any one please let me know option to load multiple excel sheets(Having multiple sheets) with out using ODBC connection

43 Replies
tamilarasu
Champion
Champion

Sasi - Kindly check the below link.

How to extract Sheet Names from an Excel XLSX-f... | Qlik Community

Have you checked chrwolf64 suggestion?

vardhancse
Specialist III
Specialist III
Author

Thank you.

By seeing the code I can understand that the input should be .xml file and then only the script will work out

tamilarasu
Champion
Champion

Christian Wolf solution works great. Please check.

cwolf
Creator III
Creator III

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!

vardhancse
Specialist III
Specialist III
Author

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.

prieper
Master II
Master II

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

Kushal_Chawda

have you tried logic implemented here

Dynamically Loading Multiple Excel Files

vardhancse
Specialist III
Specialist III
Author

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 .

vardhancse
Specialist III
Specialist III
Author

tresesco‌ Can please suggest your input on the same.

prieper
Master II
Master II

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