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.
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.
Data Display, Analysis, and Visualization
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.
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.
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.
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.
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.
Extensive Function Library and Calculation Engine
Built-In Function Library
Choose from over 300 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.
Cell Padding and Labels
Design perfect spreadsheet form layouts with new padding and labeling properties for each cell. Cell watermarks can be displayed in the background to assist the user in filling forms quickly and easily.
Format data sets with features such as pre-defined table styles, automatic filtering, sorting, structured references, and named items.
All border design properties including thickness, color, and style are supported.
Flexible Data Binding
Bind individual cells, ranges, tables, or entire sheets to JSON data sources. Mix bound and unbound modes on the same sheet.
Don't worry about writing complex validation logic. Spread.Sheets includes data validation rules and will automatically validate based on the cell type.
Spread fully supports clipboard operations including those specific to spreadsheets such as paste all cell info or only data, formatting, or formulas.
Sorting and Filtering
Give your users Excel-like sorting and filtering features. Add sort and filter controls to a whole sheet automatically or manually column by column. Outlook-style drag and drop column filtering is also supported.
Spread includes themes from Office 2003 through 2016 and other professionally designed skins. You are also free to create your own.
Fully Documented API
Customize your applications to fit your needs with Spread.Sheets comprehensive API.
Show a tooltip that contains a content preview on the scroll bar as the user scrolls.
Spread controls honor culture settings for symbols such as currency, will render any character set, and you can localize interface strings. Double-byte characters and right-to-left layout are also supported.
Use the designer or code to insert cell comments that behave much like those you see in Excel.
Sheet and Cell Protection
Lock specific cells or entire sheets from editing.
Plug-In Architecture Helps Control Size
Spread.Sheets is so complete that it can be implemented with very little code and in just a few minutes. Follow our tutorial to implement your own Spread.Sheets instance. It only takes a few minutes. You don't even need to download anything (if you don't want to).
Download a fully functional 30-day trial to experience the power of Spread for yourself. Our expert support is here to help if you have questions.