Export datagridview in a windows application to excel in C#

Application xlApp;

Workbook xlWorkBook;

Worksheet xlWorksheet;

object misValue = System.Reflection.Missing.Value;

new Excel.ApplicationClass();

Worksheet)xlWorkBook.Worksheets.get_Item(1);

int i = 0;

int j = 0;

for (i = 0; i <= dataGridView1.RowCount - 1; i++)

for (j = 0; j <= dataGridView1.ColumnCount - 1; j++)

DataGridViewCell cell = dataGridView1[j, i];

"Products.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);

true, misValue, misValue);

MessageBox.Show("Excel file is created successfully");

private void releaseobject(object obj)

try

Marshal.ReleaseComObject(obj);

null;

catch (Exception ex)

null;

MessageBox.Show("Exception Occured while releasing object " + ex.ToString());

finally

GC.Collect();