Skip to main content
BuyLog In
WinForms Controls
Search in…
Docs > Controls and Libraries > Pivot Grid > Binding to Data > Data Source Configuration Wizard > Excel Data Source
A newer version of this page is available. .
All docs
V18.2
WinForms Controls
Prerequisites
What's Installed
Build an Application
Controls and Libraries
Forms and User Controls
Messages, Notifications, and Dialogs
Editors and Simple Controls
Ribbon, Bars and Menu
Application UI Manager
Docking Library
Data Grid
Vertical Grid
Property Grid
Pivot Grid
Getting Started
Fundamentals
Binding to Data
Binding to Data Overview
Data Source Configuration Wizard
ADO.NET Data
SQL Data
Excel Data Source
Unbound Data Source
Entity Framework Data
Entity Framework (EF) Core
LINQ to SQL
WCF Data Services
OData V4
XPO Data Source
IList and IEnumerable Data Sources
XML Data
OLAP Cube
BindingSource Component Specifics
OLAP Data Source
Database Server Mode
Unbound Fields
Local Data Stores
Asynchronous Mode
Data Shaping
Data Analysis
Layout
Focus and Navigation
Printing and Exporting
Appearance
Design-Time Features
Miscellaneous
UI Elements
End-User Capabilities
Examples
Member Tables
Tree List
Chart Control
Diagrams
Gauges
Map Control
Scheduler
Spreadsheet
Rich Text Editor
Spell Checker
Form Layout Managers
Navigation Controls
Printing-Exporting
PDF Viewer
Reporting
Snap
TreeMap
Sunburst Control
Common Features
Get More Help
API Reference
Download CHM

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.

WinPivot_BoundToExcelDataSource

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.