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

Translate

WolfShade

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,

^_^

Translate

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…

Translate

A

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.

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.