SpreadsheetGear 2010
GetWorkbook(String,CultureInfo) Method
See Also  Example Send Feedback
SpreadsheetGear Namespace > Factory Class > GetWorkbook Method : GetWorkbook(String,CultureInfo) Method

filename
cultureInfo
Opens an existing workbook in a newly created instance of IWorkbook in a new instance of IWorkbookSet which uses the specified CultureInfo.

Syntax

Visual Basic (Declaration) 
Public Overloads Shared Function GetWorkbook( _
   ByVal filename As String, _
   ByVal cultureInfo As CultureInfo _
) As IWorkbook
C# 
public static IWorkbook GetWorkbook( 
   string filename,
   CultureInfo cultureInfo
)

Parameters

filename
cultureInfo

Return Value

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

Example

C#Copy Code
class Program
{
    static void Main(string[] args)
    {
        // Open MyData.xls using the current CultureInfo.
        SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook(@"C:\MyData.xls", System.Globalization.CultureInfo.CurrentCulture);
        // 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 BasicCopy Code
Module Program
    Sub Main()
        ' Open MyData.xls using the current CultureInfo. 
        Dim workbook As SpreadsheetGear.IWorkbook = SpreadsheetGear.Factory.GetWorkbook("C:\\MyData.xls", System.Globalization.CultureInfo.CurrentCulture)
        ' 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.

Requirements

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

See Also

Copyright © 2003-2010 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.