How to import xml data into excel

Excel.Application oXL; Excel._Workbook oWB; Excel._Worksheet osheet; Excel.Range oRng; object opt = Type.Missing; try { oXL = new Microsoft.Office.Interop.Excel.Application(); oWB = (Excel._Workbook)(oXL.Workbooks._Open(outputfilename, opt, opt, opt, opt, opt, opt, opt, opt, opt, opt, opt, opt)); osheet = (Excel._Worksheet)oWB.Worksheets[1]; oWB.XmlMaps[1].ImportXml(data.Serialize(), "True"); }

 

//import string

oWB.XmlMaps[1].ImportXml(data.Serialize(),

"True");

//import xml file

oWB.XmlMaps[1].Import(filename,"True");