Multi-Tab Excel worksheet

Question

Is it possible to create a multi-tabbed worksheet in CF 8?  I can do a single tab using cfcontent, haven't found anything on adding additional tabs

Fernis · Answer

CFCONTENT has nothing to do with generating excel sheets.You're just defining that output data is sent in binary form, with a certain mime type. Creating an Excel sheet is something completely separated. If you use already a third party component for this, check if it supports multiple worksheets.

A csv file is not an Excel worksheet (conceptually) at all. There are no features like sheets. It's dummy data with just commas, quotes, values and linefeeds.

One alternative would be to create an Excel XML worksheet. I haven't tried thismyself, but here are some pointers:

http://msdn.microsoft.com/en-us/library/aa140066%28office.10%29.aspx

http://prsync.com/oracle/multisheet-excel-output-18866/

CF9 is of course the easiest solution with its cfspreadsheet tag, if you can upgrade.

--

- Fernis - fernis.net - ColdFusion Developer For Hire

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded