X Spreadsheet

x-spreadsheet is an HTML5 canvas spreadsheet component and web-based data grid designed for high-performance data display and cell manipulation. It serves as an interactive web component that allows users to manage structured data within a browser-based interface.

The project includes an XLSX file serializer that imports and exports spreadsheet state using binary XML formats compatible with Excel. It also features a locale-aware UI framework that translates interface labels and date formats through configurable language objects.

The component covers a broad range of capabilities including formula execution, cell formatting, and sheet structure manipulation. It provides tools for data integrity through input validation rules and supports batch operations such as autofilling and range copying. An external API allows for programmatic synchronization of cell data and the triggering of custom callbacks based on grid events.

Features

Spreadsheet Components - Provides an interactive web grid component supporting multiple sheets, cell merging, and layout manipulation.

Web Spreadsheet Components - Provides a comprehensive web-based spreadsheet component with grids, formatting, and formula functionality.

Grid Layout Manipulations - Allows adjusting the grid layout by inserting, deleting, hiding, or resizing rows and columns.

Grid Rendering - Utilizes an HTML5 canvas to render high-performance grids capable of handling large datasets.

Spreadsheet Formula Engines - Provides a browser-side parser for evaluating mathematical expressions and cross-cell dependencies within a workbook.

Spreadsheet Renderers - Uses an HTML5 canvas-based renderer to ensure high-performance display and manipulation of large datasets.

Cell Styling Systems - Enables styling of cell appearance via fonts, colors, borders, alignment, and text wrapping.

Data Grids - Ships an interactive tabular interface supporting real-time editing and row-column manipulation.

Browser-Based Data Processing - Implements client-side formula evaluation and data validation directly in the browser to avoid server round-trips.

Grid Event Listeners - Provides an API to trigger custom callbacks when users select or edit cells in the grid.

XLSX Export - Converts internal spreadsheet state into a binary XML format compatible with standard Excel XLSX files.

XLSX Serialization - Implements a serializer to import and export spreadsheet state using the binary XML format compatible with Excel.

Grid Range Operations - Accelerates data entry through copying, cutting, pasting, and autofilling across cell ranges.

Data Integrity - Ensures data accuracy by restricting user input through specific cell validation rules.

XLSX Portability - Supports importing and exporting data in XLSX format to ensure portability with desktop spreadsheet software.

XML Spreadsheet Parsers - Implements a serializer that converts internal data into the binary XML format used by modern Excel files.

Formula Dependency Resolution - Evaluates mathematical formulas by resolving cell dependencies through a specialized calculation engine.

State-Synchronized Bindings - Synchronizes the visual grid display with an internal data model to maintain consistent application state.

Data Entry Forms - Enables the creation of structured data entry workflows using cell merging and validation rules.

Input Validation Rules - Implements declarative rules to validate the format and length of user-entered cell data.

Cell Validation Rules - Constrains user entries by comparing cell values against predefined data integrity rules.

Programmatic Grid Data Synchronization - Allows updating cell text and retrieving values or styles via an external interface.

Tables and Spreadsheets - A web-based spreadsheet component.

myliangx-spreadsheet

Features

Star history