The World's #1 Selling .NET Spreadsheet With Over 450 Excel Functions

Explore the possibilities of your .NET enterprise apps with these dependency-free .NET spreadsheet components.

Download Free Trial (V 16.1.20231.0)
  • NEW: v15 NuGet package now supports .NET 6.0, .NET Core 3.1, and .NET 4.62+
  • 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 450+ functions
  • Import and export Excel spreadsheets
  • Develop in Visual Studio using VB or C# for WinForms, ASP.NET, and WPF

Need to Programmatically Generate Excel Files for Server-Side/Backend Applications?

Check out our .NET Excel Spreadsheet API Library

Overview

.NET spreadsheet components are advanced software components that allow professional developers to add complete Excel-like functionality to their desktop applications. The .NET 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.

A Complete High-Performance .NET App Toolbox in One Spreadsheet Control

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

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 .NET spreadsheet apps.

Code-free Extensibility and Customization with Spread Designers

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

Powerful Calculation Engine Includes 450+ Functions

With more built-in functions than other .NET spreadsheets, custom functions, and the formula text box, your computing power is optimized for big data, complex calculations, and advanced Excel models.

Seamless Visual Studio Integration

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

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.

Dashboards and Data

Visualize data with dozens of charts and elements.

  • Customizable charts and sparklines
  • Cross-sheet references
  • Flexible cell types
  • Conditional formatting
  • Custom cells for alert buttons

Excel-Like Apps

Create Microsoft Excel-like interactive data views and forms.

  • Import and export from Excel
  • Printing and print preview
  • Grouping, sorting, and filtering
  • Ribbon and file menu
  • No-hassle data binding

Complex Data Modeling

Combine the ease of spreadsheet input with complex calculations.

  • 450+ built-in formulas
  • Custom functions
  • Formula text box
  • High-speed calculating power
  • Cross-worksheet references

Grid-Based Input Forms

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

  • Tab-based navigation
  • Code-free designers for Excel-like design
  • Excel-like copy and paste
  • Smart data validation
  • Buttons
  • Checkbox & ComboBox

Accounting Statements

Generate accounting reports like this accounts receivable statement.

  • Status bars
  • Excel-like tables with filtering
  • Footer rows
  • Embed logos and pictures

.NET Spreadsheet Top Features

NEW: NuGet Package for .NET 6, .NET Core 3.1, and .NET 4.6.2+

Add Spread to your project quickly and easily using NuGet Package Manager, and create new applications for .NET Core 3.1 and .NET 6 Windows targets.



No-Code Design with Spread Designers

With the powerful Spread Desktop Designer App, you’ll get code-free .NET spreadsheet apps in no time.





Import/Export Excel Files into a .NET Spreadsheet

No spreadsheet is complete without full Excel import/export support! Import your most advanced Excel spreadsheets and then export your Spread.NET spreadsheet to XLSX or other file formats... all with zero dependencies on Excel.

Language Packages for Formulas and Enhanced Localization for Users

Localize your cell formulas with 18 new Language Packages to parse and format the formulas using structured references like Excel, or create a new custom Language Package.


Custom Data Visualization using Visualization Functions

Create custom data visualization functions that extend the Custom Function feature with new interfaces for applying styling or drawing custom content directly in the cell to create new reusable data visualizations that can be used directly in cell formulas.

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.




Charts

Visualize your data with advanced chart types such as Waterfall, Pareto, Funnel, TreeMap, and more.


Sparklines

Visualize your data in a more compact way with sparkline charts that draw directly inside the cell.


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.

Data Binding

Bind the worksheet to any .NET data source including DataSet, DataView, DataTable, or a custom collection of objects, and show hierarchical views with expandable rows and child worksheets.

Outline and Range Group

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

Outlook-Style Grouping

Create Outlook-style groupings of rows using the built-in group bar and customize group footers with aggregation functions in the footer cells.

Printing

Print your worksheets with advanced options including margins, header and footer, best fit column and/or row and print scaling.

NEW: Edit Points in Enhanced Shapes

Feature Subhead

Easily create custom shapes using the new Edit Points feature, or create custom shapes in code using the new API to specify the shape points and segments.


NEW: Enhanced Hyperlink Support

Add hyperlinks in cells by simply typing in the link using AutoCreateHyperlink, or use the Edit Hyperlink dialog. Hyperlinks can be applied to shapes or cells, and import/export in XLSX.


Enhanced Excel-compatible Keyboard Shortcuts

Use FpSpread.Features.ExcelCompatible KeyboardShortcuts and the Excel Compatibility Input Maps to easily enable common Excel keyboard shortcuts in your applications for users. The API allows full customization of the Input Maps and Action Maps to suit your needs.

Multiple Worksheet Select

Use Ctrl+Click to select multiple worksheet tabs for Copy, Cut, Delete, or Hide. Implement custom actions to process multiple selected worksheets.


