Transfer data from Datagrid to MS-Excel

[readraj]

I have a query i want to provide facility to the user of exporting data from my app to Excel. Is there any way by which i can transfer data from datagrid to Excel or even word.

 

[jmcilhinney]

You can use ADO.NET to interact with Excel like it was a database, or you can use Automation to interact with any Office app using it's full functionality. Do a search on MSDN for "ado.net excel" and "automation excel .net" (without quotes) for details.