Skip to main content Skip to footer

JavaScript Spreadsheet Optional Add-Ons

Transform Your JavaScript Development and User Experience

Empower your user and development projects with SpreadJS' versatile optional add-on components - PivotTable, ReportSheet, and GanttSheet. Dive into data-driven insights using PivotTable, a robust tool for quick organization and analysis, enhancing business intelligence with customizable features. Design detailed reports effortlessly with ReportSheet, offering data entry, filtering, sorting, and styling options, all within the familiar SpreadJS environment. Elevate project and resource management with GanttSheet, seamlessly integrating Gantt chart capabilities into your spreadsheets. Developers gain unparalleled flexibility, while users benefit from intuitive interfaces, customizable reports, and streamlined project workflows, ultimately enhancing productivity and decision-making processes.

JavaScript PivotTable Component

JavaScript Spreadsheet Pivot Table Component

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

Learn More View Demo
Support for Full customization of JavaScript PivotTable

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.

View Demo
JS Pivot Table Report Layout Options: Outline, Compact, Tabular

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.


Learn More View Demo
Support for Full customization of JavaScript

PivotTable Panel

Utilize the JavaScript PivotTable Panel to choose from various fields from a data source and sort/filter them as needed.



Learn More View Demo
Pivot Table Manager - create manage, and save different views for a JS PT

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.

Learn More View Demo
SpreadJS PivotTable supports slicers

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

View Demo
Support for Conditional Rules in JavaScript PivotTables

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.

View Demo

JavaScript GanttSheet Component

JavaScript Gantt Sheet Component

Provide Gantt Chart behavior in a spreadsheet user interface. This includes standard 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
Learn More View Demo
Easily bind table data to a GanttSheet JS control

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.

Learn More
Import and Export Gantt sheets from a JavaScript Application

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.

View Demo
JavaScript Gantt Chart Time Scales

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.

View Demo

JavaScript ReportSheet Component

JavaScript ReportSheet Component

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.

Learn More View Demo
JS ReportSheet Template Cell Types

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.

View Demo
Data Entry options in JavaScript Report Sheet

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.

Learn More View Demo
Set Pagination

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.

Learn More View Demo
Group, Filter, and Sort data in JavaScript Report Sheet

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.

View Demo
Support for Formula Functions within Report Sheets

Support for Formula Functions

ReportSheet uses Context when evaluating formula cells. If a formula cell has a specific context in preview mode, the formula calculation will use that context. This indicates that the same formula can produce different results depending on the context. Utilizes the full SpreadJS calculation engine.

Learn More View Demo
Import and Export Reportsheets from a JavaScript Application

Import, Export and Printing Capabilities

Print, Import and Export the SpreadJS ReportSheet to JSON, SJS, and Excel.

View Demo

Award-Winning Products and First-Class Support

Five Star Rating

"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

Five Star Rating

"Great support through evaluation process, Spread is my favorite development add-in, adds great, high value capabilities to applications!"

TRUSTED CUSTOMER

Five Star Rating

"Excellent Products. I have been using their products for around 15 years. Always there to help."

TRUSTED CUSTOMER

Component Source Awards - 2023 #2 Publisher ComponentSource TOP 50 Product 2023 Award

MESCIUS Spread is Trusted by the World's Leading Companies

Customer Logos

"Thanks for providing the best [JavaScript] spreadsheet widget in the world, we're very happy customers. Your product has saved us a TON of time relative to other solutions we used in the past."

Jan Domanski, Labstep

"We have been using Spread in our desk and web products (PerpetualBudget) for over a decade. Not only are the Spread grids great controls but the support at GrapeCity [now known as MESCIUS] is the best. When you need them, they're there!"

Jim Spicer, Spicer-Baer Associates

"I haven't come across such a feature-rich solid Spread before. Thanks for giving such a nice component."

Adavesh Managaon, MVP, Visual C#

"Spread benefits my company because our clients can now see the immediate benefit the websites we create for them provide."

Michael Stark, Owner, StarkNetwork.com