See Also

IWorkbooks Interface  | IWorkbooks Members

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

Language

Visual Basic

C#

C++

C++/CLI

Show All

buffer
See Also Languages SpreadsheetGear The Performance Spreadsheet Component Company 

OpenFromMemory Method

SpreadsheetGear Namespace > IWorkbooks Interface : OpenFromMemory Method

Open an existing workbook in a newly created instance of IWorkbook. 

[Visual Basic]
Overridable Function OpenFromMemory( _
   ByVal buffer() As Byte _
) As IWorkbook
[C#]
virtual IWorkbook OpenFromMemory( 
   byte[] buffer
);
[C++]
virtual IWorkbook* OpenFromMemory( 
   byte[]* buffer
) 
[C++/CLI]
virtual IWorkbook^ OpenFromMemory( 
   bytearray<buffer>^ buffer
)

Parameters

buffer

Return Type

The opened workbook.

Remarks

The various workbook settings which make a workbook read-only in an end user workbookSet have no affect at this level. These settings are available as IWorkbook properties.

Example

[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

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IWorkbooks Interface  | IWorkbooks Members

 

 

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.