Open an existing workbook in a newly created instance of IWorkbook.

Syntax

Visual Basic (Declaration)
Function Open( _ ByVal filename As String _ ) As IWorkbook

C#
IWorkbook Open( string filename )

Parameters

filename: The filename of the workbook to open.

Return Value

The opened workbook.

Example

C# Copy Code

C#	Copy Code
class Program { static void Main() { // Create a new empty workbook set. SpreadsheetGear.IWorkbookSet workbookSet = SpreadsheetGear.Factory.GetWorkbookSet(); // Create a new empty workbook in the workbook set. SpreadsheetGear.IWorkbook workbook = workbookSet.Workbooks.Add(); // Save to C:\MyData.xls. workbook.SaveAs("C:\\MyData.xls", SpreadsheetGear.FileFormat.XLS97); // Set Sheet1!A1 to "Hello World!". workbook.Worksheets["Sheet1"].Cells["A1"].Value = "Hello World!"; // Save to C:\MyData.xls again. workbook.Save(); // Close the workbook, removing it from the workbook set. workbookSet.Workbooks.Close(); // Open the saved workbook from memory. workbook = workbookSet.Workbooks.Open("C:\\MyData.xls"); // Output Sheet1!A1. System.Console.WriteLine(workbook.Worksheets["Sheet1"].Cells["A1"].Value.ToString()); } }

class Program

{

   static void Main()

   {

       // Create a new empty workbook set.

       SpreadsheetGear.IWorkbookSet workbookSet = SpreadsheetGear.Factory.GetWorkbookSet();

       // Create a new empty workbook in the workbook set.

       SpreadsheetGear.IWorkbook workbook = workbookSet.Workbooks.Add();

       // Save to C:\MyData.xls.

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

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

       workbook.Worksheets["Sheet1"].Cells["A1"].Value = "Hello World!";

       // Save to C:\MyData.xls again.

       workbook.Save();

       // Close the workbook, removing it from the workbook set.

       workbookSet.Workbooks.Close();

       // Open the saved workbook from memory.

       workbook = workbookSet.Workbooks.Open("C:\\MyData.xls");

       // Output Sheet1!A1.

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

   }

}

Visual Basic Copy Code

Visual Basic	Copy Code
Class Program Shared Sub Main() ' Create a new empty workbook set. Dim workbookSet As SpreadsheetGear.IWorkbookSet = SpreadsheetGear.Factory.GetWorkbookSet() ' Create a new empty workbook in the workbook set. Dim workbook As SpreadsheetGear.IWorkbook = workbookSet.Workbooks.Add() ' Save to C:\MyData.xls as an Excel file. workbook.SaveAs("C:\\MyData.xls", SpreadsheetGear.FileFormat.XLS97) ' Set Sheet1!A1 to "Hello World!". workbook.Worksheets("Sheet1").Cells("A1").Value = "Hello World!" ' Save to C:\MyData.xls again. workbook.Save() ' Close the workbook, removing it from the workbook set. workbookSet.Workbooks.Close() ' Open the saved workbook from memory. workbook = workbookSet.Workbooks.Open("C:\\MyData.xls") ' Output Sheet1!A1. System.Console.WriteLine(workbook.Worksheets("Sheet1").Cells("A1").Value.ToString()) End Sub 'Main End Class 'Program

Class Program

    Shared Sub Main()

        ' Create a new empty workbook set.

        Dim workbookSet As SpreadsheetGear.IWorkbookSet = SpreadsheetGear.Factory.GetWorkbookSet()

        ' Create a new empty workbook in the workbook set.

        Dim workbook As SpreadsheetGear.IWorkbook = workbookSet.Workbooks.Add()

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

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

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

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

        ' Save to C:\MyData.xls again.

        workbook.Save()

        ' Close the workbook, removing it from the workbook set.

        workbookSet.Workbooks.Close()

        ' Open the saved workbook from memory.

        workbook = workbookSet.Workbooks.Open("C:\\MyData.xls")

        ' Output Sheet1!A1.

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

    End Sub 'Main

End Class 'Program

Remarks

The various workbook settings which make a workbook read-only in an end user workbookSet have no affect at this level. These settings are available as IWorkbook properties.

Requirements

Platforms: Windows 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2008 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.	Help Powered by Innovasys
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.