Export XML to Excel in SharePoint 2010


I have an xml file Inputs.xml which has the following values

I need to display the values in the SharePoint 2010 Visual Web Part. And there will be a button in the Visual web part "Export to Excel" by clicking on that I should be able to save the values in the excel.

Create SharePoint 2010 Visual Web Part using Visual Studio 2010:

  • Open Visual Studio 2010.

  • Go to File => New => Project.

  • Select Visual Web Part template from the installed templates.

  • Enter the Name for the project as VisualWebPart and then click on Ok.

  • Select the local site that will be used for debugging.

  • Click on Finish.

  • In the solution explorer, right click on VisualWebPart1 and then click on Delete.