Save(Stream) Method

Saves the worksheet into a stream.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub Save( _
   ByVal stream As System.IO.Stream _
)

public void Save( 
   System.IO.Stream stream
)

Parameters

stream: System.IO.Stream where the worksheet is saved.

Remarks

This method allows saving the workbook directly into streams without using temporary files. Typical uses include saving books to web page response streams or mail attachment streams.

Example

The code below saves a C1XLBook into a System.IO.MemoryStream, clears the book, then loads it back from the same stream.

// save book into new MemoryStream
MemoryStream ms = new MemoryStream();
_book.Save(ms);
            
// clear book
_book.Clear();
            
// load it back from the MemoryStream
ms.Position = 0;
_book.Load(ms);

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

C1XLBook Class
C1XLBook Members
Overload List