Creates an instance of IWorkbookSet with the specified CultureInfo.

Syntax

Visual Basic (Declaration)
Public Overloads Shared Function GetWorkbookSet( _ ByVal cultureInfo As CultureInfo _ ) As IWorkbookSet

C#
public static IWorkbookSet GetWorkbookSet( CultureInfo cultureInfo )

Parameters

cultureInfo

Return Value

A new instance of IWorkbookSet.

Example

C# Copy Code

C#	Copy Code
class Program { static void Main(string[] args) { // Create a new empty workbook set with the current thread's culture info. SpreadsheetGear.IWorkbookSet workbookSet = SpreadsheetGear.Factory.GetWorkbookSet(System.Globalization.CultureInfo.CurrentCulture); // 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."); } }

class Program

{

   static void Main(string[] args)

   {

       // Create a new empty workbook set with the current thread's culture info.

       SpreadsheetGear.IWorkbookSet workbookSet

           =
SpreadsheetGear.Factory.GetWorkbookSet(System.Globalization.CultureInfo.CurrentCulture);

       // 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

Visual Basic	Copy Code
Module Program Sub Main() ' Create a new empty workbook set with the current thread's culture info. Dim workbookSet As SpreadsheetGear.IWorkbookSet = SpreadsheetGear.Factory.GetWorkbookSet(System.Globalization.CultureInfo.CurrentCulture) ' 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

Module Program

    Sub Main()

        ' Create a new empty workbook set with the current thread's culture info.

        Dim workbookSet As SpreadsheetGear.IWorkbookSet = SpreadsheetGear.Factory.GetWorkbookSet(System.Globalization.CultureInfo.CurrentCulture)

        ' 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

This method is thread safe.

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.

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