 |
 |
SpreadsheetGear | The Performance Spreadsheet Component Company |
| SpreadsheetGear Namespace > Factory Class > GetWorkbook Method : GetWorkbook(String) Method |
|
|
SpreadsheetGear | The Performance Spreadsheet Component Company |
| SpreadsheetGear Namespace > Factory Class > GetWorkbook Method : GetWorkbook(String) Method |
Opens an existing workbook in a newly created instance of IWorkbook in a new instance of IWorkbookSet.
[Visual Basic]
Overloads Public Shared Function GetWorkbook( _
ByVal filename As String _
) As IWorkbookA new instance of IWorkbook in a new instance of IWorkbookSet.
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.
[C#]
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]
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
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family
Factory Class | Factory Members | Overload List | IWorkbookSet | IWorkbook | GetWorkbook Method | GetWorkbookSet Method | GetWorkbook(CultureInfo) Method | GetWorkbook(String,CultureInfo) Method | GetWorkbookSet(CultureInfo) Method
See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.
Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.