PrintingSystemBase.ExportToXls(Stream) Method

Exports a report to the specified stream in XLS format.

Namespace: DevExpress.XtraPrinting

Assembly: DevExpress.Printing.v24.2.Core.dll

Declaration

C#

public void ExportToXls(
    Stream stream
)

VB.NET

Public Sub ExportToXls(
    stream As Stream
)

Parameters

Name	Type	Description
stream	Stream	A Stream object to which the created XLS file should be sent.

Remarks

Once the document export has started, it will run until the resulting document is complete and cannot be interrupted or canceled in the process.

Use this method to export a report in XLS format using its current XLS-specific export options.

These options are represented by the XlsExportOptions object returned by the ExportOptions.Xls property of a printing system’s PrintingSystemBase.ExportOptions. This object provides the XlExportOptionsBase.ShowGridLines, XlExportOptionsBase.TextExportMode and other properties which are intended to specify parameters of the resulting XLS file.

If you want to ignore current export options of a report, and use your specific settings when a report is exported to XLS, you should use the overloaded PrintingSystemBase.ExportToXls method with the options parameter.

For more information, see Export to XLS.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ExportToXls(Stream) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

asp-net-mvc-grid-export-multiple-gridviews-into-a-document/CS/Controllers/HomeController.cs#L56

MemoryStream stream = new MemoryStream();
link.PrintingSystemBase.ExportToXls(stream);
stream.Position = 0;

VB.NET

asp-net-mvc-grid-export-multiple-gridviews-into-a-document/VB/Controllers/HomeController.vb#L61

Dim stream As New MemoryStream()
link.PrintingSystemBase.ExportToXls(stream)
stream.Position = 0