How to split the xml file?

Question

I have upload excel sheetthis excel sheet have multiple sheets inside.now i am put the excel sheet into for loop and convert the excel sheet to dataset and every excel sheet is to save as table now i get the xml.that xml have all sheets xml data.if we want to split the xml for each one table. is this possible?

Vinay Singh · Answer

Hi check the below links http://www.c-sharpcorner.com/UploadFile/097c29/excel-to-xml-conversation-in-visual-studio/ http://www.codeproject.com/Articles/11775/Generating-Excel-XML-Spreadsheet-in-C https://msdn.microsoft.com/en-us/library/office/hh180830(v=office.14).aspx

Bhushan Gawale · Answer

Something like this should work for you varxDoc=XDocument.Parse(Resource1.XMLFile1); //loadingsourcexml varxmls=xDoc.Root.Elements().ToArray(); //splitintoelements for ( int i=0;i { //writeeachelementintodifferentfile using (varfile=File.CreateText( string .Format( xml{0}.xml i+1))) { file.Write(xmls[i].ToString()); } } Ref - http://stackoverflow.com/questions/14455639/how-to-split-an-xml-file-into-multiple-xml-files-based-on-nodes

Joginder Banger · Answer

share your xml code if it's possible.

Raja · Answer

I validate the xml by common name of the sheets (example +k) 'k' means the first sheet named as example and another sheet named as 'example 1'.now i have 3 sheets 'example table' 'example2 table'  'example3 table'.these table converted to xml. That xml file have three sheets xml data.any possibility for split this xml. :)

Joginder Banger · Answer

Hi am not sure but you can split with the help of Root Elements. every sheet name have different. for more information about convert excel to XML try this link http://www.c-sharpcorner.com/UploadFile/097c29/excel-to-xml-conversation-in-visual-studio/