Creates an instance of
IWorkbook in a new instance of
IWorkbookSet.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overloads Shared Function GetWorkbook() As IWorkbook |
Return Value
A new instance of
IWorkbook in a new instance of
IWorkbookSet.
Example
| C# |  Copy Code |
|---|
class Program
{
static void Main(string[] args)
{
// Create a new empty workbook in a new workbook set.
SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook();
// 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"];
// Set a formula.
a1.Formula = "=24901.55 / PI()";
// Output the result of the formula.
System.Console.WriteLine("The diameter of the earth is
" + a1.Value.ToString() + " miles.");
}
}
|
| Visual Basic | Copy Code |
|---|
Module Program
Sub Main()
Dim workbook As SpreadsheetGear.IWorkbook = SpreadsheetGear.Factory.GetWorkbook()
Dim worksheet As SpreadsheetGear.IWorksheet = workbook.Worksheets("Sheet1")
Dim a1 As SpreadsheetGear.IRange = worksheet.Cells("A1")
a1.Formula = "=24901.55 / PI()"
Console.WriteLine(("The diameter of the earth is " + a1.Value.ToString() + " miles."))
End Sub
End Module
|
Remarks
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.
See Also
