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.
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.
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.
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.
Print and Print Preview
Print from the Browser
Spread fully supports browsers' print and print preview features.
Customize print behavior to your specifications by coding against the print API. Try the demo.
Print or export data views to full-featured PDF files.
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.
Custom Formula Support
Create your own formulas and add them to the libraries. Includes support for array formulas.
Formula Text Box Control
Add an Excel-like formula text box to your sheets.
Cell Types and Number Formatting
Special Cell Types
Use button, checkbox, combo box, and hyperlink cell types to automatically set a cell’s behavior.
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.
Custom Cell Types
Spread.Sheets is completely extensible, so you are free to create your own cell types.
Spread.Sheets Supports Chart Types
Plug-in Architecture Helps Control Size
Drag and Fill
Formula Text Box
Standalone Data Slicer
Comprehensive demo gallery and feature samples of Spread.Sheets with code and detailed instruction tutorials
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 Combination
PDF export: You can now save Spread.Sheets workbooks to PDF format.
In-cell formula text box: Typing and editing formulas in a cell is now easier than ever. You can also create a separate text box that links to the spreadsheet, apply colors to ranges, etc.
Excel accounting format is now supported.What'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.