Skip to main content
All docs
V25.1
  • XtraReport.ExportToXlsxAsync(String, XlsxExportOptions, CancellationToken) Method

    Asynchronously exports a report to the specified file in XLSX format.

    Namespace: DevExpress.XtraReports.UI

    Assembly: DevExpress.XtraReports.v25.1.dll

    NuGet Package: DevExpress.Reporting.Core

    Declaration

    public Task ExportToXlsxAsync(
        string path,
        XlsxExportOptions options = null,
        CancellationToken token = default(CancellationToken)
    )

    Parameters

    Name Type Description
    path String

    The path to the exported XLSX file.

    Optional Parameters

    Name Type Default Description
    options XlsxExportOptions null

    The XLSX export options. You can omit this parameter to use the current report export options.

    token CancellationToken null

    A cancellation token that the task observes.

    Returns

    Type Description
    Task

    A task that exports the report.

    Remarks

    This method is equivalent to the ExportToXlsx(String, XlsxExportOptions) method but does not lock other actions performed concurrently. For instance, the user interface remains operational while the application exports a report.

    Call ExportToXlsxAsync from an async method. Prefix the call with the await operator, as shown in the code sample below.

    The optional CancellationToken parameter provides a way to send the cancellation signal to the task. The task monitors the token and stops when it receives the signal. Create a CancellationTokenSource class instance and pass its Token property to the ExportToXlsxAsync method call. Call the CancellationTokenSource.Cancel method to stop the task.

    Example

    The code sample below exports a report to XLSX asynchronously. A CancellationTokenSource class instance is used to allow users to interrupt the report export if it takes too long.

    using DevExpress.XtraReports.UI;
    using System;
    using System.Threading;
    // ...
    // Use cancellationTokenSource to allow users to stop the document creation process.
    CancellationTokenSource cancellationTokenSource = new CancellationTokenSource();
    // ...
    // The cancelButton_Click event handler uses cancellationTokenSource to stop the document creation process.
    private void cancelButton_Click(object sender, EventArgs e)
    {
        cancellationTokenSource.Cancel();
    }
    // ...
    async public void ExportReportToXlsxFileAsync()
    {
        // Create a simple report.
        XtraReport report = new XtraReport()
        {
            Name = "SimpleReport",
            Bands = {
                new DetailBand() {
                    Controls = {
                        new XRLabel() {
                            Text = "Simple Report"
                        }
                    }
                }
            }
        };
        // Export the report. The export file is added to the user's Downloads folder.
        await report.ExportToXlsxAsync(
            Environment.GetFolderPath(Environment.SpecialFolder.UserProfile) + @"\Downloads\" + report.Name + ".xlsx",
            null,
            cancellationTokenSource.Token);
    }
    
    See Also