Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / how to export data from datagridview to excel in c#.net windows application.
Ask Question

how to export data from datagridview to excel in c#.net windows application.

Anonymous User 5053 07 Jan 2016
I want to export data from datagridview to excel in c#.net windows application.how to do this please help me.
c# c#excel
Updated 13 Aug 2018
Anonymous User
Anonymous User

Other

I am a content writter !

Message

4 Answers

Ron Debay
Ron Debay 13 Aug 2018
Report Abuse
Post is removed by the Admin.
Copbel Beldi
Copbel Beldi 06 Jul 2017
Report Abuse

There are many options for exporting Excel file. One of them is to use an Excel library like EasyXLS.

The code is below:

<code>
ExcelDocument workbook = new ExcelDocument(1);
            
ExcelWorksheet worksheet = (ExcelWorksheet)workbook.easy_getSheetAt(0);
ExcelTable table = worksheet.easy_getExcelTable();
for (int column = 0; column < dataGridView.Columns.Count; column++)
{
    table.easy_getCell(0, column).setValue(dataGridView.Columns[column].HeaderText);
}
for (int row = 0; row < dataGridView.Rows.Count-1; row++)
{
    for (int column = 0; column < dataGridView.Columns.Count; column++)
    {
        xlsTable.easy_getCell(row+1, column).setValue(dataGridView.Rows[row].Cells[column].Value.ToString());
     }
}
workbook.easy_WriteXLSXFile("file.xlsx");
</code>

For details about exporting other items like colors, fonts, see export datagridview to Excel in C# from EasyXLS website.

Anonymous User
Anonymous User 08 Jan 2016
Report Abuse
Post is removed by the Admin.
Anonymous User
Anonymous User 07 Jan 2016
Report Abuse

I will explain here how to export data from datagridview to excel in c# windows application.
Show below Code and excel formate.

using System;
using System.Windows.Forms;
using System.IO;
using System.Data;
using System.Data.OleDb;
using Excel = Microsoft.Office.Interop.Excel; 
namespace export_Excel
{
    public partial class Form1 : Form
    {
        
        public Form1()
        {
            InitializeComponent();
        }       
     
        private void Form1_Load(object sender, EventArgs e)
        {
        }
        private void button1_Click(object sender, EventArgs e)
        {
            Excel.Application xelApp;
            Excel.Workbook xelWorkBook;
            Excel.Worksheet xelWorkSheet;
            object misingValue = System.Reflection.Missing.Value;
            xelApp = new Excel.Application();
            xelWorkBook = xelApp.Workbooks.Add(misingValue);
            xelWorkSheet = (Excel.Worksheet)xelWorkBook.Worksheets.get_Item(1);
            int i = 0;
            int j = 0;
            for (i = 0; i <= GridView1.RowCount - 1; i++)
            {
                for (j = 0; j <= GridView1.ColumnCount - 1; j++)
                {
                    DataGridViewCell cell = GridView1[j, i];
                    xelWorkSheet.Cells[i + 1, j + 1] = cell.Value;
                }
            }
            xelWorkBook.SaveAs("Employee.xls", Excel.XlFileFormat.xlWorkbookNormal, misingValue, misingValue, misingValue, misingValue, Excel.XlSaveAsAccessMode.xlExclusive, misingValue, misingValue, misingValue, misingValue, misingValue);
            xelWorkBook.Close(true, misingValue, misingValue);
            xelApp.Quit();
            Objectreleased(xelWorkSheet);
            Objectreleased(xelWorkBook);
            Objectreleased(xelApp);
            MessageBox.Show("Excel file created , you can see the file E:\\Employee.xls");
        }
        private void Objectreleased(object obj)
        {
            try
            {
                System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
                obj = null;
            }
            catch (Exception ex)
            {
                obj = null;
                MessageBox.Show("Exception Occured while releasing object " + ex.ToString());
            }
            finally
            {
                GC.Collect();
            }
        }
    
    }
}
Anonymous User

Result

Anonymous User
advertising