JavaScript Spreadsheet Reporting Tool | XLSX Templates and Reports | Developer Solutions

ReportSheet: Build Excel-like Spreadsheet Reports in JavaScript

ReportSheet is a powerful reporting optional SpreadJS add-on that allows your users to easily design and run reports directly in the spreadsheet.

Download SpreadJS Free Trial (V 18.2.3)

Explore Powerful JavaScript Spreadsheet Reporting Capabilities

Excel is one of the most popular tools for creating reports. ReportSheet is a JavaScript spreadsheet reporting tool that allows spreadsheet users to design and create powerful Excel-like reports that can also include data entry, pagination, data filtering, sorting, conditional formatting and many other popular reporting features.

Ultimate JavaScript Spreadsheet Reporting Solution

Effortless Excel Report Creation, Viewing, and Editing in JavaScript Web Apps

Effortless Excel-Like Report Creation

Create or allow the creation of JavaScript spreadsheet reports that feel instantly familiar to users with an Excel-like spreadsheet experience. With built-in support for worksheets, tables, charts, and formulas, your users can generate interactive, data-rich reports without relying on Microsoft Excel or other reporting software. Seamless XLSX report import and export ensures smooth integration with existing workflows, making it easy to build, collaborate, and customize spreadsheet reports and templates directly inside JS spreadsheet web applications.

Consistent Layouts & Professional Styling

Deliver polished, professional reports every time with built-in layout and styling options. Apply consistent formatting across tables, charts, and worksheets to match your brand or industry standards. Features like cell styles, themes, borders, and conditional formatting ensure the reports not only communicate data clearly but look clean and reliable—helping users trust and act on the insights presented.

Enable the Creation of Consistent Professional Reports using a JavaScript Spreadsheet Control

Create Cross Reports for Advanced Spreadsheet Data Analysis in JavaScript Web Applications

Cross Spreadsheet Reports for Advanced Analysis

Build data-rich JS spreadsheet Cross Reports to analyze data across multiple categories and dimensions. By combining cell types like Group and Summary, users can define templates that automatically organize sales, returns, or other key metrics into clear, multi-dimensional tables.

Cross reports with cross-tabulation (crosstab) and matrix report layouts make it easy to track performance, identify consumer trends, and measure growth or decline in revenue, all within a familiar spreadsheet environment. Users can also implement data entry in cross reports allowing for records to be directly updated in the web application to keep reports accurate and actionable in real time.

View Cross-Report Demos and Code

Spreadsheet Report Designer

Empower users to design and customize reports with an intuitive, Excel-like designer. Without writing a single line of code, users can drag, drop, and configure data fields, tables, charts, and formulas to create reports tailored to their needs. Developers can easily embed an optional designer ribbon toolbar into the JS spreadsheet applications, giving end users full control over layout, styling, and formatting while maintaining the flexibility and performance of a powerful spreadsheet engine.

JavaScript Spreadsheet Reporting

JavaScript Spreadsheet ReportSheet’s Template Support

TemplateSheets

Design powerful report templates directly in a spreadsheet. TemplateSheets define layout, formatting, grouping, and binding rules to dynamically generate paginated, styled reports from live data.

ReportSheet Designer

Easily create and customize dynamic spreadsheet reports with a no-code designer app or allow users by offering the Designer Component add-on toolbar.

ReportSheet Designer Documentation

ReportSheets

Dynamically generate professional JavaScript spreadsheet reports by combining data and pre-configured templates, without manually formatting every cell.

DataManager

Manage external data effortlessly with the built-in DataManager. Connect, organize, and bind data to your spreadsheet reports without complex logic.

ReportSheet Documentation

TemplateSheets

TemplateSheets serve as the foundation for building dynamic, data-driven reports in the SpreadJS ReportSheet Add-On. Acting as enhanced worksheets, TemplateSheets allow developers to easily define the layout, styles, and data-binding rules for each report. Combined with the ReportSheet and DataManager, they automate report generation across industries, such as finance, sales, operations, and more.

