Exporting data from our database to Excel using CF8 using <cfsetting showdebugoutput="false">
<cfheader name="content-disposition" value="attachment;filename=#OUTFILE2#.xls">
And then generating XML.
We have some cells that are supposed to be empty but they aren't actually when Excel is open. Is there way around this? I see the POI solution has a cell type blank but I can't see a way to replicate this with the process we are using.