SpreadsheetGear
IWorksheet Interface
Members  Example  See Also  Send Feedback
SpreadsheetGear Namespace : IWorksheet Interface

Represents a worksheet.

Syntax

Visual Basic (Declaration) 
Public Interface IWorksheet 
   Inherits ISheet 
C# 
public interface IWorksheet : ISheet 

Example

C#Copy Code
class Program
{
   static void Main()
   {
       // 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 + " miles.");
   }
}
    
Visual BasicCopy Code
Class Program
   Shared Sub Main()
      ' Create a new empty workbook in a new workbook set.
      Dim workbook As SpreadsheetGear.IWorkbook = SpreadsheetGear.Factory.GetWorkbook()
      ' 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.
      System.Console.WriteLine(("The diameter of the earth is " + a1.Value + " miles."))
   End Sub 'Main
End Class 'Program

Requirements

Namespace: SpreadsheetGear

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.

Assembly: SpreadsheetGear (in SpreadsheetGear.dll)

See Also

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.