Skip to main content Skip to footer
WPF Spreadsheet Examples

A Complete WPF Spreadsheet With Over 350 Excel Functions

Deliver true Excel-like spreadsheet experiences, fast - with zero dependencies on Excel. Create financial, budgeting/forecasting, scientific, engineering, healthcare, insurance, educational, manufacturing and many other similar WPF business applications.

Download Free Trial (V 17)
  • Deliver Excel-like spreadsheet experiences, fast, with desktop designer apps
  • Create enterprise spreadsheets, grids, dashboards, and forms with the comprehensive API
  • Powerful calculation engine includes 350+ functions
  • Import and export Excel spreadsheets
  • Develop in Visual Studio using VB or C# for WinForms, ASP.NET, and WPF

Overview

WPF spreadsheet components are advanced software components that allow professional developers to add complete Excel-like functionality to their desktop applications. The WPF spreadsheet control includes support for Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

Benefits of Our WPF Spreadsheet Controls

Complete Toolbox

A Complete High-Performance WPF App Toolbox in One Spreadsheet Control

Leverage the extensive WPF spreadsheet API and powerful calculation engine to create analysis, budgeting, dashboard, data collection and management, scientific, and financial applications.

High-Speed Performance

High-Speed Performance and Optimized App Size

Every platform of Spread.NET ensures maximum performance and speed for your enterprise apps, and its modular structure means you only need to add what you use to your WPF spreadsheet apps.

JavaScript Spreadsheet Designer

Code-Free Extensibility and Customization with Spread Designers

Instantly design a powerful Excel-like WPF spreadsheet app with our desktop designer apps—no learning curve required. Designers are available for WinForms, WPF, and ASP.NET.

Built-in Functions

350+ Function Calculation Engine

With more built-in functions than other WPF spreadsheets, your computing power is optimized for big data, complex calculations, and advanced Excel models.

Visual Studio Integration

Seamless Visual Studio Integration

Build WPF spreadsheet apps in Visual Studio, including VS19, and deploy to Windows 10 with no compatibility issues—and include Excel 2016 themes.

Data Visualization

Advanced Data Visualization

Use the many chart types, sparklines, custom data visualization functions and more to enable your users to create the most advanced data visualizations.

WPF Spreadsheet Dashboards and Data

Data Visualization with Dashboards

Visualize data with dozens of charts and elements.

GET DEMOS
Find and Highlight WPF Spreadsheet data

Find and Highlight Important Data

Visualize data effectively. Use conditional formats to highlight the critical elements of data.

Get Demos
Advanced Financial Modeling with WPF Spreadsheet

Advanced Financial Modeling

Combine the ease of spreadsheet input with complex calculations.

Get Demos
Grid-Based Input Forms for WPF Spreadsheet Applications

Grid-Based Input Forms

Create complex input forms in the free-form grid layout.

Get Demos
Apply Excel themes and styles in a WPF Spreadsheet Component

Excel Theme Colors and Styles

Generate beautiful reports with rich theme colors.

Get Demos

WPF Spreadsheet Top Features

No-Code Design with Spread Designers

With the powerful Spread Desktop Designer App, you’ll get code-free WPF spreadsheet apps and accelerate your application development.

LEARN MORE

Import/Export Excel Files into a WPF Spreadsheet

No spreadsheet is complete without full Excel import/export support! Import and export your WPF spreadsheet to XLSX or other file formats... all with zero dependencies on Excel.

LEARN MORE

Tables and Table Styles

Create tables using built-in table styles or create custom table styles to apply banded columns or rows and custom formatting to highlight your data.


LEARN MORE

Charts

Visualize your data with chart types including Column, Line, Pie, Bar, Area, Scatter, Stock, Surface, Bubble, and Radar, or create combination charts that combine various series types.

LEARN MORE

Sparklines

Visualize your data in a more compact way with sparkline charts that draw directly inside the cell – these tiny charts are perfect for including directly in tables and dashboard reports.

LEARN MORE

Enhanced Sparkline Visual Functions

The enhanced sparklines supported by SpreadJS are now also supported by Spread.NET Windows Forms! 17 new sparkline types can be added using the same formulas as SpreadJS.

LEARN MORE

Data Binding

Connect to a data source and import data into your spreadsheet, or bind the worksheet to a data source of type IList, IEnumarable, or IBindingList.

LEARN MORE

Outline and Range Group

Create row and column range groups that can expand and collapse rows or columns to create vertical and horizontal outlines in the worksheet.

LEARN MORE

Data Validation

Add data validation in cells and specify the type of validation such as list range or valid range of numbers, input message, and error alert.

LEARN MORE

Sparklines, Tables, and Charts

Create tables, apply table styles, calculate table formulas using structured references, and visualize your data using sparklines and charts.

