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 filepathDataSet 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; } } }