Back to Devexpress

Bind a Report to an Excel Workbook

xtrareports-114900-feature-guide-to-devexpress-reports-bind-reports-to-data-excel-file-bind-a-report-to-an-excel-workbook.md

latest1.6 KB
Original Source

Bind a Report to an Excel Workbook

  • Feb 18, 2026
  • 2 minutes to read

This tutorial describes how to bind a report to data obtained from a Microsoft Excel workbook.

Do the following to accomplish this task:

  1. Click the report’s smart tag. In the invoked actions list, expand the drop-down menu for the XtraReportBase.DataSource property and click the Add Report Data Source… link.

  2. On the first page of the invoked Data Source Wizard, select Excel File and click Next.

  3. On the next wizard page, select a required Excel workbook. To do this, click the ellipsis button and locate the source file or enter the full path to this file. The XLS, XLSX and XLSM formats are supported.

  4. The next wizard page allows you to specify import settings.

  5. On the next wizard page specify from which part of the workbook to extract data. All worksheets, tables and named regions existing in the workbook are listed here.

  6. The next wizard page allows you to select required columns and specify their settings.

The created data source becomes displayed in the Report Explorer‘s Data Sources node. The Field List reflects the data source’s hierarchy.

See Also

Excel File