How to convert a windows form into Excel Sheet using VS2012

Question

I have some data in a dataGridView. I want to convert data on button click into a excel sheet.

I used the namespace

using Excel = Microsoft.Office.Interop.Excel;

but it gives an error at 'Office' . What should I do now?

I am using VS2012 and SQL server 2008 with MS Office 2012.

Rafael Austin · Answer

In general you need to grab the data from the dataGridView prepare the data to be converted to Excel. I am currently generating Excel files using a developing SDK (leadtools). You can find related information in the following thread: http://www.c-sharpcorner.com/Forums/Thread/273305/how-to-print-the-pdf-and-excel-formate-from-database.aspx

Alex Smith · Answer

There is another way to do so refer to this link Export Datatable to Excel through DataGridView Good luck.