xml to excel

Question

Hi, I have 1000 xml files. I want to convert them as excel files. Thanks, Darma

Santhosh Kumar Jayaraman · Answer

try this code //Creating Excel book and sheet object misValue = System.Reflection.Missing.Value; Excel.Application myApp=new Excel.Application() ; Excel.Workbook myWbk = myApp.Workbooks.Add(misValue); Excel.Worksheet myWst = (Excel.Worksheet)myWbk.Worksheets.get_Item(1); //reading xml and load into datasheet DataSet ds = new DataSet(); XmlReader xmlFile ; xmlFile = XmlReader.Create("C:\Staff.xml", new XmlReaderSettings()); ds.ReadXml(xmlFile); //writing into excel int i = 0; int j = 0; for (i = 0; i { for (j = 0; j { myWst.Cells[i + 1, j + 1] = ds.Tables[0].Rows[i].ItemArray[j].ToString (); } } //saving and closing excel myWbk.SaveAs("C:\Staffexcel.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); myWbk.Close(true, misValue, misValue); myApp.Quit(); source:http://csharp.net-informations.com/xml/excel-from-xml.htm

Lacy Michelle · Answer

below articles can help you: Convert Excel to XML and XML to Excel Generate Excel from XML and Generate XML from Excel