How to Export DataGrid to Excel using C#

Question

Hello, I would like to export my DataGrid to Excel with the filename typed into a textbox, but I have no idea how to do it. Everything I found on the internet was with DataGridViews. But they don't work for me. Can someone give me a code example which I can integrate into my program?

Rajanikant Hawaldar · Answer

Hi Noah Anleiter, Refer this video https://www.youtube.com/watch?v=K8_YrQVKe58 https://www.c-sharpcorner.com/UploadFile/0c1bb2/export-gridview-to-excel/

Leon D · Answer

You can transfer the data from datagrid to a datatable: https://stackoverflow.com/questions/3109009/how-to-make-a-datatable-from-datagridview-without-any-datasource https://social.msdn.microsoft.com/Forums/windows/en-US/73c01abf-8c79-4ac8-9391-c8700cb1c917/tranfer-data-from-datagrid-to-datatable?forum=winformsdatacontrols And then use free spire.xls library(https://www.nuget.org/packages/FreeSpire.XLS/) to export datatable to excel with code like below: Workbook workbook = new Workbook(); workbook.Version = ExcelVersion.Version2013; Worksheet sheet = workbook.Worksheets[0]; sheet.InsertDataTable(datatable, true , 1, 1); workbook.SaveToFile( "ExportDataToExcel.xlsx" ,ExcelVersion.Version2013);

Manoj Bhoir · Answer

Hi, Check my article this will help you. https://manojbhoir.wordpress.com/2019/05/11/how-to-export-datagridview-data-to-excel-c-net/

Jignesh Kumar · Answer

Hi Noah, Please find below link, https://www.c-sharpcorner.com/UploadFile/hrojasara/export-datagridview-to-excel-in-C-Sharp/ https://stackoverflow.com/questions/18182029/how-to-export-datagridview-data-instantly-to-excel-on-button-click

Laxmidhar Sahoo · Answer

from the dataset you fill grid pass that dataset object at the calling time of the bellow function using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Data; using System.Reflection; using Microsoft.Office.Interop.Excel; using Microsoft.Office.Interop; using System.IO; namespace WindowsFormsApplication1 { class ExportToExcel { public static string SaveExcel( string filepath,DataSet ds) { string strmsg = "Sorry" ; try { string fpath = filepath + "\Filexml\" + " Report.xml"; string excelpath = filepath + "\Excelfiles\" + " ReportExcel.xlsx"; ds.WriteXml(fpath); Microsoft.Office.Interop.Excel.Application xApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook excelWorkBook = xApp.Workbooks.OpenXML(fpath, Type.Missing, Microsoft.Office.Interop.Excel.XlXmlLoadOption.xlXmlLoadImportToList); excelWorkBook.SaveAs(excelpath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange); excelWorkBook.Close(); xApp.Workbooks.Close(); strmsg = "Successfull" ; } catch (Exception ex) { strmsg = "Sorry" ; //ex.ToString(); // throw; } return strmsg; } } }

How to Export DataGrid to Excel using C#

Answers (5)