SpreadsheetGear 2010
Add Method
See Also  Example Send Feedback
SpreadsheetGear Namespace > IWorkbooks Interface : Add Method

Returns a newly created workbook.

Syntax

Visual Basic (Declaration) 
Function Add() As IWorkbook
C# 
IWorkbook Add()

Return Value

The newly created workbook.

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();
        // Set Sheet1!A1 to "Hello World!".
        workbook.Worksheets["Sheet1"].Cells["A1"].Value = "Hello World!";
        // Save to memory as an Excel file.
        byte[] buffer = workbook.SaveToMemory(SpreadsheetGear.FileFormat.XLS97);
        // Close the workbook, removing it from the workbook set.
        workbook.Close();
        // Open the saved workbook from memory.
        workbook = workbookSet.Workbooks.OpenFromMemory(buffer);
        // 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()
        ' Set Sheet1!A1 to "Hello World!".
        workbook.Worksheets("Sheet1").Cells("A1").Value = "Hello World!"
        ' Save to memory as an Excel file.
        Dim buffer As Byte() = workbook.SaveToMemory(SpreadsheetGear.FileFormat.XLS97)
        ' Close the workbook, removing it from the workbook set.
        workbook.Close()
        ' Open the saved workbook from memory.
        workbook = workbookSet.Workbooks.OpenFromMemory(buffer)
        ' Output Sheet1!A1.
        System.Console.WriteLine(workbook.Worksheets("Sheet1").Cells("A1").Value.ToString())
    End Sub 'Main
End Class 'Program

Remarks

The number of worksheets in the new workbook is specified by IWorkbookSet.SheetsInNewWorkbook.

Requirements

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

See Also

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