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 %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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 !