Copy link to clipboard
Copied
Hi Guys,
How I can generate a XLS file with information in a XML file.
I have a XML which received information from a form.
To the user see the information inside a XML file, I created a report.cfm with the informations of the users.
Now the user want which the information in the XML, generate a XLS file from a CFM file to download.
How I will transformed this information in a XLS file?
Thanks,
Fabiano Magno Pechibella
Copy link to clipboard
Copied
There is no need to re-invent the wheel. Raymond Camden has published code that converts information from a form to an Excel file. His method first converts information from a form to a query. But you can easily adapt it to your case. If you do not have direct access to the form, you will still be able to convert the XML data into the name-value pairs in the query.