Export Excel File in .Net 2.0

Vinit Suryarao

6y1.2kLearn iOS Programming

How to Export Excel File in .Net Framework 2.0

i have tried below methods

1) using CloseXML dll

2) Using Office Interop

Is there any other way for free excel export

3 Replies

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

Leon D6y ago
Another alternative solution is Free Spire.XLS library.

It is available on nuget:
https://www.nuget.org/packages/FreeSpire.XLS/

How to export or import excel file using it:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html

https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Import/Export-Import-Data-from-Excel-to-Datatable.html
Akshay Shedwad6y ago
Follow one of Following Method.

1.Save to wwwroot
2.Byte array

If you want to Overview of this Method, Click on link for reference
https://stackoverflow.com/questions/50247245/export-to-excel-in-asp-net-core-2-0
Laxmidhar Sahoo6y ago
1- Install the package from nuggets
https://www.nuget.org/packages/EPPlus.Core/
public IActionResult Excel()
{

    var comlumHeadrs = new string[]
    {
        "Employee Id",
        "Name",
        "Position",
        "Salary",
        "Joined Date"
    };

    byte[] result;

    using (var package = new ExcelPackage())
    {
        // add a new worksheet to the empty workbook

        var worksheet = package.Workbook.Worksheets.Add("Current Employee"); //Worksheet name
        using (var cells = worksheet.Cells[1, 1, 1, 5]) //(1,1) (1,5)
        {
            cells.Style.Font.Bold = true;
        }

        //First add the headers
        for (var i = 0; i < comlumHeadrs.Count(); i++)
        {
            worksheet.Cells[1, i + 1].Value = comlumHeadrs[i];
        }

        //Add values
        var j = 2;
        foreach (var employee in DummyData.GetEmployeeData())
        {
            worksheet.Cells["A" + j].Value = employee.Id;
            worksheet.Cells["B" + j].Value = employee.Name;
            worksheet.Cells["C" + j].Value = employee.Position;
            worksheet.Cells["D" + j].Value = employee.Salary.ToString("$#,0.00;($#,0.00)");
            worksheet.Cells["E" + j].Value = employee.JoinedDate.ToString("MM/dd/yyyy");

            j++;
        }
        result = package.GetAsByteArray();
    }

    return File(result, "application/ms-excel", $"Employee.xlsx");
}