SpreadJS is a new product derived from the Spread Product Family, which is a set of spreadsheet components for application development on a variety of platforms. SpreadJS is sure to bring value to your web applications with time-saving features.
Data Visualization and Analysis Support
Let your data tell a story through the enhanced data visualization support in SpreadJS! Recognize trends, isolate out-of-range values, and gain a picture clear understanding of your data. SpreadJS data visualization support includes: Sparklines,Conditional Formatting, Color Gradients, Excel-style Grouping, and more.
Powerful Excel compatible formula and ability to data aggregation and analysis, 320+ functions, cross sheet reference, and custom name support.
Rich data interaction, flexible data editing, Excel-style Filter, Row/Column Freeze, Row/Column Resize, and Drag-Fill and Drag-Drop.
For even richer data analysis, add sparklines: tiny lightweight charts that are drawn in cells to provide a visual representation of data. SpreadJS supports the Column, Line, and Win/Loss sparkline types.
View only the data you are interested in by filtering using the familiar Excel-style filter dialog.
Use Excel-style range grouping to logically group ranges, and nested ranges of data.
Rich Data Interaction & Display Support
Customize the look and feel of SpreadJS within your application. Data is integral to your application. The colors, borders, fonts, and table-layout elements used to layout your data should support a high level of customization. SpreadJS provides extensive customization at the row, column, and cell level. In addition, SpreadJS provides Excel-style theme support to allow you to create the presentation you desire.
Multiple Header Styling
Define any number of rows and columns for the headers. You can also fully customize the appearance of header cells, including the text, styles, spans, and height/width.
You can freeze (make non-scrolling) any number of rows, columns, or both in a sheet.
Customize the appearance of the cells by setting borders for a cell or range of cells. A border can be displayed on the left, right, top, or bottom, or around all four sides of a cell or cell range. You can specify more than one style and color for the same cell, column, row, or block of cells. Different border styles let you set different options.
SpreadJS is powered by HTML5, jQuery, and CSS3. We provide a widget, which gives you an easy way to use the control. To use SpreadJS, follow these three simple steps:
1. Add References
First, we need to reference the necessary scripts.
2. Create the Markup
Next, we add markup for the SpreadJS control to our document. We need to define this markup like so:
<div id="ss" style="width:100%;height:400px;"></div>
3. Initialize the Spreadsheet
Go Get It!
Download SpreadJS Alpha and try the online sample. We have also published some documentation for the widgets to help you get started. The docs will be updated during the Alpha process so please be patient if something is missing momentarily.
If you have any feedback or questions, please post them in the SpreadJS Alpha forum. Note that this is our first step: alpha of version 1.0 release. We'll continue to improve SpreadJS in the future. Your feedback is very important to us.