Why SpreadSheet

Complex features

TreeGrid SpreadSheet is a feature-rich web spreadsheet component, refined over many years and shaped by real-world enterprise projects and customer feedback.

Excel-like Editing

Excel-style in-cell editing with formulas, validation and formatting. Full copy & paste support, keyboard navigation and range selection for productivity workflows.

Modern Integration

Works seamlessly with React, Vue, Angular, Svelte and Vanilla JavaScript. Includes complete TypeScript definitions for strongly-typed development.

Flexible Data Handling

Load and save XLSX files directly in the browser, without accessing a server. Alternatively, XLSX files can be downloaded from or uploaded to a server. JSON and XML formats are also supported.

Export & Print

Export to HTML, CSV and PDF with custom styling. Print-ready layouts enable splitting and scaling across multiple pages.

Advanced Features

Copy & paste values, styles and formats. Insert and edit images. Full RTL (right-to-left) support for Middle Eastern languages.

Features and Advantages

Comprehensive capabilities for enterprise-level spread sheets

Data Management

Flexible XLSX handling

Full XLSX support - loading, opening and saving XLSX files.

Open, edit and save XLSX directly in the browser.

Optional backend upload and download of the XLSX files.

Spread sheet can be stored in XML or JSON format for lightweight text storage.

Calculations & formulas

Excel-like and JavaScript formulas

Editable formulas starting with = just like in Excel.

230 built-in formula functions compatible with Excel.

Formula source cell selection by mouse during editing, including across sheets.

Formulas with external sheet references.

User defined names for cells and cell ranges to use in formulas.

Custom formulas and expression-based calculations.

Advanced Layout

Special grid and cell structure features

Multiple sheets with add, delete, move, copy, rename.

Interactive toolbar with list of sheets / grids.

Automatic sheet sizing (row and column management).

RTL (right-to-left) display for Middle Eastern languages.

Dynamic cell styling: color, font, alignment, wrapping, rotation.

Dynamic cell borders with different width, style and color.

Dynamic cell spanning (vertical and horizontal).

Automatic cell type detection and formatting

Advanced formatting using format string.

Layout Operations

Rows & columns manipulation

Add, copy and delete rows and columns.

Resize, move and hide rows and columns.

Freeze rows and columns.

Resize sheet sections and grid.

Dynamic spanning for flexible layouts.

Multiple selection modes: row, column, cell and range.

Copy & paste rows, columns and cell ranges.

Full undo & redo support.

Cell Editing

Excel-like editing and navigation

In-cell editing with Excel-like keyboard navigation.

Single-cell or range cursor.

Multi-line editing in textarea.

Rich text editing with full formatting and styling.

Mass operations for ranges: copy, move, fill, clear.

Handles mass updates affecting formulas, values, styles, borders and spans.

Advanced Editing

Extra editing features

Auto-fill and smart fill-down operations.

Copy & paste cells and ranges from and to Excel and other spreadsheets.

Inserting images floating above cells like in Excel.

Manipulating and changing images by mouse dragging.

Fully customizable cell context menu.

Tree & Hierarchical Data

Multi-level structures and pivot tables

Excel outline to arrange rows and columns in tree.

Unlimited tree hierarchy for rows and columns.

Expand & collapse with keyboard shortcuts.

Export

Export capabilities and formats

Export to XLSX, CSV, PDF with customizable styling.

Print-ready layouts with multi-page splitting and scaling.

HTML export with full formatting preservation.

Synchronize changes via AJAX, form submits or custom API.

Integration

Framework support and compatibility

Works with React, Vue, Angular, Svelte and Vanilla JavaScript.

Full TypeScript definitions and IntelliSense support.

Responsive design with mobile and touch support

Comprehensive API and event system.

Can be used without writing custom JavaScript.

Cross-browser compatibility (Chrome, Firefox, Safari, Edge).

Salesforce LWC & CSP compatibility.

Customization & Theming

Flexible styling and customization

Full theming support with JSON customization.

Built-in themes and custom theme creation.

Animated actions in grid

Customizable toolbar and context menu options.

Customizable cell styling and formatting.

Localized to 14 languages, including all texts and date and number formats

Fully customizable key and mouse navigation action schemes

SpreadSheet Advantages to FastSheet

TreeGrid SpreadSheet features not supported by FastSheet

Choosing cell / cell ranges for formula across sheets.

Search in cells by user expression.

Cell hint showing the overflowed cell value.

Cell IDs for automated testing.

Localized to 14 languages, including all texts and date and number formats.

RTL (right-to-left) display for Middle Eastern languages.

Technical Specifications

Supported Browsers

Chrome Edge Safari Firefox Android Samsung Opera

And all Gecko and WebKit / Chromium / Blink engine clones

JavaScript Frameworks

