CodingForums.com - View Single Post

grazopper · 11-11-2010, 09:34 PM

I really need some help. I am a relatively new Python programmer, but I am not that familiar with XML. I have been tasked with creating an XML file from an Excel spreadsheet. The structure of the XML file is set by my vendor. I have a sample XML file, as well as an XSD file, but I am not sure how to progress.

I have been able to pull the data out of the Excel file in to a CSV using lxrd, but I am stuck there. I have created a header row in my CSV to create the appropriate tags in XML, but I cannot get the format to match the sample XML.

My next thought was to replace all the data in the sample XML file with variables (e.g. $2C), and to do a search and replace using the CSV. This seems to be very awkward (and truthfully, I don't know how to script that).

I am not opposed to doing the work, and I would love to actually learn how to do this, but I could really use some assistance.

Thanks in advance!!

11-11-2010, 09:34 PM	PM User \| #1
grazopper New to the CF scene Join Date: Nov 2010 Posts: 7 Thanks: 1 Thanked 0 Times in 0 Posts	Excel to XML with Python I really need some help. I am a relatively new Python programmer, but I am not that familiar with XML. I have been tasked with creating an XML file from an Excel spreadsheet. The structure of the XML file is set by my vendor. I have a sample XML file, as well as an XSD file, but I am not sure how to progress. I have been able to pull the data out of the Excel file in to a CSV using lxrd, but I am stuck there. I have created a header row in my CSV to create the appropriate tags in XML, but I cannot get the format to match the sample XML. My next thought was to replace all the data in the sample XML file with variables (e.g. $2C), and to do a search and replace using the CSV. This seems to be very awkward (and truthfully, I don't know how to script that). I am not opposed to doing the work, and I would love to actually learn how to do this, but I could really use some assistance. Thanks in advance!!