When exporting to an Excel csv file (from a query), how can you make the excel sheet not be in a "general" type cast.
Posted on 2005-02-25
I'm using Coldfusion to export a query to an Excel CSV file. However, I have some large numbers and Excel is converting them to the scientific notation when it opens the CSV file (buty they're really text). I've placed (2) "" in front of the outputed variabe and it keeps them as text (which is what I want) but it also seems to be wanting to have them behind the variable too, but then they show up in the Excel file (not wanted).
<cfheader name="Content-disposition" value="inline; filename=Database2.csv" >
Another idea might be to have call a SQL stored procedure to dump this entire table to Excel.xls file (but not sure how to do that)