Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview Macro to Save as Binary Excel Format

Hi,

I am exporting data into Excel thru Qlikview Macro code and file size higher like 15-20 MB.

Can we convert to .xlsb (Binary Excel format) instead of .xls (Excel Format)?.. Anyone please help

BR's

Narsingh

1 Reply
marcus_sommer

If you just export objects to excel you couldn't store them as xlsb but if you creates a new excel instance and within there a new workbook and copied your objects there it should work to save it in various file-formats and probably also in xlsb. I think this should be helpful for you: Macro - Export Multiple Charts From Container To Excel.

- Marcus