How to Export DataGrid to Excel using C#

Noah Anleitner

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?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar7y ago
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/
0
Leon D7y ago
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);
0
Manoj Bhoir7y ago
Hi,

Check my article this will help you.

https://manojbhoir.wordpress.com/2019/05/11/how-to-export-datagridview-data-to-excel-c-net/
0
Jignesh Kumar7y ago
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
0
Laxmidhar Sahoo7y ago
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;

        }
    }
}
0