SpreadsheetControl.LoadDocument(Stream) Method

Loads the document from a stream.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v23.2.dll

NuGet Package: DevExpress.Win.Spreadsheet

Declaration

C#

public bool LoadDocument(
    Stream stream
)

VB.NET

Public Function LoadDocument(
    stream As Stream
) As Boolean

Parameters

Name	Type	Description
stream	Stream	A Stream object that is the stream used to load a document.

Returns

Type	Description
Boolean	true if the document is loaded succesfully; otherwise, false.

Remarks

The target stream can use a non-seekable stream to load a document. In this case, the stream buffers automatically.

The format of the document loaded using this LoadDocument method overload is detected automatically by the built-in IFormatDetectorService implementation. The following formats can be detected:

• XLSX, XLSB, XLSM, XLTX, XLTM (non encrypted files only);
• XLS, XLT;
• XML Spreadsheet 2003;
• CSV, TXT (only if loaded from a FileStream instance).

If the format detection fails, an ISpreadsheetComponent.InvalidFormatException is raised.