A newer version of this page is available. Switch to the current version.

XtraReport.ExportToXls(String, XlsExportOptions) Method

Exports a report to the specified file path in XLS format using the specified XLS-specific options.This method exports data in WYSIWYG mode. Certain controls (e.g., a GridControl) can be exported to XLS(XLSX) format in a faster data-aware export mode, optimized for subsequent analysis of data in MS Excel. To learn how to employ data-aware export, see Export to XLS and XLSX Formats.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v18.2.dll


public void ExportToXls(
    string path,
    XlsExportOptions options
Public Sub ExportToXls(
    path As String,
    options As XlsExportOptions


Name Type Description
path String

A String which specifies the file name (including the full path) for the created XLS file.

options XlsExportOptions

A XlsExportOptions object which specifies the XLS export options to be applied when a report is exported.


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 to an XLS file using the specified XLS export options (like XlExportOptionsBase.ShowGridLines, XlExportOptionsBase.TextExportMode, etc.).

Note that in this instance the current report export options, which are represented by the XlsExportOptions object returned by the ExportOptions.Xls property of a report's XtraReport.ExportOptions, are ignored.

If, instead, you want to use the current export options of a report, you should call the overloaded XtraReport.ExportToXls method without the options parameter.


This method overwrites any files present at the specified path that have the same file name without any warnings.

To learn more, see Export to XLS.


The following example demonstrates how to export a report to XLS format. To do this, the XtraReport.ExportToXls method should be used. It also demonstrates what specific XlsExportOptions may be used when a report is exported to XLS.

For this example to work, you first need to add a new report (named XtraReport1) to your project, drop some report controls onto it, and then execute the code below (for instance, in the Button.Click event handler of any button on a form). Note also, that if you want the resulting file to be automatically opened in the default program which is used to open *.xls files in your system, you can call the StartProcess method, which is also shown in this example.

using System;
using System.Windows.Forms;
using System.Diagnostics;
using DevExpress.XtraPrinting;
using DevExpress.XtraReports.UI;
// ...
        private void ExportToXLS() {
            // A path to export a report.
            string reportPath = "c:\\Test.xls";

            // Create a report instance.
            XtraReport1 report = new XtraReport1();

            // Get its XLS export options.
            XlsExportOptions xlsOptions = report.ExportOptions.Xls;

            // Set XLS-specific export options.
            xlsOptions.ShowGridLines = true;
            xlsOptions.TextExportMode = TextExportMode.Value;

            // Export the report to XLS.

            // Show the result.
        // Use this method if you want to automaically open
        // the created XLS file in the default program.
        public void StartProcess(string path) {
            Process process = new Process();
            try {
                process.StartInfo.FileName = path;
            catch { }
See Also