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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

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.

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

Excel-inspired features in WPF Excel like grid


Context menu

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


Tooltip

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.


UI automation

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

UI automation illustration of WPF Excel like grid


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