Excel Sheet to XML

Question

User1778243854 posted

Hi All, I got a requirement converting Excel sheet in to xml using C#... Can you please share your suggestion how this is possible

Excel Columns and it contains data like below

Name  Age  Address1 City1 State1 Address2 City2 State2 Address3 City3 State3

XML Should look like below

<root>
	<request>
		<Name/>
		<Age/>
		<Address>
			<Address1></Address1>
			<City1></City1>
			<State1></State1>
			<Address2></Address2>
			<City2></City2>
			<State2></State2>
			<Address3></Address3>
			<City3></City3>
			<State3></State3>
		</Address>
	</request>
</root>

Could you please share your ideas how to construct an XML like above ?

Answer 1

User-219423983 posted

Hi yvdk7788,

As you want to export the data from excel to XML and the XML has some custom format, so you could first refer to the following code to read the Excel data like reading DataTable in the DataBase.

http://www.aspsnippets.com/Articles/Read-and-Import-Excel-Sheet-using-ADO.Net-and-C.aspx

Then, you could take a look at the following thread is about how to create XML. In this thread, it provides some different method to build an XML file. Here, you could try to use the XmlWriter to achieve your need.

http://stackoverflow.com/questions/284324/how-can-i-build-xml-in-c

I hope it’s useful to you.

Best Regard,

Weibo Zhang