ASPxGridBase.ExportToXls(Stream) Method

Exports the control’s data to the specified stream in XLS format using the specified options.

Namespace: DevExpress.Web

Assembly: DevExpress.Web.v23.2.dll

NuGet Package: DevExpress.Web

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 document is exported.

Remarks

This method indirectly calls the PrintingSystemBase.ExportToXls method of the XtraPrinting Library. If this library is not available the method does nothing. For details on the ExportToXls method, see the PrintingSystemBase.ExportToXls topic.

Concept

Export

Online Demo

ASPxGridView - Export To Different Formats

Example

Note

Full example:

• Web Forms: How to combine a number of ASPxGridView documents in one when exporting
• MVC: How to export multiple GridViews into a single print document

C#

protected void ExportButton_Click(object sender, EventArgs e) {
    PrintingSystemBase ps = new PrintingSystemBase();

    PrintableComponentLinkBase link1 = new PrintableComponentLinkBase(ps);
    link1.Component = GridExporter1;

    PrintableComponentLinkBase link2 = new PrintableComponentLinkBase(ps);
    link2.Component = GridExporter2;

    CompositeLinkBase compositeLink = new CompositeLinkBase(ps);
    compositeLink.Links.AddRange(new object[] { link1, link2 });

    compositeLink.CreateDocument();
    using(MemoryStream stream = new MemoryStream()) {
        compositeLink.ExportToXls(stream);
        WriteToResponse("filename", true, "xls", stream);
    }
    ps.Dispose();
}