Last post Sep 02, 2015 08:56 AM by Weibo Zhang
Sep 01, 2015 01:00 PM|yvdk7788|LINK
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
Could you please share your ideas how to construct an XML like above ?
Sep 02, 2015 08:56 AM|Weibo Zhang|LINK
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.
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.
I hope it’s useful to you.