I need a (simple) Excel application that exports a list of Excel data to XML format.
An example of the Excel input data is this: [url removed, login to view]
The XSD schema is this:
[url removed, login to view] (convert its name to "schema.xsd")
An example of the resulting (output) XML is this:
[url removed, login to view]
As you can see, the main part of the Excel data is the third sheet, that is a list of cars with its characteristics.
I (manually) composed the [url removed, login to view] for the first two cars/rows. The program you will create must automatically do the same work on all the cars/rows.
I think that the example is auto-explicative, ie it should be easy to understand what operations are to be done, by reading what I wrote in it and comparing it with the source data in the Excel third sheet.
I think that the only difficult part is in the fact that the number in the K column of the third sheet (ie. "1113" in the first row) is to be searched in the A column of the first and second sheet and only the matching rows of these last sheets that have in the D column a letter different from "S" must be reported in (the second part of) the XML. As you can also see in the example...
Payment by escrow.
13 freelanceria on tarjonnut keskimäärin 61 $ tähän työhön
Hi. I already have a Visual Basic 6.0 application where convert access tables to xml files. It is similar from excel to xml files. How I can send you a prinscreen of my application??? Regards Frosso
I'm in the US, and have the support of a software company, should I need it. I have much Excel and VB experience, though. However, it may be simpler to use another method. We should discuss this.
I have already had a VB6 function to convert Excel to XML file. I think I can customize it & build complete application for u in 1 day & the cost is only 30$. Thanks u !