Convert XML file to XLS file

Question

HI I need to get the dataset into an XML file and save it.Convert this XML to Excel file(XLS).Could any one help me for this in C#.Iam new to C#. Thanks & Regards Bavithra

Edda Brown · Answer

I'm not sure where you looking to generate SpreadsheetML or some other XML with your schema nevertheless I just wanted to add that there is a direct way that you can use with DataSet.WriteXml method . Also there is a direct way how you can import DataSet data to an Excel file in C# .

KIRUTHIKA · Answer

Bavi send also the name of the college you studied....

KIRUTHIKA · Answer

Hi Bavi i hope u still have my home number... its ok... mail to me @ kiruthika.subramanian@tcs.com .... send ur mobile number to this id...

KIRUTHIKA · Answer

Hi bavithra I am not going to help u.. i am in search of my friend bavithra jayaram... i thought it may be u... can u plz reply... r u from tenkasi?

Tabish Sarwar · Answer

This is most probably you want to have http://support.microsoft.com/kb/319180 For more information look into 1-Create an Excel XML from your dataset. You can achieve this using XSLT or creating your own generation engine (its simple). 2-For Asp.Net solution http://www.dotnetjohn.com/articles.aspx?articleid=36 3-You can find several techniques here. http://www.aspnetpro.com/NewsletterArticle/2003/09/asp200309so_l/asp200309so_l.asp