- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
-
Features
- Workbook
- Worksheet
- Rows and Columns
- Headers
- Cells
- Data Binding
- Data Manager
- TableSheet
- GanttSheet
- ReportSheet
- Data Charts
- JSON Schema with SpreadJS
- SpreadJS File Format
- Data Validation
- Conditional Formatting
- Sort
- Group
- Formulas
- What-If Analysis
- Serialization
- Keyboard Actions
- Shapes
- Floating Objects
- Barcodes
- Charts
- Sparklines
- Tables
- Pivot Table
- Slicer
- Theme
- User Management
- Culture
- AI Assistant
- SpreadJS Designer
- SpreadJS Designer VSCode Plugin
- Tutorials
- SpreadJS Designer Component
- SpreadJS Collaboration Server
- Touch Support
- Formula Reference
- Import and Export Reference
- Events
- API Documentation
- Release Notes
Data Table
Data tables provide a structured way to perform What‑If Analysis by evaluating a formula against multiple sets of input values.
Instead of manually changing input cells and recording results, a data table automatically recalculates the same formula for each supplied input combination and returns all results in a single dynamic array.
In SpreadJS, data table functionality is implemented through the SJS.TABLE function. Unlike Excel’s legacy data tables, SJS.TABLE is a standard worksheet formula that can be edited, copied, nested inside other functions, and extended beyond two input variables.
Data tables are particularly useful for:
Sensitivity analysis
Scenario comparison
Multi‑variable simulations
Exploring how changes in assumptions affect calculated outcomes
Depending on the number of input variables provided, a data table can perform:
One‑variable analysis
Two‑variable analysis
Multi‑variable analysis (beyond Excel’s traditional limit)
For detailed syntax and usage, see SJS.TABLE Function.
For rules governing input combinations and output shape, see Input and Result Rules.
For performance considerations, see Performance and Calculation.
For Excel interoperability details, see Excel Compatibility.