Configure how data spills across rows and columns, apply conditional formatting, set filters, and define grouping behaviors using flexible syntax and spreadsheet-friendly settings. Support for pagination, auto-expansion, pinning, and custom cell types (like summary and group cells) ensures reports stay structured and readable, even with complex datasets. Whether you're creating a sales dashboard or a multi-region financial report, TemplateSheets let you create reusable, professional templates with minimal effort.

ReportSheet Designer

The ReportSheet Designer experience can be accessed through the SpreadJS Desktop Designer App, free with any SpreadJS license, or further extended user capabilities with the optional Designer Ribbon Component add-on. This intuitive interface lets developers or end users create powerful ReportSheet templates without writing a single line of code. Users can import templates, bind live data, set up grouping, sorting, and pagination, and apply styling and data entry settings through a visual toolbar. Whether you’re building financial reports or operational dashboards, the Designer Ribbon enables in-app editing and templating for dynamic, fully customized spreadsheet reports, all within the familiar Excel-like interface.

ReportSheet Designer Documentation

ReportSheets

ReportSheets simplify the process of building complex, structured JS spreadsheet reports using a combination of reusable templates and dynamic data sources. By connecting a pre-configured TemplateSheet with live or static data from the DataManager, ReportSheets automatically generate clean, readable layouts with features like pagination, grouping, conditional formatting, and data entry fields.

This powerful setup ensures consistency across reports, reduces development time, and allows non-developers to maintain styling and layout directly in the SpreadJS Designer. Whether you're building financial statements, sales summaries, or operations dashboards, ReportSheets offer a flexible and scalable reporting solution for web-based spreadsheets.

DataManager

The DataManager is the engine behind data connectivity and binding in SpreadJS ReportSheet. It provides a flexible way to fetch, store, and manage data from remote sources (CRUD APIs), which can then be seamlessly integrated into templates using ReportSheet. Developers can define tables, assign column bindings, and map datasets without needing to write custom data-fetching logic. The DataManager also supports efficient searching, filtering, and parameter handling, making it ideal for working with large or dynamic datasets across a variety of business reports. Whether you're generating sales summaries or regional dashboards, DataManager keeps your data clean, connected, and ready to report.

ReportSheet Documentation

Data Entry

Enable end-user data input with full CRUD support. ReportSheet lets users add, edit, delete, and submit records directly from the spreadsheet—no backend coding required.

Formula Functions

Use formulas dynamically based on cell context. ReportSheet supports context-aware calculations, hierarchical indexes, page number formulas, and reusable aliases to streamline complex reporting logic.

Parameter

Create dynamic, filterable reports using parameters. Pass runtime values like dates, IDs, or names to regenerate reports instantly without hardcoding.

Automatically Sort Report Data | JavaScript Spreadsheet Report Builder

Data Sorting

Control the sort order of JavaScript spreadsheet report data, by column, cell, formula, or custom list. Define flexible, multi-level sort rules directly in the template.

Programmatically Filter Spreadsheet Report Data

Data Filter

Filter data directly at the template level using static values, formulas, or joined tables, no post-processing required.

Data Validation

Ensure clean, accurate input with built-in data validation rules that expand dynamically with the JavaScript .xlsx export template.

Data Entry

ReportSheet makes it easy to transform spreadsheet templates into interactive forms with full data entry support. Tightly integrated with the DataManager, ReportSheet allows developers to define how records are added, updated, and submitted to a remote data source. Built-in methods like addRecordAt, updateCellValue, deleteRecordAt, and submit handle all CRUD operations, whether triggered by the UI or programmatically. End users can enter data directly in the Preview mode or use context menu options in the Designer for common actions. Modified fields are clearly marked with a customizable “dirty” cell style, helping users track changes before submitting. This makes ReportSheet ideal for building dynamic forms like order trackers, employee reports, and sales entry sheets—without writing custom input logic.

Formula Functions

Formula Functions in in the JavaScript ReportSheet add-on offers dynamic, context-aware behavior that adapts to the layout and structure of your report. Because ReportSheet uses context (like region, group, or individual record) to calculate formulas, the same expression can return different results depending on where it's evaluated—for example, showing sales totals by region vs. by salesperson using the same formula.

