Displays data in a tabular format in virtual mode without any assumption regarding the structure of data.
Includes an Excel-like rich feature set that supports editing, selection, cell merging, cell comments, and more.
Completely customizable at any level of a cell, row, or column for an intuitive UI experience for your line-of-business application.

.NET 10 support now available

Trusted by the world’s leading companies

WPF excel like grid

Overview

The Excel like WPF grid control (virtual grid) is a cell-oriented control for displaying tabular data. It does not make any assumptions regarding the structure of the data. Users can customize it down to the cell level. Users can use a grid virtually where the data is provided on demand in real-time. The control’s 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

Instant loading illustration of WPF Excel like grid

Instant loading

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

Smooth scrolling illustration of WPF Excel like grid

Smooth scrolling

Experience smooth scrolling even with millions of rows and columns.

Virtual importing illustration of WPF Excel like grid

Virtual importing

Virtually import Excel workbooks into a grid.

Data management

Internal storage illustration of WPF Excel like grid

Internal storage

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

WPF virtual grid illustration

Virtual grid

Use on-demand data population in which 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.

Editing

Built-in cell types in WPF Excel like grid

Built-in cell types

Deal with different types of data with various 10+ cell editors for a better editing experience. Some of the supported cell types are:

TextBox
CheckBox
Button
Image and more

Built-in cell types documentation

Custom cell types in WPF Excel like grid

Custom cell type

Load or place any graphical elements (controls) into the grid to visually represent data, like in Excel.
Some predefined graphic cell types are: charts, sparklines, images, and text boxes.
Display banner for the range of cells for intuitive user experience.

Custom cell type documentation

Data validation in WPF Excel like grid

Data validation

Validate a cell and display error information and dialogs. Users can customize the error information as required.

Clipboard operations in WPF Excel like grid

Clipboard operations

Built-in support for clipboard operations such as copy, cut, and paste. Copy and paste the styles preserved between two grids. Users can customize the copied data.

Undo and redo operations in WPF Excel like grid

Undo and redo

Use multilevel undo and redo operations for any changes made in the grid. There is no limit to the number of these operations. You can also group multiple actions as a single transaction.

Excel-inspired formula calculation

Excel-like formulas for calculating the value of a cell.
An extensive formula function library that supports more than 400 built-in formulas. Users can add custom logic formula functions as required.
Cross-sheet references and named ranges like in Excel.

Formula calculation in WPF Excel like grid

Selection

Users can select a range of cells, rows, or columns with a customizable selection color.
Users can also make a selection using an Excel-like selection frame.

Selection in WPF Excel like grid

Appearance style

Data formatting in WPF Excel like grid

Data formatting

Users can customize cell styles at any level by formatting the data and customizing each cell’s appearance with:

Font styles
Background
Text color
Borders
Text orientation
Text margins

Cell styling can be applied to any range of cells, rows or columns.

Conditional formatting in WPF Excel like grid

Conditional formatting

Customize the appearance of cells, rows, or columns conditionally based on data.

Row and column resizing

Column width and row height can be adjusted (auto fit) based on the content of any row, column, or column header.
Users can also resize the columns or rows by resizing column or row headers, like in Excel.

Row and column resizing in WPF Excel like grid

Smooth scrolling

Accelerated scrolling and deferred scrolling can be used.
Common scroll bars can be used for two or more grids.

Smooth scrolling in WPF Excel like grid

Excel-inspired features

Users can interact with the grid with a rich interaction experience like in Excel. The control provides the following rich, Excel-like features:

Cell merging
OLE drag and drop
Cell comment
Fill and copy series
Freeze panes
Floating cells
Input message

Learn more about Excel inspired features

Excel-inspired features in WPF Excel like grid

Cell-level context menus expose the functionality on the user interface. Context menu items can be modified at runtime.

WPF Excel like grid shows a context menu

Display an additional hint or information about a cell through a tooltip. Users can customize tooltip appearance using templates.

WPF Excel like grid shows a tooltip

Zooming

View the grid content clearly by zooming in and out.

Zooming in WPF Excel like grid

Importing and exporting

Importing and exporting illustration of WPF Excel like grid

Import and export

Import a Microsoft Excel file and preserve the look and feel in the grid.
Export data to Microsoft Excel, PDF, and CSV file formats with a rich set of available options.

Printing illustration of WPF Excel like grid

Print

There’s built-in support for the print and print preview dialogs with numerous customization options.

Serialization

Serialize the WPF Excel like grid control settings to XML format and load them back (deserialize) to grid.

Serialization documentation

UI automation

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

UI automation illustration of WPF Excel like grid

ALL CONTROLS

GRIDS

DATA VISUALIZATION

MODERN THEMES

Theme Studio

LAYOUT

NAVIGATION

INPUT CONTROLS

BUTTONS

CALENDARS

BUSINESS INTELLIGENCE

DATA SCIENCE

Predictive Analytics

MISCELLANEOUS

LISTS & DROPDOWN

NOTIFICATION

FILE VIEWERS & EDITORS

CONVERSATIONAL UI

AI AssistView PREVIEW

Our Customers Love Us

Having an excellent set of tools and a great support team, Syncfusion^® reduces customers’ development time.
Here are some of their experiences.

Excellent experience with Syncfusion!

Syncfusion is a product that makes life easier! I use it to create Blazor applications (server side and webassembly) and the controls speed up development a lot. Furthermore, if needed, it is possible to ask for direct support that is never long in coming!

Andrea Scarpante,

Sydea srl

The complete component set

It is the most complete component set available. Also very handy is the fact that there is a community edition, this gives me the opportunity to test thing at home without buying a separate license.

Johan Visser,

H and T Pawnbrokers

See Real Success Stories

Developers around the world trust Syncfusion’s Essential Studio to simplify complex projects and speed up delivery. With a vast library of UI controls, powerful SDKs, and reliable support, Essential Studio helps teams build enterprise-ready applications with confidence.

Explore Case Studies

Industry

Software development

75%Cost reduction

50%Faster development

“If somebody is looking for a great tool to work with? Yes. I would definitely recommend Syncfusion for anyone who is trying to develop something meaningful.”

- Somnath Maji (Founder of Igniatek Consultancy)

Read Story