Spreadsheetgear Example | Free Access

var generator = new ReportGenerator(); generator.CreateSalesReport(); Console.WriteLine("Excel report generated successfully."); What Makes This Powerful? | Challenge | SpreadsheetGear Solution | |-----------|--------------------------| | Server deployment | No COM, no Excel install. Runs in any .NET app (ASP.NET, Windows Service, Azure Function). | | Performance | In-memory, thread-safe, and up to 100x faster than Interop. | | Formulas & functions | Supports 400+ built-in Excel functions, including array formulas. | | Rendering | Can convert worksheets to PDF, PNG, or HTML without Excel. | | Compatibility | Reads/writes .xls, .xlsx, .xlsm, .csv — preserves charts, pivot tables, and macros. | Real-World Use Case Extension Suppose you need to email this report as a PDF. With SpreadsheetGear, you can add two lines:

// 2. Define headers worksheet.Cells["A1"].Value = "Product"; worksheet.Cells["B1"].Value = "Units Sold"; worksheet.Cells["C1"].Value = "Unit Price"; worksheet.Cells["D1"].Value = "Total Revenue"; spreadsheetgear example

// 6. Add totals row worksheet.Cells["A5"].Value = "TOTALS"; worksheet.Cells["B5"].Formula = "=SUM(B2:B3)"; worksheet.Cells["D5"].Formula = "=SUM(D2:D3)"; var generator = new ReportGenerator(); generator

// 3. Apply formatting to headers (bold, background color) IRange headerRange = worksheet.Cells["A1:D1"]; headerRange.Font.Bold = true; headerRange.Interior.Color = System.Drawing.Color.LightGray; headerRange.Borders.LineStyle = SpreadsheetGear.Advanced.Cells.LineStyle.Continuous; | | Performance | In-memory, thread-safe, and up

// 9. Save to file (no Excel installed required) workbook.SaveAs(@"C:\Reports\SalesReport.xlsx", FileFormat.OpenXMLWorkbook);

public void CreateSalesReport()