You can also use hierarchical cell index formulas to retrieve structured data like values, positions, or rankings within grouped layouts. Built-in pagination functions allow you to insert the current page number or total pages directly into your report—ideal for paginated exports.

To simplify complex calculations and reduce duplication, ReportSheet also lets you define template cell aliases, making formulas more readable and easier to manage across large templates. Whether you're building financial summaries or regional rollups, ReportSheet's formula engine ensures precise, scalable results.

Parameter

The Parameter feature in ReportSheet allows you to build dynamic, interactive reports by filtering data based on runtime values. Instead of hardcoding values like date ranges or customer IDs into your filters, you can define parameters and use them across the report template to control what data is displayed.

These parameters are integrated into ReportSheet's filtering system and can be updated programmatically or through the Parameter UI in the SpreadJS Designer. This enables end users to interact with the report at runtime—adjusting values like start and end dates or choosing from dropdowns—to instantly regenerate the report with updated data.

Parameters support multiple data types (e.g., string, number, boolean, date), making them versatile for a wide range of reporting scenarios such as filtering by region, customer, or timeframe. Combined with Group Cell types and pagination, parameters give developers a powerful way to personalize reports while minimizing template duplication.

Data Sorting

The Data Sorting feature in ReportSheet gives developers full control over how data is organized within generated reports. By applying sort rules at the template level using the sortOptions property, you can sort grouped or listed data before rendering—ensuring a structured and meaningful layout.

ReportSheet supports multiple sorting strategies, including sorting by column values, by cell value, by formula results, or even by custom value lists. For example, you can prioritize certain product names or sort records by calculated year or region. Multi-level sorting is also supported, allowing you to nest rules for more complex report scenarios.

Sorting is context-aware and fully integrated with the data binding logic of TemplateSheet and DataManager. You can define sort behavior programmatically or configure it directly through the ReportSheet Designer interface, where developers and business users alike can add, reorder, or remove sort conditions using the visual properties panel.

By setting up sorting rules in the template itself, you ensure consistent output across all users and devices, without requiring post-processing or manual adjustments.

Data Filter

ReportSheet allows developers to define flexible filtering conditions within the report template itself, enabling precise control over which data is displayed in the final output. By setting up filters in the TemplateSheet, you can apply static conditions, dynamic formulas, or join logic between related tables—all before the report is rendered.

Whether you're narrowing results based on a customer ID, filtering rows with date formulas, or combining datasets via primary-foreign key relationships, ReportSheet makes it possible to embed these logic rules directly into your data-bound cells. Filtering rules are applied using the filter property and can reference static values, other cells, parameters, or even external columns in related tables.

Developers can configure these conditions programmatically or through the ReportSheet Designer. This allows for intuitive setup of complex filter chains, including support for brackets, operator precedence, and mixed rule types. Once defined, these filters streamline your reports by ensuring only relevant data is displayed; no extra logic or scripting required.

Data Validation

This JavaScript spreadsheet reporting tool brings powerful data validation capabilities directly into the report generation process. Developers can define validation rules on the TemplateSheet using the same APIs as traditional worksheets but with dynamic behavior tailored for report templates. Once the report enters Preview mode, those validation rules automatically expand and adapt to the generated content.

Whether you're enforcing number ranges, restricting input to dropdown selections, or applying conditional validations across merged datasets, these rules help prevent invalid data entry at the source. Validation messages, tooltips, and visual indicators such as red borders can all be configured to guide end users and highlight issues during interactive data entry.

Additionally, ReportSheet emits a ValidationError event when a rule is violated, giving developers the ability to track and handle validation issues programmatically. Combined with template expansion logic, validation can apply to dynamic row groups or lists, ensuring scalable integrity for any report size or structure.

ReportSheet Template Cell | Structure Spreadsheet Report Data

Template Cell Types

Structure your reports with precision using template cell types—Group, List, Summary, and Static—for flexible data layouts and advanced grouping logic.

