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

Export gridview data to excel sheet

Answers (4)