Excel Data Source
The Data Source Configuration Wizard allows you to bind the PivotGridControl to an Excel data source using the ExcelDataSource component. To learn how to do this, see the following topic: Binding to Excel Data Sources.
After you have connected to the Excel data source, you can use the Retrieve Fields command to retrieve the available data source fields. As an alternative, you can add specific fields manually using the PivotGrid Designer. To do this, use the Run Designer... command.