Spill Mode

Control how data expands in JS spreadsheet reports with Spill Mode. Choose between inserting new rows or overwriting the existing layout.

Set the JS Spreadsheet Report Column and Rows Layouts

Row & Column Layouts

Choose between row or column layout to control how data flows across pages in paginated reports, perfect for optimizing space in horizontal or vertical layouts.

Pin Static Cells in JavaScript Spreadsheet Reports

Pinning

Pin static cells to prevent layout shifts caused by spilled report data, ideal for anchoring titles, labels, or headers in dynamic templates.

Conditional Formatting

Highlight important data automatically by applying conditional formatting rules in your JavaScript ReportSheet templates, perfect for emphasizing thresholds, trends, and anomalies.

Add interactive Show/Collapse Buttons to JavaScript Reports

Show/Collapse Group Buttons

Let users expand or collapse grouped rows or columns with intuitive toggle buttons, perfect for interactive, drill-down reports in JS apps.

Picture Support

Enhance reports with static image shapes—logos, charts, or icons—anchored to specific rows or columns in your template.

Template Cell Types

ReportSheet gives developers powerful control over layout and data behavior using specialized template cell types. Each type, including Group, List, Summary, and Static, is purpose-built for structuring different parts of a report. You can easily define these in code via the setTemplateCell method or configure them interactively in the SpreadJS Designer.

Use Group cells to organize data by regions, categories, or other hierarchies, and define advanced bins or formulas for custom grouping logic. List cells are ideal for row-based records, while Summary cells enable aggregation—such as totals or averages—within each group. Static cells allow fixed headers or labels that do not repeat.

With advanced options like formula-based grouping, bin-based ranges, and flags like stopIfTrue or alwaysVisible, you can design dynamic, multi-level reports that mirror real-world data analysis—without hardcoding or post-processing. These template cell types work seamlessly with other ReportSheet features like sorting, filtering, and pagination to deliver fully interactive, data-driven reports in the browser.

Spill Mode

Spill Mode in ReportSheet lets developers fine-tune how repeating data is rendered into their spreadsheet report layout. By default, ReportSheet uses Insert mode, which expands the layout by adding rows or columns as needed. But in scenarios where maintaining a fixed template layout is essential, such as dashboards, forms, or embedded components, you can switch to Overwrite mode.

In Overwrite mode, repeating values are written directly into predefined, unmerged cells without altering the surrounding structure. This is especially useful when you want to bind a list of values into a fixed table or fit report content within a constrained space. Spill Mode is configured per cell using the spillMode option and works with cells of type List.

This feature helps ensure consistent formatting while still enabling dynamic data injection, making it ideal for precise layout control in professional-grade web reports.

Row & Column Layouts

This JavaScript ReportSheet gives developers full control over how repeating data is arranged in paginated output using Row Layout and Column Layout modes. These layout settings are especially useful in Paginated Preview mode, where screen or print space optimization matters most.

With Row Layout, data spills vertically across multiple rows—ideal for forms or reports with fewer columns and many data entries. In contrast, Column Layout spills data horizontally across columns, allowing efficient use of space in reports with tall data structures and limited vertical room.

Both layouts are configured using setLayoutSetting on the template sheet and offer customization options like repeatable headers and exact ranges for the data to fill. Whether you're building invoices, labels, or sales reports, this feature helps deliver pixel-perfect output across dynamic data sets.

Pinning

When creating reports using the SpreadJS' ReportSheet add-on, dynamic data can “spill” into neighboring cells, causing unintended layout shifts. The Pinning feature helps preserve the original positioning of important static cells, like headers, labels, or timestamps, by anchoring them in place.

By setting the pin property on a template cell, you can lock it to a row, column, or both, ensuring it doesn’t get pushed aside by expanding data. For example, pinning a cell in Column mode keeps it fixed in place even when adjacent cells spill horizontally. This provides precise control over layout and is especially helpful in forms, dashboards, or printed reports where structure consistency is key.

Conditional Formatting

