How to split the xml file?

Raja

10y1.2k.NET

I have upload excel sheet,this 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?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinay Singh10y ago
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
0
Bhushan Gawale10y ago
Something like this should work for you
varxDoc=XDocument.Parse(Resource1.XMLFile1);//loadingsourcexml
varxmls=xDoc.Root.Elements().ToArray();//splitintoelements
for(inti=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
0
Joginder Banger10y ago
share your xml code, if it's possible.
0
Raja10y ago
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. :)
0
Joginder Banger10y ago
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/
0