Exporting to Excel from xml file or get xml from dataset

Hi can any one let me know the code to export the xml file to Excel file.开发者_JAVA百科

you can load your xml file to dataset first and then from dataset you can generate excel file. You should get plenty of examples by doing google search for 'xml to dataset in c#' and 'dataset to excel in c#'

You don't need .NET for that; Excel has can store spreadsheets as XML, so you need to convert your XML into a format that Excel understands.

Those conversions can be done very well using XSLT.

This article gives you a nice introduction on how to do that.

--jeroen