Skip navigation
Currently Being Moderated

Multi-Tab Excel worksheet

Mar 19, 2010 2:51 PM

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

 
Replies
  • Currently Being Moderated
    Mar 22, 2010 1:44 AM   in reply to spacehog

    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

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points