Spreadsheetgear Example Site

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

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

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