Quack
asked on
I'm looking for help with an excel file export from a Cold Fusion form...The html version is working fine but the excel is blank.
I'm looking for help with an excel file export from a Cold Fusion form...The html version is working fine but the excel is blank. Has anyone had any issues w/ this. The form is working for the html and pulling from the db. The excel version is just blank with the same parameters.
The only modification was to increase the max size of a field to 17 from 16 in the index.htm file to account for an increased reference number. Simple change but and the test db has been updated w/ the criteria to pull from but for some reason the excel file isn't populating. I know this is vague but I'm hoping someone can shed some light or at least point me somewhere I can find some assistance. Thanks.
The only modification was to increase the max size of a field to 17 from 16 in the index.htm file to account for an increased reference number. Simple change but and the test db has been updated w/ the criteria to pull from but for some reason the excel file isn't populating. I know this is vague but I'm hoping someone can shed some light or at least point me somewhere I can find some assistance. Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The issue was determined to a datasource issue.
Are simply collecting data in query and trying to write as XLSX file ?
or any manipulation happens?
Trying outputting the query data to html page ( or just do cfdump). May be you have some exception happening at the time of getting data.
This could be result of additional field you added.
Writing a EXCEL file is pretty straight forward in CF 9 and above.
Look at the use of spreadsheet functions , to write query to file.
https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-r-s/cfspreadsheet.html