Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Using ExportBIFF but to same XLS

Hi Folks

I am using the ExportBIFF function to output formatted tables to Excel, however, I would like to be able to do this to multiple worksheets in a single XLS file.

Anybody out there know a way to do it?

Cheers,

5 Replies
llauses243
Contributor III

Using ExportBIFF but to same XLS

Hi Nigel,

I think the exist ...

Multiple sheets -> a folder with multiple .xls (many books)

Then with a .vbs join multiple .xls (many books) to a book (.xls) with multiple sheet

Good luck, Luis

MVP & Luminary
MVP & Luminary

Using ExportBIFF but to same XLS

Hi Nigel,

To have multiple sheets in Excel you will need to use a macro in QlikView. In here you can instantiate an instance of an Excel object and call all of the methods within it. I think it should then be possible to call Copy To Clipboard from the QlikView object model and then a Paste within the Excel object model. You can then call the Add Sheet method within Excel and repeat the copy and paste. With the whole excel model at your disposal you can then also tidy up your output by setting column widths and setting the first row to bold etc.

Hope that helps.

Regards,
Steve

Not applicable

Using ExportBIFF but to same XLS

Hi Steve

This sounds like exactly what I'm after, I don't suppose you have a brief example of a macro that does this do you?

Cheers,

Nigel.

MVP & Luminary
MVP & Luminary

Using ExportBIFF but to same XLS

Hi Nigel,

There are a few examples already on QlikCommunity of automating Excel:

http://community.qlik.com/forums/p/26622/113073.aspx

http://community.qlik.com/forums/t/31837.aspx

http://community.qlik.com/forums/p/16523/64532.aspx

The last link has some code from Micahel Slomovich that is the most succinct example I have seen.

Hope that helps.

Regards,
Steve

Employee
Employee

Using ExportBIFF but to same XLS

... also this may help:

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

Regards
Stefan