Read XML file and generate a XLS file?

Question

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

BKBK · Answer

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.

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.

Scanning file for viruses.

This file cannot be downloaded