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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

.NET Spreadsheet Top Features

.NET Spreadsheet Solution Spread NuGet Package

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

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.

.NET Spreadsheet Solution Cell Data Types Custom Objects

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.

.NET Spreadsheet LET Function

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.

.NET Spreadsheet Enhanced Shapes and Edit Points

NEW: Edit Points in Enhanced Shapes

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.

.NET Spreadsheet Enhanced Hyperlink Support

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.

.NET Spreadsheet Show Formulas

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.

Enhanced Excel-compatible Keyboard Shortcuts

Enhanced Excel-compatible Keyboard Shortcuts

Use FpSpread.Features.ExcelCompatibleKeyboardShortcuts 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

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.

.NET Spreadsheet Calculations

Powerful, Fast, Optimized Calculation Engine

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

.NET Spreadsheet 450+ Built-In Functions

450+ 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

.NET Spreadsheet Spread Designer

No-Code Design with Spread Designers

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

.NET Import and Export

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.

.NET Spreadsheet Shapes

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.

.NET Spreadsheet Slicers

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.

.NET Spreadsheet Dynamic Arrays

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.

.NET Spreadsheet Language Packs

Language Packages for Formulas and Enhance 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.

.NET Spreadsheet Formula Tracing and Auditing

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.

.NET Spreadsheet Xlookup and Xmatch

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.

.NET Spreadsheet Custom Calculations

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.

.NET Spreadsheet Data Visualization

Custom Data Visualization using Visual 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.

.NET Spreadsheet Sorting and Filtering

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.

.NET Spreadsheet Cell Styles

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.

.NET Spreadsheet Conditional Formatting

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.

.NET Spreadsheet Tables

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.

.NET Spreadsheet Cell Types

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.

.NET Spreadsheet Cell Comments

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.

.NET Spreadsheet Cell Borders

Cell Borders

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

.NET Spreadsheet Merged Cells

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.

.NET Spreadsheet Search

Search

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

.NET Spreadsheet Charts

Charts

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

.NET Spreadsheet Sparklines

Sparklines

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

.NET Spreadsheet Status Bar

Status Bar

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

.NET Spreadsheet Data Binding

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.

.NET Spreadsheet Outline and Range Group

Outline and Range Group

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

.NET Spreadsheet Outlook-Style Grouping

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.

.NET Spreadsheet Printing

Printing

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

.NET Spreadsheet Skins

Skins

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

.NET Spreadsheet Touch

Touch

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

.NET Spreadsheet Solution Sparkline Visual Functions

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.

.NET Spreadsheet LAMBDA Function

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.

.NET Spreadsheet LAMBDA Helper 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!

.NET Spreadsheet Cell Rich Text

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.

.NET Spreadsheet Freeform Shape and Scribble

Freeform Shape and Scribble

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

.NET Spreadsheet Enhanced Camera Shape

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.

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

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

<a href="/spreadnet/releases">What's New in Spread.NET v15</a>

What's New in Spread.NET v15

This release features new platform controls for .NET 4.5.2+, .NET Core 3.1, and .NET 6.0, and major enhancements for calculations, data visualization, rich text and more.

What's New

Award-Winning Products and First-Class Support

ComponentSource - Number 2 Publisher 2020 ComponentSource - Top 5 Product 2020 ComponentSource - Top 50 Product 2020 ComponentSource - Top 50 Product 2019

GrapeCity Spread is Trusted by the
World’s Leading Companies

Trusted by the World’s Leading Companies