Skip to main content
B
bmarshall1
Participant
October 16, 2007
Question

Generating excel 97 files

  • October 16, 2007
  • 2 replies
  • 332 views
Hey everyone,

It has come to my attention that my coldfusion generated excel files will display correctly in excel 2003 but not in excel 97. When opened in excel 97 html and java script code is displayed. When opened up in microsoft's excel 97 viewer I get this error message: "Microsoft excel viewer can not open this type of file". Any suggestions?
    This topic has been closed for replies.

    2 replies

    S
    SafariTECH
    Inspiring
    October 17, 2007
    It all matters how you program the actual template that generates the output for Excel, not the file definition - the file definition just tells CF what to put in the header.

    Every version of Excel is different in how it works with data, and the template you use to generate files that work in Excel 2003 will likely not work in Excel 97 or even 2000 for that matter. You may also find that they don't work in Excel 2007 since the new Office runs under MS's version of XML now.

    It would likely be more helpful to see the contents of "completeAgentReport.cfm" than the header, since that's where the issues will be. Also, please note any error you get in Excel 97 when you try to open the files.



    **BTW, the reaction from the forums is not unfounded - Office 97 is an archived/shelved platform product now and does not even have support options through MS any longer ... 2000 will be shelved this winter as well. You can't always provide output for everyone and in most cases developers (while they try to do the best they can) can only provide support for the most common.used products. Companies that are using Office have pretty much all evolved to 2003 by now, with a good chunk adopting 2007 as well.
    B
    bmarshall1Author
    Participant
    October 17, 2007
    I seemed to have missed read the coldfusion docs... excel 97 is a supported file for ColdFusion's Verity.
    Supported File types
    I thought this was a list of all supported file types. As long as excel 97 files are not listed as a supported file type for generating files I can can accept the error I am receiving.

    Thanks for the help everyone
    Brian
    P
    paross1
    Participating Frequently
    October 16, 2007
    Uh, Excel 97? Dude, its 2007, almost 2008!
    B
    bmarshall1Author
    Participant
    October 16, 2007
    Yes sir 2008 is less then 3 months away, however excel 97 is still a coldfusion mx 7supported file type regardless of the year.
    P
    paross1
    Participating Frequently
    October 16, 2007
    This might be a real stretch, but have you tried using <cfcontent type="application/msexcel"> instead of <cfcontent type="application/vnd.ms-excel">?

    Phil
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices