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.
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
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.