Export to Excel using Open XML

Hello folks, Today I am going to explain regarding Export to Excel using Open XML. We could do this in both asp.net and Windows application as well as in WPF.

Step 1: Download below libraries:

• Open XML SDK 2.0 for Microsoft Office
• ClosedXML – The easy way to OpenXML

 

Step 2 : Source code for Export to excel using Open XML:

 

using System;
using System.Data;
using ClosedXML.Excel;

namespace ExportToExcleUsingOpenXML
{
    class Program
    {
        static void Main(string[] args)
        {
            string strFilePath=AppDomain.CurrentDomain.BaseDirectory+"\\export-excel-using-open-xml.xlsx";
            using (XLWorkbook wb = new XLWorkbook())
            {
                wb.Worksheets.Add(DataTableWithData(), "Employee");
                wb.SaveAs(strFilePath);
            }
        }

        private static DataTable DataTableWithData()
        {
            DataTable dt = new DataTable("Employee");
            dt.Columns.Add("EmployeeId", typeof(Int32));
            dt.Columns.Add("EmployeeName", typeof(string));
            dt.Columns.Add("Address", typeof(string));
            dt.Columns.Add("MobileNo", typeof(string));

            dt.Rows.Add(1, "E1", "A1", "0000000000");
            dt.Rows.Add(2, "E2", "A2", "111111111");
            dt.Rows.Add(3, "E3", "A3", "1222222222");
            dt.Rows.Add(4, "E4", "A4", "3333333333");
            return dt;
        }
    }
}

That all, We could achieve this task withing two simple steps. Finally we could get below output in excel.