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

Syntax

Visual Basic (Declaration)
Function OpenFromStream( _ ByVal stream As Stream _ ) As IWorkbook

C#
IWorkbook OpenFromStream( Stream stream )

Parameters

stream: The stream containing the workbook to open.

Return Value

The opened workbook.

Example

C# Copy Code

C#	Copy Code
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); } }

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);

   }

}

Visual Basic Copy Code

Visual Basic	Copy Code
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

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

Remarks

The stream must consist solely of a file which SpreadsheetGear is able to read. If the stream is not seekable, this method will copy the stream to a MemoryStream and read the workbook from the MemoryStream.

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.

Requirements

Platforms: x86 and x64 versions of Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003 (including R2) and Windows Server 2008 (including R2). SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

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.