JavaScript Spreadsheet Optional Add-Ons
Transform Your JavaScript Development and User Experience
Empower your projects with SpreadJS' add-ons: PivotTable for data analysis, ReportSheet for customizable reports, GanttSheet for project management, and DataCharts for advanced, data-bound chart visualizations. Enhance productivity with intuitive interfaces, dynamic visuals, and streamlined workflows. Elevate the experience further with the Designer Ribbon Component Add-On.
JavaScript Pivot Table Component
A JavaScript Pivot Table is a powerful data summarizing and reporting tool that allows you to organize, extract and analyze large amounts of data quickly. Improve your business intelligence by visualizing complex data, discover trends, and uncover data information that otherwise may be very difficult to answer by looking at the data itself.
SpreadJS provides an optional JavaScript PivotTable add-on to allow your users to analyze data in their JavaScript spreadsheets quickly. Work with the field and panel features to generate fast, easy-to-read reports in seconds. SpreadJS PivotTables utilize a familiar UI that users recognize, allowing you to organize and summarize data using the built-in aggregations, pivot table field lists, and calculated fields. Fully customize your application's needs and let SpreadJS PivotTables perform the complex interactive analysis for your applications.
Full PivotTable Layout Customization
Supports many different options to customize the appearance and functionality of the JavaScript PivotTable per your application's needs, including control filters, rows, columns, headers, themes, Pivot Panels, and more.
Report Layout Options
Choose from three PivotTable report layouts to change how data is displayed in the PivotTable: Compact Form, Outline Form and Tabular Form.
PivotTable Panel
Utilize the JavaScript PivotTable Panel to choose from various fields from a data source and sort/filter them as needed.
Pivot View Manager
Create, manage, and save different views for the PivotTable with the View Manager, allows users to quickly access any saved view of the pivot table at a certain point in time.
Pivot Slicers
SpreadJS's PivotTable supports slicers, which are a convenient graphical interface for the label filter. PivotTable supports the following slicers types: Pivot Table Item slicer, Pivot Table Timeline slicer
Pivot Conditional Rules
Apply, get, and remove conditional formatting rules within the PivotTable area. The conditional rules work as expected irrespective of the changes to PivotTable layout.
JavaScript Gantt Chart Sheet Component
Provide JavaScript Gantt Chart behavior in a spreadsheet user interface. This includes standard JavaScript Gantt functionality, including Timescales, Taskbars, Tasks, and Calendar capabilities just to name a few. With this being implemented within SpreadJS, GanttSheets can be added just like a normal worksheet, and as such supports standard spreadsheet functionality like sorting and Import/Export.
You can use GanttSheet for things like:
- Project Scheduling/Management
- Staff/Resource Scheduling
- Warehouse Shipment Scheduling
- Flight Lists
- Production Schedules
Binds Data to the GanttSheet
Use the existing DataManager from TableSheet to create tables that can be easily connected to a GanttSheet. The Data Manager is a powerful local data engine that sends requests to the server side, then binds the data to the GanttSheet when the data is ready.
Import and Export GanttSheet Capabilities
Supports importing SSJSON and SJS files and exporting the data to various formats, including SSJSON, SJS, and Excel (.xlsx).This facilitates interoperability with different systems, supporting the diverse tools often found in enterprise environments.
Timescales in Gantt Chart
The timescale is the column header of the gantt chart in a GanttSheet, it allows you to show smaller or greater time units. The GanttSheet chart area can be zoomed in or out, and scrolled to show more or less of the chart.
JavaScript ReportSheet Component
A new sheet type that allows your users to easily design reports, including support for data entry, pagination, data filtering, sorting, and conditional formatting. The ReportSheet add-on has two parts: ReportSheet and TemplateSheet, with the later containing various report-related settings. The data for the sheet is also connected to the DataManager implementation, and the ReportSheet has data entry APIs to interact with it. You can design reports directly in the SpreadJS Designer with full control over the report UI, which you can then export and load into a SpreadJS instance in your application. A ReportSheet license now also enables the DataCharts Add-On to be used directly within ReportSheet, enabling users to enhance their reports with dynamic, data-bound charting capabilities.
ReportSheet Template Cell Types
Template cell type is the most important option of the template cell. this option can control how to organize data. If you want to make row based report you can use the ‘List' cell type, or if you want to make a sales summary report, you need to use the ‘Group’ and 'Summary’ cell type.
Data Entry
ReportSheet supports data entry through the DataManager. You need to configure the remote info of the table in the DataManager. You also need to configure the cell that is written back to a column of a table in the data entry setting of the template sheet.
Set Pagination in Reports
Pagination feature are available in the ReportSheet add-on. Allowing customization of pagination settings in the TemplateSheet to meet diverse report layout requirements.
Group, Filter, and Sort Data
Group, Filter, and Sort data, in addition to adding calculated columns and dynamic parameters to regenerate data instead of using static values.
Support for Formula Functions
ReportSheet uses Context to evaluate formula cells, enabling the same formula to produce different results based on its preview mode context. It leverages the full SpreadJS calculation engine.
Import, Export and Printing Capabilities
Print, Import and Export the SpreadJS ReportSheet to JSON, SJS, and Excel.
Chart Support in Reports
With DataCharts directly within ReportSheets, users can deliver intuitive data visualizations for easier analysis and smarter insights.
JavaScript DataCharts Component
The DataCharts Add-On enables advanced charting capabilities, allowing users to design dynamic, data-bound charts directly linked to Data Manager. Unlike traditional Excel-style charts, DataCharts can be customized using DV options and hosted as floating objects or integrated with template cells in worksheets. This add-on provides flexibility for creating interactive visuals that adapt to data-driven layouts, offering developers and users robust tools for modern data visualization. This DataCharts add-on allows users to design and configure directly within SpreadJS, and brings powerful, real-time charting to web applications.
Bind Multiple Tables to One Chart
Bind multiple tables to a single chart for comprehensive visualizations and deeper insights from diverse data sources.
Seamless ReportSheet Integration
For ReportSheets Add-On users, the ReportSheet license allows DataChart to be used to create charts within ReportSheet, integrating seamlessly with the same Data Manager to enhance reports with dynamic charts effortlessly.
Support for Several Chart Types
The DataCharts offers bar, line, pie, scatter charts, and more, directly linked to Data Manager for real-time, interactive data visualizations.
Intuitive Data Binding Interface
Provides a user-friendly interface for effortless data binding setup, streamlining the process of connecting charts to data sources.
Intuitive UI Chart Design
Easily customize DataChart styles using the Inspector UI. Adjust chart styles, titles, data labels, and tooltips for clear, visually appealing charts.
What's New in SpreadJS v18
SpreadJS v18 is available! This release offers several great new enhancements and features to its JavaScript spreadsheet component and optional add-ons including:
- NEW! DataCharts Add-On
- Right-to-Left Document Mode and Text Direction
- Bind Tables to a Data Manager Table
- Horizontal Scrolling with Shift+Mouse Wheel
- Search Cell Comments
- ComboBox CellType Data Source Binding Support
- New Aggregation Functions (GROUPBY, PIVOTBY, and PERCENTOF)
- Support to Change a PivotTable Data Source
- Show Subtotal in Single Field
- Filter Dialog Keyboard Operations Support
- ReportSheet Chart Support - With NEW DataCharts Add-On
- Expand/Collapse All cells and dependent cells
- PREVIEW! Collaboration Add-On
- Support for Angular v18
- And Much More!
SpreadJS Media and Content
Award-Winning Products and First-Class Support
"I have been using a various form of Spread back to the COM days. Spread is the most reliable spreadsheet that retrieves and stores data, whether interacting with a database or simply an Excel file. Try it out, and you will not go back to any other control"
TRUSTED CUSTOMER
"Great support through evaluation process, Spread is my favorite development add-in, adds great, high value capabilities to applications!"
TRUSTED CUSTOMER
"Excellent Products. I have been using their products for around 15 years. Always there to help."
TRUSTED CUSTOMER
 |
 |
MESCIUS Spread is Trusted by the World's Leading Companies
