Visual Basic (Declaration) | |
---|---|
Public Interface IWorksheet Inherits IPrintable, ISheet |
C# | |
---|---|
public interface IWorksheet : IPrintable, 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 |
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