Opens an existing workbook in a newly created instance of IWorkbook in a new instance of IWorkbookSet.

Syntax

Visual Basic (Declaration)
Public Overloads Shared Function GetWorkbook( _ ByVal filename As String _ ) As IWorkbook

C#
public static IWorkbook GetWorkbook( string filename )

Parameters

filename

Return Value

A new instance of IWorkbook in a new instance of IWorkbookSet.

Example

C# Copy Code

C#	Copy Code
class Program { static void Main(string[] args) { // Open MyData.xls. SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook(@"C:\MyData.xls"); // Get a reference to the first worksheet. SpreadsheetGear.IWorksheet worksheet = workbook.Worksheets["Sheet1"]; // Get a reference to the top left cell of Sheet1. SpreadsheetGear.IRange a1 = worksheet.Cells["A1"]; // Output the value of A1. System.Console.WriteLine("[MyData.xls]Sheet1!A1 contains " + a1.Value.ToString() + "."); } }

class Program

{

   static void Main(string[] args)

   {

       // Open MyData.xls.

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

       // Get a reference to the first worksheet.

       SpreadsheetGear.IWorksheet worksheet = workbook.Worksheets["Sheet1"];

       // Get a reference to the top left cell of Sheet1.

       SpreadsheetGear.IRange a1 = worksheet.Cells["A1"];

       // Output the value of A1.

       System.Console.WriteLine("[MyData.xls]Sheet1!A1 contains
" + a1.Value.ToString() + ".");

   }

}

Visual Basic Copy Code

Visual Basic	Copy Code
Module Program Sub Main() ' Open MyData.xls. Dim workbook As SpreadsheetGear.IWorkbook = SpreadsheetGear.Factory.GetWorkbook("C:\\MyData.xls") ' Get a reference to the first worksheet. Dim worksheet As SpreadsheetGear.IWorksheet = workbook.Worksheets("Sheet1") ' Get a reference to the top left cell of Sheet1. Dim a1 As SpreadsheetGear.IRange = worksheet.Cells("A1") ' Output the value of A1. Console.WriteLine(("[MyData.xls]Sheet1!A1 contains " + a1.Value.ToString() + ".")) End Sub End Module

Module Program

    Sub Main()

        ' Open MyData.xls.

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

        ' Get a reference to the first worksheet.

        Dim worksheet As SpreadsheetGear.IWorksheet = workbook.Worksheets("Sheet1")

        ' Get a reference to the top left cell of Sheet1.

        Dim a1 As SpreadsheetGear.IRange = worksheet.Cells("A1")

        ' Output the value of A1.

        Console.WriteLine(("[MyData.xls]Sheet1!A1 contains " + a1.Value.ToString() + "."))

    End Sub

End Module

Remarks

This method is thread safe.

The workbook set containing the new workbook will use the US English CultureInfo. To open a workbook in a workbook set with a specific culture, use GetWorkbook.

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.