Conditional formatting in JavaScript spreadsheet reports lets devs dynamically apply styles to cells based on data values or logical conditions, just like Excel. By defining rules in the TemplateSheet, such as highlighting sales values below target or overdue dates in red, you can visually guide users' attention to the most critical information in a report.

Rules are added using the addCellValueRule method on the ConditionalFormats class, and formatting automatically scales with dynamic report generation. This means the styling range will expand or adjust based on the data layout, especially in repeated or extended cells. For optimal performance and interactivity, this feature is most effective in DataEntryPreview mode.

Whether you're flagging underperforming KPIs or color-coding grouped data, conditional formatting makes your reports easier to interpret at a glance.

Show/Collapse Group Buttons

Add interactive Show/Collapse buttons to ReportSheet templates so users can expand or hide sections of grouped data at runtime. By enabling the showCollapseButton property in the template cell definition, developers can introduce hierarchical navigation into reports—ideal for sales by region, department-level breakdowns, or any nested dataset.

Report authors can also configure whether grouped data is initially shown or hidden using the initialExpansionState property. This ensures reports load in a user-friendly way, minimizing visual clutter while still providing access to full detail on demand.

Use the SpreadJS API methods getCollapseState and toggleCollapseState to programmatically control the expansion state—giving developers complete flexibility for tailoring the reporting experience. This feature shines in paginated reports, tree structures, or dashboards with nested summaries.

Picture Support

Add static images like logos, charts, icons, or visual indicators directly to your TemplateSheet using the addPictureShape method. These picture shapes are positioned based on their start row and column, and retain their original size when rendered in the ReportSheet.

Images are not grouped with expanding cells but follow consistent positioning rules based on the cell’s pin value. This ensures pictures stay aligned even when nearby cells expand or spill. Ideal for embedding branded headers, product thumbnails, or visual aids, this feature lets you create reports that are both informative and visually engaging—without sacrificing layout precision.

Row Paging

Control how many data rows appear per page in JS spreadsheet reports by enabling row-based pagination—perfect for generating clean, fixed-length reports.

Paper-Size Paging

Paginate reports based on paper size for print-ready layouts with full control over page flow and title rows/columns.

Cell Paging

Control exactly where and how report cells paginate, including page breaks before or after rows and repeating content across pages.

Row Paging

Row-based pagination gives you full control over the number of data rows rendered per page in a paginated ReportSheet. By configuring the rowPagination property on the TemplateSheet, you can define how many rows appear per page (rowCountPerPage) and which cell serves as the data anchor (paginationDataCell). This is especially useful for producing print-friendly reports, paginated exports, or standardized layouts where consistency across pages matters.

Paper-Size Paging

Paper-size pagination is ideal for generating reports intended for printing or PDF export. By enabling paperSizePagination in the TemplateSheet, the JS report content is automatically split across pages based on the paper’s dimensions. You can configure fixed title rows and columns that repeat on each page, and control page order using paginationOrder (horizontal-first or vertical-first). This ensures your printed reports maintain professional formatting and readability—no matter the content length.

Cell Paging

Cell paging gives granular control over page breaks in JavaScript ReportSheet outputs. By setting properties like paginateBeforeRow, paginateAfterRow, and repeatContentWhenPaging, you can fine-tune how specific cells behave during pagination—whether to start new pages, allow content to break across pages, or repeat key data on the next page. These settings are especially useful in PaginatedPreview mode, helping you design clean, print-friendly reports without cutting off important content.

Add Data Charts to JavaScript Spreadsheet Reports

ReportSheet Data Charts

Add visualizations to JavaScript spreadsheet reports using Float or Template Cell Charts with flexible data binding and layout support.

ReportSheet Data Charts Documentation

Bind Data to Charts

Bind JS ReportSheet charts directly to table data for dynamic, data-driven visualizations that reflect real-time changes.

View Demo and Code

Filter Charts

Apply multi-parameter filters to ReportSheet charts to dynamically display the most relevant data.

View Demo and Code

ReportSheet Data Charts

