Loading

Excel reports in C#

Ranjit Powar

12y1.3kVisual Basic .NET

How to create Excel reports in C# with formulas?

2 Replies

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

Jonathan Sterling11y ago

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.

Guest User12y ago
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(1,2,3)"
workbook.SaveAs(ms);

twitter @sumitjolly