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.
Bu iş için 13 freelancer ortalamada $61 teklif veriyor
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 Daha Fazla
Dear Sir, We are interested to do this project. Best Regards.
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 Daha Fazla
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
Thank you for the opportunity to bid on your project.
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 !
I am ready to deliver this project with in 2 days as per ur requirements.
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......