Skip navigation
Currently Being Moderated

Can CF10 Write XLSX Spreadsheets?

Apr 22, 2012 10:45 AM

I know CF9 can't so I was wondering if this issue will be resolved in CF10?

 

I believe CF9/10 uses Apache POI underneath and that functionality (writing xlsx) has been there for quite some time (and other CFML engines, OpenBD/Railo, can read/write xlsx just fine. I just fine the new spreadsheet support in CF being borderline worthless since it only deals with the obsolete binary xls format which is very limited when dealing with larges amounts of data.

 
Replies
  • Currently Being Moderated
    Apr 22, 2012 11:04 AM   in reply to cold_blue

    I know CF9 can't so I was wondering if this issue will be resolved in CF10?

     

     

    There's no need to wonder about it.  D/L CF10 and give it a go.

     

    (Sorry, I'd give a better answer if I knew, but I'm not au fait with CF's Excel support as it's not something I really have to focus on.  But just wanted to let you know that if it's a serious question you have, then you are in a position to answer it for yourself...)

     

    --

    Adam

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 22, 2012 11:20 AM   in reply to cold_blue

    Well I was looking at the documentation... and it looks like an exact copy of the CF9 documentation. So my intial thought is no... but was wondering maybe they just haven't updated the docs?

     

    I would not be surprised if the docs hadn't been updated yet, as what will be released will still be in flux.  That, and the docs for CF don't get much attention anyhow... there's stuff in there that's been out-of-date since CF5.

     

    I was more meaning just D/L CF10 and give it a go.  It's a 10min exercise.

     

    --

    Adam

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 22, 2012 9:42 PM   in reply to cold_blue

    Can CF10 Write XLSX Spreadsheets? I know CF9 can't

     

    Sure it does. For example:

     

    SpreadsheetNew([sheetName, xmlformat])

    xmlformat:   True/Yes:      Creates a .xlsx file that is supported by Microsoft Office Excel 2007.

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 22, 2012 10:00 PM   in reply to cold_blue

    The SpreadsheetWrite() function only allows XLS format.

     

    No, as long as it is a CF spreadsheet object (binary or ooxml), SpreadSheetWrite will accept it and save it in the proper format. Just be sure to use the correct file extension.

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 23, 2012 3:34 PM   in reply to cold_blue

    Yeah, things are not always crystal clear from reading the documentation. When I run into stuff like that I usually give it whirl - just to see if it is truly unsupported or is actually omission in the documentation.

     
    |
    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