ansaurus

Question

ColdFusion 8 always opens .XLS, want .XLSX

Answer 1

+3 A:

I believe that the MIME type for Excel 2007 .xlsx files is "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet". I found an article on the Office Resource Kit Blog that calls this out after googling around a little.

D.Shawley 2009-08-06 18:26:34

Thank you for your prompt response!I tried it and these are the results:<cfheader name="content-disposition" value="attachment; filename=MyPriceList"><cfcontent type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"> This opens the file, but slowly, I have to do a 'save as' as it doesnt have an extension.Once I do a save as xlsx, and open the saved file, it opens really fast. (so same issue as downloading a .xls file)

2009-08-06 19:04:22

<cfheader name="content-disposition" value="attachment; filename=MyPriceList.xlsx"><cfcontent type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"> "Excel cannot open the file 'abc.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file". Even if instead of opening attachment I save it, I cannot open it (same message)

2009-08-06 19:05:07

I was just using abc as an alias for MyPriceList, please ignore the discrepancy

2009-08-06 19:06:24

I also notice first attempt (below) it opens it as a XSLX, rather than XLSX.<cfheader name="content-disposition" value="attachment; filename=MyPriceList"> <cfcontent type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet">

2009-08-06 19:14:57

Answer 2

+3 A:

I would suggest that the slow opening is because you are providing the data in an HTML format, not because of the extension. You could test this by saving the file directly from the browser, renaming it with the xlsx file extension, and opening it.

If you want to save data in an Excel format directly, I would check out Ben Nadel's POI CFC project.

Ben Doom 2009-08-06 19:55:29

Thanks to all. Also found some resources on using XML to load excel file directly.

2009-08-06 22:54:42

https://blogs.wharton.upenn.edu/brainstorm/2008/01/reading-and-writing-excel-file.htmland http://www.bennadel.com/blog/461-Creating-Microsoft-Excel-Documents-With-ColdFusion-And-XML.htm

2009-08-06 22:55:18

ansaurus

tags:

views:

answers:

ColdFusion 8 always opens .XLS, want .XLSX

related questions