FileFormat Enumeration

Specifies the file format with which to save a file.

Members

Member	Description
XLS97	Specifies Excel 97/2000/XP/2003 file format.

Example

[C#]

class Program 
{ 
    static void Main() 
    { 
        // Create a new empty workbook in a new workbook set. 
        SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook(); 
        // Set Sheet1!A1 to "Hello World!". 
        workbook.Worksheets["Sheet1"].Cells["A1"].Value = "Hello World!"; 
        // Save to C:\MyData.xls as Excel file. 
        workbook.SaveAs(@"C:\MyData.xls", SpreadsheetGear.FileFormat.XLS97); 
        // Open C:\MyData.xls. 
        workbook = SpreadsheetGear.Factory.GetWorkbook(@"C:\MyData.xls"); 
        // Output Sheet1!A1. 
        System.Console.WriteLine(workbook.Worksheets["Sheet1"].Cells["A1"].Value.ToString()); 
    } 
}

[Visual Basic]

Module Program

    Sub Main()

        ' Create a new empty workbook in a new workbook set.

        Dim workbook As SpreadsheetGear.IWorkbook = SpreadsheetGear.Factory.GetWorkbook()

        ' Set Sheet1!A1 to "Hello World!".

        workbook.Worksheets("Sheet1").Cells("A1").Value = "Hello World!"

        ' Save to C:\MyData.xls as Excel file.

        workbook.SaveAs("C:\\MyData.xls", SpreadsheetGear.FileFormat.XLS97)

        ' Open C:\MyData.xls.

        workbook = SpreadsheetGear.Factory.GetWorkbook("C:\\MyData.xls")

        ' Output Sheet1!A1.

        System.Console.WriteLine(workbook.Worksheets("Sheet1").Cells("A1").Value.ToString())

    End Sub

End Module

Requirements

Namespace: SpreadsheetGear

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

Assembly: SpreadsheetGear (in SpreadsheetGear.dll)

See Also

Requirements

Language

FileFormat Enumeration

Members

Example

Requirements

See Also