Spreadsheetgear Example May 2026

worksheet.Cells["A3"].Value = "Widget B"; worksheet.Cells["B3"].Value = 75; worksheet.Cells["C3"].Value = 24.50;

// 7. Format currency column worksheet.Cells["C2:C3"].NumberFormat = "$#,##0.00"; worksheet.Cells["D2:D5"].NumberFormat = "$#,##0.00"; spreadsheetgear example

// 1. Create a new workbook and get the active worksheet IWorkbook workbook = Factory.GetWorkbook(); IWorksheet worksheet = workbook.Worksheets["Sheet1"]; worksheet.Name = "Sales Report"; worksheet

// 6. Add totals row worksheet.Cells["A5"].Value = "TOTALS"; worksheet.Cells["B5"].Formula = "=SUM(B2:B3)"; worksheet.Cells["D5"].Formula = "=SUM(D2:D3)"; worksheet.Cells["A3"].Value = "Widget B"

// 8. Auto-fit columns for readability worksheet.Cells["A:D"].Columns.AutoFit();