Explore the possibilities of your VB.NET enterprise apps with these dependency-free VB.NET spreadsheet components.Download Free Trial (V 16.0.20221.0)
VB.NET spreadsheet components are advanced software components that allow professional developers to add complete Excel-like functionality to their desktop applications. The VB.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 VB.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 VB.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.
Create Microsoft Excel-like interactive data views and forms.
Complex Data Modeling
Combine the ease of spreadsheet input with complex calculations.
Grid-Based Input Forms
Create complex input forms in the free-form grid layout.
Generate accounting reports like this accounts receivable statement.
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.
Import/Export Excel Files into a VB.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.
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.
Bind the worksheet to any VB.NET data source including DataSet, DataView, DataTable, or a custom collection of objects, and show hierarchical views with expandable rows and child worksheets.
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.
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 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.
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.
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 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.
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.
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
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.
Spread.NET v16 is available! This release offers several great new features and enhancements such as:
View All Blogs
"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"
"Great support through evaluation process, Spread is my favorite development add-in, adds great, high value capabilities to applications!"
"Excellent Products. I have been using their products for around 15 years. Always there to help."
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