Click here to Skip to main content
15,883,623 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I want to convert excel file into xml file applied XML schema(xsd file).

Input is XSD and Excel file, and output is schematized xml.
(I guess the files format are correct, because those were provided as template by supplier's site.)

I found some samples in codeproject, but the result doesn't work correctly.

Convert Excel to XML file/XML Schema, and validate Excel against XML Schema[^]

I can find Excel-XSD mapping tool in the developer tab of MS Excel, but it also didn't work.

I couldnt figure out a suitable solution. Can any one help to Convert Excel Data to XML using Xsd schema applied?

Who can help me?

I can send .xls and .xsd files someone who are interested in fixing my trouble out.

Updated 22-Mar-13 1:38am
_Marshall 29-Apr-13 15:17pm    
You have to have mapped the schema to the Excel file in order to export it to XML. If you have the XSD the use the mapping tool to map the elements to the corresponding cells and then export to XML.
Excel and XML play very well together. What have you tried so far?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900