Excel reports in C#

Question

How to create Excel reports in C# with formulas?

Sumit Jolly · Answer

use Nuget package closedXML and you can code like this: var workbook = new XLWorkbook(); var ws = workbook.Worksheets.Add(Test); ws.row.Cell(4).FormulaR1C1 = =Sum(123) workbook.SaveAs(ms); twitter @sumitjolly

Jonathan Sterling · Answer

Here is another approach that you can use to create an excel report: ExcelFile workbook = new ExcelFile (); ExcelWorksheet worksheet = workbook.Worksheets.Add( Report ); // Set cell's value. worksheet.Cells[ A1 ].Value = 20; // Set cell's formula. worksheet.Cells[ A2 ].Formula = =A1+10 ; workbook.Save( Sample Report.xlsx ); Note the above code uses this C# class library for excel files .