The FastGrid package includes examples and documentation for use with JavaScript frameworks:

ReactJavaScript / TypeScript AngularTypeScript VueJavaScript / TypeScript SvelteJavaScript / TypeScript EmberJavaScript / TypeScript ExpressJavaScript SalesForce LWCJavaScript OtherHTML, JavaScript

The package can be used in any other client-side framework that supports third-party JavaScript code.

Server-Side Support

The FastGrid package includes examples and predefined server script code:

NodeJS (JavaScript) ASP.NET (C#, Visual Basic) JSP (Java) PHP HTML (other)

TreeGrid SpreadSheet can integrate with any backend returning XML or JSON.

TreeGrid SpreadSheet

Cell-based AJAX spreadsheet with full Excel compatibility

TreeGrid SpreadSheet is an Excel-compatible, browser-based spreadsheet component built as a TreeGrid extension. It displays and edits cell-based data with formulas, formatting and fast in-browser processing of XLSX files - all without requiring a server round-trip.

SpreadSheet

Why SpreadSheet

Complex features

TreeGrid SpreadSheet is a feature-rich web spreadsheet component, refined over many years and shaped by real-world enterprise projects and customer feedback.

Excel-like Editing

Excel-style in-cell editing with formulas, validation and formatting. Full copy & paste support, keyboard navigation and range selection for productivity workflows.

Modern Integration

Works seamlessly with React, Vue, Angular, Svelte and Vanilla JavaScript. Includes complete TypeScript definitions for strongly-typed development.

Flexible Data Handling

Load and save XLSX files directly in the browser, without accessing a server. Alternatively, XLSX files can be downloaded from or uploaded to a server. JSON and XML formats are also supported.

Export & Print

Export to HTML, CSV and PDF with custom styling. Print-ready layouts enable splitting and scaling across multiple pages.

Advanced Features

Copy & paste values, styles and formats. Insert and edit images. Full RTL (right-to-left) support for Middle Eastern languages.

Features and Advantages

Comprehensive capabilities for enterprise-level spread sheets

Data Management

Flexible XLSX handling

Full XLSX support - loading, opening and saving XLSX files.

Open, edit and save XLSX directly in the browser.

Optional backend upload and download of the XLSX files.

Spread sheet can be stored in XML or JSON format for lightweight text storage.

Calculations & formulas

Excel-like and JavaScript formulas

Editable formulas starting with = just like in Excel.

230 built-in formula functions compatible with Excel.

Formula source cell selection by mouse during editing, including across sheets.

Formulas with external sheet references.

User defined names for cells and cell ranges to use in formulas.

Custom formulas and expression-based calculations.

Advanced Layout

Special grid and cell structure features

Multiple sheets with add, delete, move, copy, rename.

Interactive toolbar with list of sheets / grids.

Automatic sheet sizing (row and column management).

RTL (right-to-left) display for Middle Eastern languages.

Dynamic cell styling: color, font, alignment, wrapping, rotation.

Dynamic cell borders with different width, style and color.

Dynamic cell spanning (vertical and horizontal).

Automatic cell type detection and formatting

Advanced formatting using format string.

Layout Operations

Rows & columns manipulation

Add, copy and delete rows and columns.

Resize, move and hide rows and columns.

Freeze rows and columns.

Resize sheet sections and grid.

Dynamic spanning for flexible layouts.

Multiple selection modes: row, column, cell and range.

Copy & paste rows, columns and cell ranges.

Full undo & redo support.

Cell Editing

Excel-like editing and navigation

In-cell editing with Excel-like keyboard navigation.

Single-cell or range cursor.

Multi-line editing in textarea.

Rich text editing with full formatting and styling.

Mass operations for ranges: copy, move, fill, clear.

Handles mass updates affecting formulas, values, styles, borders and spans.

Advanced Editing

Extra editing features

Auto-fill and smart fill-down operations.

Copy & paste cells and ranges from and to Excel and other spreadsheets.

Inserting images floating above cells like in Excel.

Manipulating and changing images by mouse dragging.

Fully customizable cell context menu.

Tree & Hierarchical Data

Multi-level structures and pivot tables

Excel outline to arrange rows and columns in tree.

Unlimited tree hierarchy for rows and columns.

Expand & collapse with keyboard shortcuts.

Export

Export capabilities and formats

Export to XLSX, CSV, PDF with customizable styling.

Print-ready layouts with multi-page splitting and scaling.

HTML export with full formatting preservation.

Synchronize changes via AJAX, form submits or custom API.

TreeGrid SpreadSheet is an Excel-compatible, browser-based spreadsheet component built as a TreeGrid extension.
It displays and edits cell-based data with formulas, formatting and fast in-browser processing of XLSX files - all without requiring a server round-trip.