Spread.Sheets doesn’t require external libraries or frameworks such as jQuery. External frameworks are supported, but not required, and Spread.Sheets includes TypeScript support
Modular--Use only what you need
Full Angular support
Develop enterprise spreadsheet applications using the Angular framework, including Angular v5
Add popular chart types to your spreadsheets, including column, bar, line, pie, doughnut, area, scatter, bubble, stock, and combination.
This client-side component will work for Windows, Linux, and MacOS, as well as mobile operating systems such as Android and iOS
Runs in all modern browsers
Spread.Sheets is tested in Chrome, Firefox, Safari, Edge, and Internet Explorer in both mobile and desktop form
Touch controls are available on touch-enabled devices
Excel-like Spreadsheet UI
Present data in a grid layout, a single spreadsheet, or in a multiple sheet workbook. However you choose to display data, you get features such as a function library, grouping, sorting, filtering, and conditional formatting. Try the demo
Whether you are working in bound, unbound, or mixed mode, users will enjoy an easy click-to-edit spreadsheet authoring workflow right in the browser. Try the demo
Style and Formatting
Format cells exactly the way you wish with features such as fonts, alignment, merging, borders, and shading. Apply data type formatting, such as currency, to cells. Try the demo
Data Display, Analysis, and Visualization
Full chart support
Supported charts include column, bar, line, pie, doughnut, area, scatter, bubble, stock, and combination. Users can also import and export native Excel files with charts. Customers can interact with those charts, and developers are given the tools to add and edit charts with the Spread.Sheets Designer. See charts
Spread includes many impressive sparklines that allow you to quickly, and professionally, summarize data trends. You can even create your own custom sparkline to present virtually any type of sparkline you can imagine. Try the demo
Filter data with controls such as buttons, sliders, and checkboxes with the data slicer. Apply one to a table in a few steps or customize your own. Try the demo
Show performance indicators, icon sets, data bars, color scales, and more with conditional formatting support. Try the demo
Spreadsheet Features and Excel File Compatibility
Excel-like Data Display
Sort, filter, group, and outline data to get the view you need. Table formatting and conditional formatting are also supported. Try the demo
Give your users the spreadsheet features they expect such as drag-fill, drag move, hidden columns, hidden rows, shapes, and frozen panes. Try the demo
Optional Excel Import/Export Component
The Spread.Sheets package includes a Client-Side and optional .NET server-side Excel I/O component that imports Excel files with features, formatting, and security rules intact. This component is independent of all other features and is not required to use Spread.Sheets. Try the demo
Print and Print Preview
Visual Designer for Creating Spreadsheets, Data Views, Dashboards, and Forms
Included designer helps you design data views and forms in a familiar Excel-like interface. Use it to design new views and forms or import Excel files.
Import Excel Files
The Spread.Sheets designer application imports Excel files with features intact, so people who don't use Spread.Sheets can help design data views. This is particularly useful in involving subject matter experts in the design process.
Save your templates to JSON for easy loading into your web application.
End-User Designer for Creating Ad-hoc Spreadsheets and Views
With the new Spread.Sheets End-User Designer, you can now provide this same functionality to your end users! Data management, data visualization, forms creation, and other spreadsheet and reporting functions can now be easily embedded into your application to satisfy your desktop, web, and mobile needs… both online and offline.
Extensive Function Library and Calculation Engine
Built-in Function Library
Choose from over 460 built-in functions and apply them to individual cells, rows/columns, or entire sheets. Cross-sheet referencing is also supported. Try the demo
Custom Formula Support
Create your own formulas and add them to the libraries. Includes support for array formulas. Try the demo
Formula Text Box Control
Add an Excel-like formula text box to your sheets. Try the demo
Cell Types and Number Formatting
Special Cell Types
Use button, checkbox, combo box, and hyperlink cell types to automatically set a cell’s behavior. Try the demo
Choose from the same number cell types you see in Excel such as general, currency, accounting, date, percentage, scientific, and fraction. You can also set currency symbols, separators, and decimal places. Try the demo
Custom Cell Types
Spread.Sheets is completely extensible, so you are free to create your own cell types. Try the demo
Spread.Sheets Supports Chart Types
Comprehensive demo gallery and feature samples of Spread.Sheets with code and detailed instruction tutorials
Undo/Redo enhancement: In previous versions, undo and redo for custom commands had to be handled with multiple functions. Now the user only needs to define the "execute" function, making it much simpler
FilterDialog UI enhancement: SpreadJS now supports tree hierarchies in the filter dialog, useful for dates and outlines
More protection options have been added to the sheet, including allowDragInsertRows/Columns, allowInsertRows/Columns, and allowDeleteRows/Columns
You can now add custom icons for individual IconCriterion in a custom icon set
Diagonal line borders are now supported in cells and ranges
SpreadJS now supports vertical text in cells
Double underline: This feature is similar to the single underline support currently in SJS, but now provides a double underline option—ideal for any financial or accounting application. This also works well with the Cell Alignment, ForeColor, WordWrap, Indent, ShrinkToFit, and CellOverflow options.
462 functions now available! The functions are for use in scientific, statistical, engineering and business formulas. See all functions.
Chart support: SpreadJS now supports charting! New charts include Column, Bar, Line, Pie, Doughnut, Area, Scatter, Bubble, Stock, and CombinationWhat's New Spread.Views
Commercial OEM and SaaS Licensing
If you want to use SpreadJS to create your own commercially licensed SDK, or web application builder, choose the Commercial OEM license. Since use cases vary widely, Commercial OEM and SaaS licenses are customized for each customer.