SpreadsheetGear 2010
Factory Class
Members  Example  See Also  Send Feedback
SpreadsheetGear Namespace : Factory Class

The Factory class provides static methods for creating instances of IWorkbookSet and IWorkbook.

Syntax

Visual Basic (Declaration) 
Public Class Factory 
C# 
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 BasicCopy 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

All static methods in Factory are thread safe.

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

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.