Export gridview data to excel sheet

This might be of help:

https://www.e-iceblue.com/Tutorials/Spire.DataExport/Spire.DataExport-Program-Guide/How-to-Export-Datatable-to-Excel-through-DataGridView.html 

If you are looking to do some basic export, please have a look at below article.

 

http://www.c-sharpcorner.com/article/exporting-datagrid-to-excel-in-wpf/ 

private void btn_Click(object sender, EventArgs e)

{

string filename = "Bill_Reports.xls";

try

{

Microsoft.Office.Interop.Excel.Application xlApp;

Microsoft.Office.Interop.Excel.Workbook xlWorkBook;

Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;

object misValue = System.Reflection.Missing.Value;

xlApp = new Microsoft.Office.Interop.Excel.Application();

xlWorkBook = xlApp.Workbooks.Add(misValue);

xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

int i = 0;

int j = 0;

for (int l = 0; l < dataGridView.Columns.Count; l++)

{

xlWorkSheet.Cells[1, l + 1] = dataGridView.Columns[l].HeaderText;

}

int row = 1, col = 0;

for (i = 0; i <= dataGridView.RowCount - 1; i++, row++)

{

for (j = 0; j <= dataGridView.ColumnCount - 1; j++, col++)

{

DataGridViewCell cell = dataGridView[j, i];

xlWorkSheet.Cells[row + 1, col + 1] = cell.Value;

}

col = 0;

}

MessageBox.Show("File is Exported!!!");

xlWorkBook.SaveAs(System.IO.Directory.GetCurrentDirectory() + @"\" + filename, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);

//xlApp.Visible = false;

xlApp.Quit();

releaseObject(xlWorkSheet);

releaseObject(xlWorkBook);

releaseObject(xlApp);

}

catch (Exception)

{

//MessageBox.Show("File is open!!!");

}

}

private void releaseObject(object obj)

{

try

{

System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);

obj = null;

}

catch (Exception ex)

{

obj = null;

MessageBox.Show("Unable to release the Object " + ex.ToString());

}

finally

{

GC.Collect();

}

}

Hi,

 

This might help

 

https://www.codeproject.com/Tips/477436/Export-Gridview-Data-to-Excel-in-ASP-NET