 |
 |
SpreadsheetGear | The Performance Spreadsheet Component Company |
| SpreadsheetGear Namespace > IWorkbooks Interface : Add Method (IWorkbooks) |
|
|
SpreadsheetGear | The Performance Spreadsheet Component Company |
| SpreadsheetGear Namespace > IWorkbooks Interface : Add Method (IWorkbooks) |
Returns a newly created workbook.
[Visual Basic]
Overridable Function Add() As IWorkbook[C#]
virtual IWorkbook Add();[C++]
virtual IWorkbook* Add(); [C++/CLI]
virtual IWorkbook^ Add(); The newly created workbook.
The number of worksheets in the new workbook is specified by IWorkbookSet.SheetsInNewWorkbook.
[C#]
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 Basic]
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
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family
IWorkbooks Interface | IWorkbooks Members | SheetsInNewWorkbook Property
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.