Export gridview data to excel sheet

Question

I want to export the data which is displaying in my gridview and it should downloaded as excel sheet so please suggest me how can i achive this. thanks in advance

Leon D · Answer

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

Tapan Patel · Answer

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/

Jitendra Shekhawat · Answer

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 { xlWorkSheet.Cells[1 l + 1] = dataGridView.Columns[l].HeaderText; } int row = 1 col = 0; for (i = 0; i { for (j = 0; j { 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(); } }

Sadhana Khaire · Answer

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