Output to multiple tabs in Excel

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?

This topic has been closed for replies.

Correct answer ilssac

<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

ilssacCorrect answer

Inspiring

<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

Participating Frequently

Thanks!

Inspiring

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

Inspiring

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

Sign up