SpreadsheetGear
SaveToStream Method
See Also  Example Send Feedback
SpreadsheetGear Namespace > IWorkbook Interface : SaveToStream Method

stream
The stream to write the workbook to.
fileFormat
The file format to save the workbook in.
Saves this workbook to a stream in the specified FileFormat.

Syntax

Visual Basic (Declaration) 
Sub SaveToStream( _
   ByVal stream As Stream, _
   ByVal fileFormat As FileFormat _
)
C# 
void SaveToStream( 
   Stream stream,
   FileFormat fileFormat
)

Parameters

stream
The stream to write the workbook to.
fileFormat
The file format to save the workbook in.

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 BasicCopy 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

Remarks

Note that the various workbook settings which make a workbook read-only in an end user workbookSet have no affect at this level.

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.

See Also

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.