Overloads Function OpenFromStream( _
   ByVal stream As Stream _
) As IWorkbook

IWorkbook OpenFromStream( 
   Stream stream
)

class Program
{
    static void Main(string[] args)
    {
        // Create a simple workbook.
        SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook();
        workbook.Worksheets["Sheet1"].Cells["A1"].Value = "Hello World!";
 
        // Save the workbook to a memory stream.
        System.IO.MemoryStream memoryStream = new System.IO.MemoryStream();
        workbook.SaveToStream(memoryStream, SpreadsheetGear.FileFormat.OpenXMLWorkbook);
 
        // Close the workbook.
        workbook.Close();
 
        // Create another workbook from the memory stream.
        workbook = SpreadsheetGear.Factory.GetWorkbookSet().Workbooks.OpenFromStream(memoryStream);
        Console.WriteLine("Sheet1!A1='{0}'", workbook.Worksheets["Sheet1"].Cells["A1"].Value);
    }
}

Module Program
    Sub Main()
        ' Create a simple workbook. 
        Dim workbook As SpreadsheetGear.IWorkbook = SpreadsheetGear.Factory.GetWorkbook()
        workbook.Worksheets("Sheet1").Cells("A1").Value = "Hello World!"
 
        ' Save the workbook to a memory stream. 
        Dim memoryStream As New System.IO.MemoryStream()
        workbook.SaveToStream(memoryStream, SpreadsheetGear.FileFormat.OpenXMLWorkbook)
 
        ' Close the workbook. 
        workbook.Close()
 
        ' Create another workbook from the memory stream. 
        workbook = SpreadsheetGear.Factory.GetWorkbookSet().Workbooks.OpenFromStream(memoryStream)
        Console.WriteLine("Sheet1!A1='{0}'", workbook.Worksheets("Sheet1").Cells("A1").Value)
    End Sub
End Module