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

xml to excel

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)