Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
Highlighted

Re: Qlikview Macro to Save as Binary Excel Format

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