Output to multiple tabs in Excel

[EndoplasmicReticulum]

Im using <CFCONTENT type="application/vnd.ms-excel"> in my code and I need to output the results of a number of queries each to a seperate tab

in Excel. How do I do that?

[Dan_Bracuk]

A separate tab in your browser or a separate worksheet in excel?

[ilssac · Accepted solution]

<cfcontent....> does not have the ability to do multiple tabs in an Excel output.

If you want that level of control you will either need to go to CF9's new excel integration technology.

http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec17cba-7f87.html

OR

For older ColdFusion servers, dive into the Java underling and use the POI integration technology.

http://www.bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Read-And-Write-Excel-Files.htm

[EndoplasmicReticulum]

Thanks!

[-__cfSearching__-]

Personally, I prefer the POI approach mentioned above. But a third possibility is to use Office's mso schemas/xml

http://cfsilence.com/blog/client/index.cfm/2006/7/19/Creating-Multiple-Tabs-in-Excel-with-Coldfusion