Convret XML with all nodes to Excel in C#

 

 

This Is xml File: 

 

 

 

 This is code: 

 

 

Excel.Application xlApp;

Excel.Workbook xlWorkBook;

Excel.Worksheet xlWorkSheet;

object misValue = Missing.Value;

DataSet ds = new DataSet();

XmlReader xmlFile;

xlApp = new Excel.ApplicationClass();

xlWorkBook = xlApp.Workbooks.Add(misValue);

xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

xmlFile = XmlReader.Create("MyXML.xml", new XmlReaderSettings());

ds.ReadXml(xmlFile, XmlReadMode.InferSchema);

for (int iRow = 1; iRow <= ds.Tables[0].Rows.Count - 1; iRow++)

{

for (int iCol = 0; iCol <= ds.Tables[0].Columns.Count - 1; iCol++)

{

xlWorkSheet.Cells[iRow + 1, iCol + 1] = ds.Tables[0].Rows[iRow].ItemArray[iCol].ToString();

}

}

Console.Write(xmlFile);

xlWorkBook.SaveAs(@"E:\Documents\Visual Studio 2015\WebSites\ConnectXero\Schema\xml2excel.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);

xlWorkBook.Close(true, misValue, misValue);

xlApp.Quit();

releaseObject(xlApp);

releaseObject(xlWorkBook);

releaseObject(xlWorkSheet);