SpreadsheetGear Namespace : IWorksheet Interface |
Represents a worksheet.
For a list of all members of this type, see IWorksheet members.
[Visual Basic]
Public Interface IWorksheet
Inherits ISheet
[C#]
public interface IWorksheet : ISheet
[C++]
public __gc __interface IWorksheet : public ISheet
[C++/CLI]
public interface class IWorksheet : public ISheet
[C#]
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 Basic]
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
Namespace: SpreadsheetGear
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family
Assembly: SpreadsheetGear (in SpreadsheetGear.dll)
IWorksheet Members | SpreadsheetGear Namespace
See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.
Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.