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

Represents a workbook.

Syntax

Visual Basic (Declaration) 
Public Interface IWorkbook
C# 
public interface IWorkbook

Example

C#Copy Code
class Program
{
   static void Main()
   {
       // 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();
       // Save to C:\MyData.xls.
       workbook.SaveAs("C:\\MyData.xls", SpreadsheetGear.FileFormat.XLS97);
       // Set Sheet1!A1 to "Hello World!".
       workbook.Worksheets["Sheet1"].Cells["A1"].Value = "Hello World!";
       // Save to C:\MyData.xls again.
       workbook.Save();
       // Close the workbook, removing it from the workbook set.
       workbookSet.Workbooks.Close();
       // Open the saved workbook from memory.
       workbook = workbookSet.Workbooks.Open("C:\\MyData.xls");
       // Output Sheet1!A1.
       System.Console.WriteLine(workbook.Worksheets["Sheet1"].Cells["A1"].Value.ToString());
   }
}
    
Visual BasicCopy Code
Class Program
    Shared 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()
        ' Save to C:\MyData.xls as an Excel file.
        workbook.SaveAs("C:\\MyData.xls", SpreadsheetGear.FileFormat.XLS97)
        ' Set Sheet1!A1 to "Hello World!".
        workbook.Worksheets("Sheet1").Cells("A1").Value = "Hello World!"
        ' Save to C:\MyData.xls again.
        workbook.Save()
        ' Close the workbook, removing it from the workbook set.
        workbookSet.Workbooks.Close()
        ' Open the saved workbook from memory.
        workbook = workbookSet.Workbooks.Open("C:\\MyData.xls")
        ' Output Sheet1!A1.
        System.Console.WriteLine(workbook.Worksheets("Sheet1").Cells("A1").Value.ToString())
    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.