Export Datagrid to Excel

[bencall]

I have a Vb.Net Windows application displaying summary information that I would like exported from the datagrids on the form to an excel spreadsheet. This will be done on a button click.

 

[jmcilhinney]

Have a search on MSDN for "automation excel" (without quotes). Office Automation is the name for manipulating an instance of an Office application programatically through its object model.

 

[DavidT_macktool]

Read here...

Export To Excel

 

[bencall]

Thanks for you help. I ended up taking the data from the Dataset because of time contraints I have on this project. I had wanted to take directly from the data grid.... I thought maybe I could avoid having to hide certain columns again as I have done with the datagrid already.

 

[pjs]

same task i want to do but i want 2 buttons one is insert and the oher is export while selecting insert button datas from text box .list box and date time picker should be inserted in to sql server database and while selecting export button all the database records should exported to excel file...plz do help me