C# Excel 97-2003 (*.xls) SpreadsheetGear API Sample

Excel-Compatible Samples for .NET

Description

SpreadsheetGear supports saving Excel-compatible workbook files to disk by using the SpreadsheetGear.IWorkbook.SaveAs(string pathToWorkbook, FileFormat fileFormat) method. To save an Excel 97-2003 (*.xls) file, use the SpreadsheetGear.FileFormat.Excel8 enumeration option, as shown below:

Sample C# Source Code

// Create a new workbook and some local variables for convenience.
SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook();
SpreadsheetGear.IWorksheet worksheet = workbook.Worksheets["Sheet1"];
SpreadsheetGear.IRange cells = worksheet.Cells;

// Rename the worksheet.
worksheet.Name = "My Worksheet";

// Add some cell data.
cells["A1"].Value = "Hello World!";

// Save to Excel 97-2003 (*.xls) file.
workbook.SaveAs(@"c:\path\to\workbook.xlsx", SpreadsheetGear.FileFormat.Excel8);