Participating Frequently

Question

creating .xslx files in coldfusion 8

Forum|Forum|10 years ago
February 8, 2016
10 replies
1596 views

Hello All

I am on a CF8 server (the company hasn't upgraded) an I need to create an xslx file.

Any suggestions?

xslx

This topic is closed to new replies. Start a new post to keep the conversation going.

Inspiring

The best way I've found to export data from ColdFusion 4, 5, 6, 7, 8, 9, 10 & 11 to XLSX format is to use CFExecute and Total CSV Converter

https://www.coolutils.com/TotalCSVConverter

atlcfAuthor

Participating Frequently

Thanks!

Will give it a try.

Inspiring

I'm not sure if this will work on CF8, but here's a UDF I optimized to generate better CSV so that dates, strings, non-numeric-string and other values are preserved when converting to Excel. Use this w/Total CSV Converter... or just return the CSV file and it will open nicely in current versions of Excel.

https://gist.github.com/JamoCA/b2d0467dd914909f00bf

Legend

I don't know of a solid way to do that in CF8. If you were on at least CF9, there is CFSPREADSHEET (for tag-based code) or SPREADSHEETNEW() (for CFSCRIPT code.) I prefer the latter, as it gives much more granular control.

HTH,

^_^

Carl Von Stetten

Legend

You might also look at Apache POI and Ben Nadel's CFC wrapper: GitHub - bennadel/POIUtility.cfc: A ColdFusion component (and set of custom tags) for reading and writing XLS (Excel) do…

atlcfAuthor

Participating Frequently

Thanks

I am actually looking at that now.

I’ve downloaded the code and changed the ext to .xslx and it creates a file but it won’t open.