Enhanced Shape Engine with Group Shape

Create flowcharts, process diagrams, cell callouts, and more with over 150 shapes, lines, and arrows. Connect and combine into Group Shapes to design logos or custom dashboard controls that can be scripted to perform user actions.

Slicers for Easy Table Filtering Selection

Create Slicers to display table column values for filtering, apply themes, and styles to customize. Cut and paste the Slicer to another sheet to operate as a dashboard control.


Sorting and Filtering

Add filtering and sorting drop-down in a table or range and enable your users to apply filters on colors, text, dates, and numbers.

Conditional Format Rules

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

Search

Allow your users to search for text in cells using the built-in Basic Search and Advanced Search dialogs.


Status Bar

Add a status bar and customize it to show function calculations on the selection and worksheet zoom controls.

Skins

Customize the appearance of the workbook and worksheet using built-in skins, or create a custom skin using the Skins Editor.

Touch

Use touch gestures including tap, press and hold, slide, swipe, pinch, rotate, and stretch, and customize the popup touch menu with custom commands.

Freeform Shape and Scribble

Add new Freeform: Shape and Freeform: Scribble shapes in your workbooks using the new Enhanced Shape Engine.



Enhanced Camera Shape

The new Enhanced Camera Shape enables dynamic updates to the cell range displayed using a simple formula. Easily create rich and dynamic dashboards that update based on user selections.

NEW: Cell Data Types for custom .NET objects

Create custom data types and set objects in cells, then use formulas to reference the object's properties in calculations. Use built-in UI or code to insert formulas in adjacent cells and table columns.

Cell Styles

Apply built-in cell styles using Theme colors, and create new custom cell styles with Number, Alignment, Font, Border, Fill, and/or Protection settings including Pattern and Gradient Fills in the Cell Format.

Cell Types, Data Validation

Apply Cell Types, Cell Validators, or IValidation for data validation in cells such as whole number, list, date, time, and custom with input message and error alert.

Cell Comments and Sticky Notes

Add pop-up cell comments that show when the user hovers over the cell note indicator, or apply sticky notes for the cell that remain visible in the sheet with a line indicating the cell.

Cell Borders

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

Merged Cells and Cell Spans

Apply row or column merge to automatically merge cells with like data, or apply span cells to data area or header cells to explicitly merge specific cells.

Rich Text With Superscripts and Subscripts

Import and Export XLSX containing rich text including colors, fonts, superscript and subscript using the new Features.RichText property to enable this feature.

NEW: LET Function optimizes formula calculations

Make your formulas easier to read and improve calculation performance using the new LET function to define local names for intermediate calculation steps.

NEW: Show Formulas Command

Built-in support for the Show Formulas command allows the user to toggle showing formulas in cells using Ctrl+` just as in Excel.

Powerful, Fast, Optimized Calculation Engine

This high-speed, optimized engine adds computing power to even the most complex formulas without dragging down your apps.

500+ Functions in Customizable Library

More functions than in any available .NET spreadsheet, and full customization for your formulas—you’ll take your complex spreadsheets to the next level.




Dynamic Array Formulas and Functions to Optimize Your Calculations

Use dynamic array formulas to optimize your calculations by calculating a range of results in one formula with the new functions including FILTER, RANDARRAY, SEQUENCE, SINGLE, SORT, SORTBY, and UNIQUE.

Show Precedent and Dependent Cells with Formula Tracing and Auditing

Easily trace your formula's reference chains using built-in formula tracing methods to show arrows from the cell to all dependent or precedent cells, and audit formulas using Dependents, DirectDependents, DirectPrecedents, and Precedents.

XLOOKUP and XMATCH Functions

Optimize your formulas and eliminate the use of the old HLOOKUP, VLOOKUP, and MATCH functions using the new XLOOKUP and XMATCH functions.



Custom Calculation Functions to Extend the Calculation Engine

Create custom calculation functions that implement custom code to perform your calculation and return the result value or dynamic array that can spill to adjacent cells, and optionally allow the end-user to enter formulas using these functions.

LAMBDA Function Support

Create new custom functions using the new LAMBDA Function and formula syntax by defining a custom name, then used in other cells like built-in functions.



LAMBDA Helper Functions

Use the new LAMBDA helper functions MAP, REDUCE, SCAN, MAKEARRAY, BYCOL, BYROW, and ISOMITTED to create advanced LAMBDA functions with Spread.NET 15!

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 v16

Spread.NET v16 is available! This release offers several great new features and enhancements such as:

  • Rich Text Editing
  • 19 New Built-in Formula Functions for Calculations
  • Worksheet Protection Options Dialog
  • Forecast Sheet Dialog
  • Goal Seek Dialog
  • DataTable Dialog
  • Text to Columns Dialog
  • Remove Duplicates Dialog
  • And Much More!

Award-Winning Products and First-Class Support

"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

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

TRUSTED CUSTOMER

"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

"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 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