Using ExportBIFF but to same XLS

[#1]

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,

[llauses243]

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

[stevedark]

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

[#4]

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.

[stevedark]

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

[Stefan_Walther]

... also this may help:

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

Regards
Stefan