LEARN MORE

Print Reports to PDF

Create advanced report layouts with tables, sparklines, charts, and images using built-in print preview and then print to a local printer or PDF file.

LEARN MORE

Conditional Format Rules

Apply Conditional Format Rules in cells and ranges to apply styles based on the cell content or display icons, data bars, color scales in the cells to quickly visualize values.

LEARN MORE

Sort and Filter

Add filtering and sorting drop-down in a table or range and enable your users to sort the values ascending or descending or select filter items.

LEARN MORE

Themes

Apply one of 20 built-in themes or create a custom theme or XAML theme to customize the control's appearance including split boxes, filter buttons, drop-downs, and more.

LEARN MORE

Floating Objects

Create custom floating objects and images in the worksheet for process flow diagrams, cell callouts, and more, and save and load these objects in XLSX and XML files.

LEARN MORE

Resize and Scroll Tips

Show tooltips on resize of rows or columns displaying the height or width, and show tooltips on scrolling displaying the new top row or left column index.

LEARN MORE

Freeze Panes

Freeze rows and/or columns at the top or left of the worksheet and keep those rows and/or columns from scrolling out of view as the user scrolls down or right in the worksheet.

LEARN MORE

Split View

Create split views to show multiple areas of the worksheet at once regardless of how many rows or columns are between, that save and load with the XLSX.

LEARN MORE

Cell Styles

Apply built-in cell styles using Theme colors, and create new custom Cell Styles with various accents to show and highlight your data.

LEARN MORE

Cell Borders and Gridlines

Apply cell borders with various styles and colors including bevel borders, double-line borders, outline borders, various border styles, and more.

LEARN MORE

Merge and Span Header Cells

Create multiple row and column headers and span cells in the headers to create grouped sets of rows or columns in a tabular report layout.

LEARN MORE

Search Cells

Search in the cells and specify custom search options for match case, exact match, wildcards, search scope, search direction, and search values or formulas.

LEARN MORE

Merge and Span Cells

Merge cells by applying a span cell to data area or header cells to create hierarchical tabular report layouts or tablix-type report layouts.

LEARN MORE

Cell Formatter

Apply cell format strings for number and date formats as in Excel and specify a separator, decimal point, currency symbol, date format, and more.

LEARN MORE

Data Validation

Add data validation in cells and specify the type of validation such as list range or valid range of numbers, input message, and error alert.

LEARN MORE

350+ Functions in Customizable Library

Functions for every type of calculation, support for adding custom functions, and full customization for your formulas — take your complex spreadsheets to the next level.

LEARN MORE

Formula Text Box

The Formula Text Box control attaches to the spreadsheet to provide separate control for viewing and editing formulas in the active cell and highlighting cell and range references.

LEARN MORE

Names and Name Manager

Use names in your formula calculations to optimize your formulas and make them more readable, and use Name Manager to organize and manage your formula names.

LEARN MORE
Spread.NET WPF Designer

Spread Includes Code-Free, Excel-Like Designers for WinForms, WPF, and ASP.NET

Spread’s code-free desktop designer apps are included in both the licensed and trial versions. You can immediately create a full application with our templates, or experiment with the free-form data layout. Export your design for a quick import into the platform of your choice!

Learn more

What's New in Spread.NET v17

Award-Winning Products and First-Class Support

Five Star Rating

"I have been using a various form of Spread back to the COM days. Spread is the most reliable spreadsheet that retrieves and stores data, whether interacting with a database or simply an Excel file. Try it out, and you will not go back to any other control"

TRUSTED CUSTOMER

Five Star Rating

"Great support through evaluation process, Spread is my favorite development add-in, adds great, high value capabilities to applications!"

TRUSTED CUSTOMER

Five Star Rating

"Excellent Products. I have been using their products for around 15 years. Always there to help."

TRUSTED CUSTOMER

ComponentSource Awards - #2 PUBLISHER 2023 CopmonentSource Awards - TOP 10 PRODUCT 2023

MESCIUS Spread is Trusted by the World's Leading Companies

Customer Logos

"Thanks for providing the best [JavaScript] spreadsheet widget in the world, we're very happy customers. Your product has saved us a TON of time relative to other solutions we used in the past."

Jan Domanski, Labstep

"We have been using Spread in our desk and web products (PerpetualBudget) for over a decade. Not only are the Spread grids great controls but the support at GrapeCity [now known as MESCIUS] is the best. When you need them, they're there!"

Jim Spicer, Spicer-Baer Associates

"I haven't come across such a feature-rich solid Spread before. Thanks for giving such a nice component."

Adavesh Managaon, MVP, Visual C#

"Spread benefits my company because our clients can now see the immediate benefit the websites we create for them provide."

Michael Stark, Owner, StarkNetwork.com