SpreadsheetGear 2010
SaveToStream(Stream,FileFormat) Method
See Also  Example Send Feedback
SpreadsheetGear Namespace > IWorkbook Interface > SaveToStream Method : SaveToStream(Stream,FileFormat) 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) 
Overloads 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

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

See Also

Copyright © 2003-2010 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.