Bring your JS spreadsheet reports to life by using the SpreadJS DataCharts with the ReportSheet add-on. This includes built-in visualizations that simplify analysis and improve readability. Use Float Charts for high-level summaries placed anywhere on the report, or embed Template Cell Charts that repeat alongside bound data. With direct data binding to the DataManager and support for custom styles, layouts, and pagination, ReportSheet DataCharts help developers create informative, interactive reports with ease.

ReportSheet Data Charts Documentation

Bind Data to Charts

JavaScript spreadsheet reporting supports binding charts to data tables in either the TemplateSheet or Data Manager, making it easy to create responsive and informative visualizations. Charts automatically reflect the underlying data, and their position within the ReportSheet is determined by the top-left anchor cell. Whether you're loading from JSON or building from scratch, this feature lets you deliver polished, data-connected reports with minimal setup.

View Demo and Code

Filter Charts

JavaScript ReportSheet charts can be filtered using multiple parameters, such as Region and Year, allowing end users to interactively explore specific segments of the data. By binding filters to chart inputs, developers can create customizable JS spreadsheet dashboards and reports that respond in real time to user selections. This enables more focused insights without the need to regenerate the entire report.

View Demo and Code

JavaScript Spreadsheet Designer Tool for Report Sheet Creation

Configure in Designer

Use the SpreadJS Designer Component to allow users to visually create, configure, and preview ReportSheets with no-coding.

Work with Spreadsheet Report Designer Documentation

Container

Easily organize and analyze structured data in ReportSheets by inserting a container and binding fields to rows, columns, or values; ideal for building pivot-style reports.

ReportSheet Designer Container Documentation

Wizard

Quickly generate JS reports using the ReportSheet Wizard in the SpreadJS Designer. By choosing a table, selecting columns, applying aggregations, and customizing styles in a guided setup.

ReportSheet Designer Wizard Documentation

Configure in Designer

The SpreadJS Designer provides a rich no-code interface for configuring ReportSheets Templates from start to finish. Users can import templates, bind tables from the DataManager, and drag-and-drop columns into template cells with full support for grouping, filtering, sorting, pagination, and layout customization.

The JavaScript designer ribbon toolbar offers dedicated tabs for configuring data entry, template styles, and pagination rules, plus a built-in preview mode to test and fine-tune the report before deploying. Whether you're building from scratch or customizing a pre-built template, the ReportSheet Designer streamlines every step of report creation.

Spreadsheet Report Designer Documentation

Container

The SpreadJS Designer allows users to insert a container into a ReportSheet to build dynamic, pivot-style layouts. By dragging fields into row, column, or value zones, you can automatically group and summarize data without writing code.

Containers support static labels, group labels, value labels, and flexible layout customization. Users can right-click to insert or delete containers, and all configurations are done visually via the Designer UI. Ideal for creating data summaries, cross-tab reports, or dashboard-ready templates, containers give developers and analysts the tools to structure complex datasets with ease.

ReportSheet Container Designer Documentation

Wizard

The ReportSheet Wizard streamlines report creation by guiding users through a simple setup process in the SpreadJS Designer. After selecting a table, users can customize columns, choose aggregate functions like Sum or Average, and apply color themes—all without manual configuration. If the selected table has relationships with others, the Wizard displays connected tables and allows users to expand and include related data. This feature is ideal for developers or analysts looking to rapidly prototype or generate structured reports from complex datasets with minimal effort.

ReportSheet Designer Wizard Documentation

ReportSheet Import & Export

Import and export ReportSheets in JSON, SJS, or Excel formats using SpreadJS’s built-in I/O methods, perfect for saving templates, sharing reports, or integrating with other tools.

Print Reports

Easily print reports with full pagination control using the print() method, perfect for creating polished, paper-ready versions of your ReportSheets.

ReportSheet Import & Export

ReportSheet IO in SpreadJS allows developers to seamlessly import and export reports in multiple formats including JSON, SJS, and Excel. Whether you're saving a report template, loading pre-configured designs, or exporting completed reports for sharing or printing, the SpreadJS API provides dedicated methods such as toJSON, fromJSON, save, open, export, and import for full file I/O operations. These capabilities are especially useful for creating reusable reports, distributing templates across teams, or integrating reports into enterprise workflows. Required I/O script references must be included for proper functionality.

