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 freelance font une offre moyenne de $61 pour ce travail
Hello I am a software engineer with 6 years of experience in Excel, XML, VBA. I will be able to convert your Excel doc easily to XML. In fact I have done similar job a couple of time before. If you award me the project Plus
Hello, outmarcus. I just completed a very similar project a couple of hours ago. That project involved querying the online US patent database, parsing the data, and saving it in an Excel worksheet. You can see the f Plus
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 !
Hi, We can do this job as per your requirement and can deliver in one or max two days time. Thanks, Bhavani
i have already developed a macro which converts excel data to a xml file....i can customise that according to ur requirement......