how to get excel data and convert Xml and save existing Xml

Question

for ex. i have excel file in which three column ID,Content, IsActive. I want to access detail of excel file and convert into xml and this xml data save in Existing xml file. And Id should be increase according number of content in this xml file.

Raja T · Answer

Hi Ani Please refer below link Excel to XML Conversion in Visual Studio http://www.c-sharpcorner.com/UploadFile/097c29/excel-to-xml-conversation-in-visual-studio/ If you want to update a node in XML the XmlDocument is fine - you needn't use XmlTextWriter. XmlDocument doc = new XmlDocument(); doc.Load(D:\build.xml); XmlNode root = doc.DocumentElement; XmlNode myNode = root.SelectSingleNode(descendant::books); myNode.Value = blabla; doc.Save(D:\build.xml); more details checkout below links http://stackoverflow.com/questions/2551307/modify-xml-existing-content-in-c-sharp