The Factory class provides static methods for creating instances of
IWorkbookSet and
IWorkbook.
Syntax
Visual Basic (Declaration) | |
---|
Public Class Factory |
Example
C# | Copy Code |
---|
class Program
{
static void Main(string[] args)
{
// 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();
// 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()
' 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()
' 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")
' Set a formula.
a1.Formula = "=24901.55 / PI()"
' Output the result of the formula.
Console.WriteLine(("The diameter of the earth is " + a1.Value.ToString() + " miles."))
End Sub
End Module |
Remarks
Inheritance Hierarchy
System.Object
SpreadsheetGear.Factory
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