Export Excel File in .Net 2.0

Question

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

Akshay Shedwad · Answer

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

Leon D · Answer

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

Laxmidhar Sahoo · Answer

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 { 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" ); }

Export Excel File in .Net 2.0

Answers (3)