We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Overview

The Excel-like WPF grid control is a cell-oriented control for displaying tabular data and can be customized down to the cell level. It does not make any assumptions regarding the structure of the data.It can be used in a virtual manner, where the data is provided on demand in real time, or it can be used in a manner where the cell grid maintains the data within its own internal structures.Its rich feature set includes editing, cell styling, data formatting, covered cells, various cell editors, clipboard operations, formulas, Excel-like selection, frozen rows and columns, importing and more.


High Performance

WPF virtual grid

Instant Loading

Load millions of rows and columns in less time. Also supports on-demand data loading.

Smooth scrolling in WPF Excel-like grid

Smooth Scrolling

Provides smooth scrolling experience even with millions of rows and columns.

Virtually import Excel workbook into WPF Grid control

Virtual Importing

Provides support to virtually import Excel workbooks.


Data Population

Users can populate the grid either by using the Grid control’s internal data storage or provide data on demand through virtual mode.

Populating Excel-like grid

Internal Storage

Users can populate the grid by storing the cell style in its internal storage. The cell style exposes various properties for storing cell appearance and data information of a cell.

On-demand data population in WPF Grid control

Virtual Mode

Provides support for on-demand data population where the grid does not store cell styles in its internal storage. This means the grid can be loaded with millions of rows and columns instantly.


Appearance and Formatting

The Grid control provides cell styles for setting cell data and customizing each cell’s appearance such as its font, background, foreground, borders, orientation, margins, padding, alignment, and more. Cell style can be applied to any range of cells, rows, columns, and tables. Support is also provided for formatting the data.

Cell appearence customization in WPF Grid control


Editing

Provides support for editing the cells with wide range of cell types and events to save the changes to external data source.

Editing and data validation in WPF Grid control

Data Validation

Provides support to validate a cell and display any error information and dialogs. The error information and dialogs can be customized as required.

Clipboard operations in Excel-like grid

Clipboard Operations

Built-in support for clipboard operations such as copy, cut, and paste. The copied content can be customized. Support is also provided to copy and paste with styles preserved between two grids.

Undo and redo operations in WPF Grid control

Undo and Redo

Built-in support for multilevel undo and redo operations for any changes made in the grid. There is no limit to the number of undo and redo operations. Also provides support to group multiple actions as a single transaction.


Cell Types

Built-in support for various cell editors to deal with different types of data for a better editing experience. Users can place any control inside a cell using the DataTemplate cell type. The Grid control provides a pluggable cell renderer architecture for easily implementing custom cell types without compromising on performance. The supported cell types are:

  • Static cell
  • Text box cell
  • Check box cell
  • Button cell
  • Image cell
  • Combo box cell
  • Data template cell
  • Drop-down cell
  • Integer edit cell
  • Double edit cell
  • Currency cell
  • Date-time cell
  • Masked edit cell
  • Percent edit cell
  • Nested grid cell
  • Rich text box cell
  • Text image cell
  • Up-down edit cell
  • Hyperlink cell

Formulas

The Grid control supports Excel-like formulas for calculating the value of a cell. It comes with an extensive formula function library that supports more than 400 built-in formulas covering a broad range of business scenarios. It supports cross-sheet references and named ranges just like Excel, and also allows users to add custom functions.

Formula caculation in Excel-like Grid control


Excel-Like Features

Excel-like covered cells in WPF grid

Covered Cells

Provides support to merge a range of cells into a single cell.

Drag and drop cells in WPF Grid control

Drag and Drop

OLE drag and drop between two grids allows users to copy or move complete style information. Also supports dragging columns or ranges of cells like Excel.

Excel-like cell comments in WPF Grid control

Cell Comments

Support to add comment tips like in Excel. Comment tips can be set to all corners of cells and can also be customized.

Excel-like fill series in WPF Grid control

Drag Fill

Allows users to easily fill or copy a series or pattern of values and formats into neighboring cells in any direction.

Excel-like freeze panes in WPF Grid

Freeze Panes

Provides support to freeze rows at the top and bottom of the grid, and columns at the left and right.

Excel-like input message display in WPF grid

Input Message

Provides support to display input messages when users interact with cells.

Excel-like floating cells in WPF grid component

Floating Cells

Provides support to float cell content to adjacent cells when the content exceeds the cell size.


Interactive Features

Excel-like selection in WPF Grid control

Selection

Support for selecting a range of cells, rows, or columns with customizable selection color. Excel-like selection frames and current cell selection can also be enabled.

Context menu for WPF Grid control

Context Menu

Provides support for cell-level context menus. Context menu items can be modified at runtime.

Resizing rows and columns in WPF Grid control

Resize

Provides support to resize, hide, and unhide rows and columns.

Virtual scrolling in WPF Grid control

Scrolling

Supports both accelerated scrolling and deferred scrolling. Common scroll bars can be used for two or more grids.

Zooming the WPF Grid control

Zooming

Grid contents can be zoomed in and out as required.

Tooltip for WPF Grid

Tooltip

Tooltip support can be enabled for each cell. The display information can be customized.


Graphic Cells

  • Provides support to load graphical elements into the grid to visually represent the data like Excel.
  • Some predefined graphic cell types are charts, sparklines, pictures, and text boxes.

Loading images and text boxes like in Excel using graphic cells


Importing and Exporting

Import and export Excel file in WPF Grid control

Import and Export

  • Provides support for importing a Microsoft Excel file and preserving the look and feel.
  • Rich set of options available for exporting data to Microsoft Excel file formats, PDF, and CSV.

Print and print preview dialogs in WPF Grid

Printing

Built-in support for the Print and Print Preview dialogs with numerous customization options.


Serialization

Provides support to serialize grid data to binary and XML formats and vice versa.

Serialize and deserialize WPF Grid


UI Automation

Compatible with Coded UI and UFT (formerly QTP) automation tools.

UI automation support for WPF Grid component


90+ WPF CONTROLS

Transform your applications today by downloading our free evaluation versionDownload Free Trial

Scroll up icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon