index | JavaScript Spreadsheet

Common APIs

Frequently used in application development.

Class

Manage worksheets, workbook state, calculation, serialization, and application-wide behavior.

getActiveSheet fromJSON toJSON

Class

Work with cells, rows, columns, ranges, tables, formulas, and sheet-level options.

getRange getValue setValue setFormula getFormula

Interface

Configure ribbon panels and connect Designer commands to the application UI.

constructor setConfig IDesignerConfig defaultConfig toolbarModeConfig registerTemplate getCommand

Module

Evaluate formulas and create synchronous or asynchronous custom functions.

Functions Function AsyncFunction calculate evaluateFormula rangeToFormula

Method group

Load and save complete workbook state with the SJS file format.

import export open save

Method group

Pause painting, calculation, or events while applying large batches of workbook changes.

suspendPaint resumePaint suspendCalcService resumeCalcService

Class

Find event names and bind application handlers to workbook and worksheet changes.

bind unbind Designer.Events

Recently added platform capabilities.

Package family

Connect server and browser packages for real-time, multi-user workbook editing.

Server Client Workbook client

Module

Configure AI requests for formula, pivot table, translation, sentiment, and query features.

AIRequestCallback IAIConfig IAIEnvironment