Open an existing workbook in a newly created instance of
IWorkbook.
Syntax
Visual Basic (Declaration) | |
---|
Function OpenFromStream( _
ByVal stream As Stream _
) As IWorkbook |
Parameters
- stream
-
The stream containing the workbook to open.
Return Value
The opened workbook.
Example
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);
}
} |
Visual Basic | Copy Code |
---|
Module Program
Sub Main()
Dim workbook As SpreadsheetGear.IWorkbook = SpreadsheetGear.Factory.GetWorkbook()
workbook.Worksheets("Sheet1").Cells("A1").Value = "Hello World!"
Dim memoryStream As New System.IO.MemoryStream()
workbook.SaveToStream(memoryStream, SpreadsheetGear.FileFormat.OpenXMLWorkbook)
workbook.Close()
workbook = SpreadsheetGear.Factory.GetWorkbookSet().Workbooks.OpenFromStream(memoryStream)
Console.WriteLine("Sheet1!A1='{0}'", workbook.Worksheets("Sheet1").Cells("A1").Value)
End Sub
End Module |
Remarks
Requirements
Platforms: Windows 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.
See Also