Print Reports

The Print Report feature in this JavaScript spreadsheet control lets users generate clean, paginated printouts of JS reports, supporting all render modes, including the recommended PaginatedPreview mode for best results. Developers can control print behavior using the print method on the workbook instance, and adjust pagination via the printAllPages option. Whether printing all pages or just the current one, reports maintain layout integrity thanks to built-in scaling. Be sure to include the gc.spread.sheets.print script to enable printing functionality. Combine this with row or paper-size pagination for high-quality print layouts.

Build Your Own JavaScript Spreadsheet Report

Quick Start Guide
1. Set up the JS spreadsheet. Install via NPM and include scripts, styles, and a container:	Install NPM Packages: @mescius/spread-sheets, @mescius/spread-sheets-reportsheet-addon `<head> <script src="gc.spread.sheets.all.xx.x.x.min.js"> <script src="gc.spread.report.reportsheet.xx.x.x.min.js"> <link rel="stylesheet" href="gc.spread.sheets.xx.x.x.css"type="text/css"/> </head> ... <div id="ss"></div>`
2. Initialize the JavaScript spreadsheet Workbook & add a Data Table.	`const spread = new GC.Spread.Sheets.Workbook('ss'); const ordersTable = spread.dataManager().addTable('Orders', { remote: { read: { url: 'https://demodata.mescius.io/northwind/api/v1/orders' } } });`
3. Create a TemplateSheet.	Create TemplateSheet's either programmatically with TemplateSheet class or using the code-free Spreadsheet Designer.
4. Add a report worksheet & get the template sheet.	`ordersTable.fetch().then(() => { const reportSheet = spread.addSheetTab(0, 'report1', GC.Spread.Sheets.SheetType.reportSheet); const templateSheet = reportSheet.getTemplate(); });`
5. Set the data to the template sheet.	['orderId','customerId','orderDate','freight','shipName','shipCity','shipCountry'] .forEach((c, i) => { templateSheet.setValue(0, i, c[0].toUpperCase() + c.substring(1)); templateSheet.setTemplateCell(1, i, { type: 'List', binding: `Orders[${c}]` }); });

Learn more with our interactive online demos or documentation.

Easy Licensing & Distribution

After Purchasing Users Generate ReportSheet Enabled SpreadJS Distribution Key/s for Application/s Through Their MESCIUS Account.

Licensing FAQs

The ReportSheet add-on is enabled through a SpreadJS distribution key. SpreadJS is licensed per developer and deployed hostname, with deployment licenses varying by commercial or non-commercial use.

Learn More About Optional Add-On Licensing.

Request a ReportSheet Enabled Trial Key

Our sales team can provide a 30-day ReportSheet Add-on enabled trial key upon request, allowing you to deploy SpreadJS and the optional ReportSheet add-on during your trial period.

Contact Our Sales Team

Have Questions? We're Here to Help

Email us.sales@mescius.com to schedule a call with our product specialists or request a personalized demo through support to discuss your project needs.

Contact Support

SpreadJS Media and Content

New SpreadJS Addons: ReportSheet and GanttSheet

Introducing Real-Time Collaboration in JavaScript Spreadsheets

New AI Features in JavaScript Spreadsheets: Natural Language and Smart Analysis

How to Add a JavaScript Spreadsheet Ribbon Component in Your Web App

How to Use Pivot Tables with SpreadJS

View All Blogs

New SpreadJS Real-Time Spreadsheet Collaboration in JavaScript Web Apps

Elevate JavaScript Spreadsheets with Designer Ribbon, PivotTable, GanttSheet & ReportSheet

New SpreadJS AI Add-On Features in JavaScript Spreadsheets

How to License SpreadJS in Your Web Application

View All Videos

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

ComponentSource Award 2024 Top 50 Product

Customer reviews provided by Feefo

Trusted by the World's Leading Companies

"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