GridWeb

A reusable headless spreadsheet engine, virtualized Web Component and Excel-inspired workbook studio. JavaScript, TypeScript, .NET-style MVVM, React, workers and native WebView hosts share one core. Office-style batched APIs, authenticated coauthoring, vector printing and managed pivots are optional reusable surfaces.

Independent software, not Microsoft Excel or full Excel/Office.js/COM/VBA parity. Exact compatibility boundaries.

Open Workbook Studio · Releases and full source · API · Architecture

Install

npm install @wieslawsoltes/gridweb

import {Workbook} from '@wieslawsoltes/gridweb';
import '@wieslawsoltes/gridweb/controls';
const book = new Workbook();
book.ActiveWorksheet.GetRange('A1:B2').Values = [[10,20],[30,40]];
book.ActiveWorksheet.GetCell('C1').Formula = '=SUM(A1:B2)';
const grid = document.createElement('grid-web');
grid.style.cssText = 'display:block;height:520px';
grid.Workbook = book;
document.body.append(grid);

The root is DOM-independent. /controls registers <grid-web>; /browser includes core/control without duplicate model constructors. /react, /worker, /host, /io, /office, /printing and /collaboration expose the other surfaces. The Node service is /collaboration/server. Node 22.16+ supports synchronous require(ESM). React is an optional peer; the core has no mandatory runtime npm dependencies.

Blazor

dotnet add package GridWeb.Blazor --version 0.1.0

@using GridWeb.Blazor
<Spreadsheet @bind-Value="workbookJson" Theme="light" Style="display:block;height:520px" />
@code { private string? workbookJson; }

The .NET 8/.NET 10 package wraps the same native grid/calculation engine in WebAssembly and Interactive Server. It includes workbook/selection binding, SpreadsheetInput for EditForm, a Razor toolbar, typed range/pivot/file services, shared/nonvisual providers, native API access, streamed payloads, collaboration and worker assets. NuGet consumers need no npm/CDN or Dockyard dependency. Blazor versions and pipelines are independent of the desktop adapters below.

Blazor installation and API guide · Sample · Release notes

Engine and editor

Sparse workbooks/ranges, 356 available formula names, dependencies, arrays and LET/LAMBDA, binary lookups, distributions, matrices, complex/dated finance, A1/R1C1 translation, transactional editing/history, formatting, validation, conditional rules, tables, sorting/filtering, goal seek and regression. The Canvas editor supports native text editing, keyboard/pointer selections, clipboard/fill, resizing, merges, frozen panes, chart manipulation, zoom, themes and multiple views. The five-sheet studio uses the same engine, not separate mock data.

Calculation contracts · Core API · React example

Managed pivots

Data / Insert → Pivot reports creates a persistent report. Edit pivot reconfigures fields/filters; Refresh pivots updates it from source values; Show details opens underlying source records. Twelve aggregations, multiple measures, row/column axes, totals, history and JSON persistence are implemented.

const source = book.Worksheets.Add('Source');
source.GetRange('A1:B3').Values = [['Region','Revenue'],['North',10],['North',20]];
const output = book.Worksheets.Add('Report');
const pivot = book.PivotTables.Add('Sales', source.UsedRange, output.GetRange('A1'), {
  rows:['Region'], values:[{column:'Revenue',aggregate:'sum'}]
});
pivot.Refresh();

Supported row-axis layouts export as actual native XLSX pivot definitions, cache definitions, typed shared items and cache records. Unsupported native layouts require explicit flattening; JSON retains all managed definitions. Exports refresh a snapshot without changing the open workbook. Pivot API, native subset and C# usage.

Office-style batching and print

createExcelApi(book) from /office provides queued Excel.run, load and context.sync for implemented worksheet/range/format operations. Loaded values are snapshots; failed batches roll back atomically. View → Office API example exercises it. API and differences.

/printing exports inert SVG charts and paginated HTML including chart fragments, conditional styling/data bars, fitted A4/Letter/A3/Legal pages, repeated titles, breaks, margins and header/footer tokens. Page Layout → Advanced print and Chart SVG are working studio commands. Printing contract.

Collaboration

Share creates or joins an authenticated server room, merges disjoint content/style/comment edits, presents conflicts and reports participant selections. Pending edits survive reload in this tab’s session storage, without the token; reconnect to resume.

# Supply a securely generated GRIDWEB_COLLAB_TOKEN of at least 24 characters.
npm run build
npm run collaboration:serve
# Installed package: gridweb-collaboration

The Node CLI defaults to loopback port 8099 and serves /studio. Configure HTTPS, exact allowed origins, persistent storage and application authorization for remote access. The static Pages site does not run the service. Deployment, API, recovery and limits.

Framework and native hosts

PascalCase APIs, PropertyChanged, collection notifications, RelayCommand and disposable bindings support .NET-style JavaScript. dotnet/ contains the typed C# client and WPF/WinUI/Avalonia controls and samples embedding the same JavaScript engine. Native Windows WebView smoke tests exercise real RPC including pivot creation, refresh and drill-down. Exhaustive native input/accessibility and cross-platform qualification remain separate.

integrations/ contains Dockyard, RibbonWeb, TreeDataGridWeb, DynamicDataWeb, ReactiveWeb, RBushWeb and QuikGraphWeb adapters. CI runs actual package tests with React 18/19. The dependency-free studio works without the optional companion bundle. Bundle instructions · Native hosts.

Reference formulas and worksheet organization

Version 0.7 adds coordinate-preserving reference values: 3-D sheet spans for supported statistics and HSTACK/VSTACK, comma unions, whitespace intersections, dynamic colon ranges and reference-form INDEX. AREAS, ISREF, SHEET, SHEETS and seven A-suffixed statistics bring the inventory to 356 names. Formula copy/rename uses a shared scanner; deleted references are permanently repaired rather than reconnecting to a new sheet with the same name.

const jan = book.Worksheets.Add('Jan');
const mar = book.Worksheets.Add('Mar');
const feb = book.Worksheets.Add('Feb', book.Worksheets.Count - 1);
jan.GetCell('A1').Value = 10;
feb.GetCell('A1').Value = 20;
mar.GetCell('A1').Value = 30;
book.ActiveWorksheet.GetCell('D1').Formula = '=SUM(Jan:Mar!A1)';
book.Worksheets.Move(feb, book.Worksheets.Count - 1); // D1 changes from 60 to 40.
book.Undo(); // Worksheet order, formula dependencies and D1 = 60 are restored.

Home/Formulas → Reference tools creates a live four-sheet example. Move worksheet opens the reusable control dialog with read-only/stale-state guards. The same operation is available through the core, worker/host, Office-style worksheet.position setter and typed C# client. Reference contracts and limits.

Excel compatibility and editing tools

The feature audit inventories the implemented engine, controls, adapters and remaining Excel work. Version 0.6 adds all 12 database functions, reference-aware AGGREGATE/SUBTOTAL, MAKEARRAY, ISOMITTED and callable/recursive LAMBDA improvements. Availability inventories are generated and tested, not maintained as a parity percentage.

Reusable range APIs now include Capture, PasteSpecial, FillSeries and SpecialCells. The grid exposes Paste special, Fill series and Go to special dialogs, with transpose/arithmetic paste, anchored date series, error handling and one-step undo. Home/Data/Formulas → Calculation tools opens executable examples; the default Formula lab also contains new calculations. Editing API and explicit limits · Calculation contracts · Current qualification.

Build, test and distribute

npm ci --ignore-scripts --legacy-peer-deps
npm install --global [email protected]
npm run check
python -m pip install -r tests/requirements.txt
python -m playwright install chromium
npm run test:browser
npm run dev

Build produces modular browser files, a standalone studio, embedded host HTML and the Pages site. npm run release:pack produces tarball/source/browser archives. CI checks engine/types, installed package consumers, actual browser editing/coauthoring/pivot flows, native runtimes, companion packages and independent Open XML pivot schema validation.

Successful main CI triggers versioned npm/GitHub publication with NPM_TOKEN, provenance and exact-byte verification. Pages deploys independently. Source archives contain tracked source rather than private untracked room files. Publishing · Automatic releases · Security.

Full parity remains unfinished: exhaustive formulas and Office semantics, arbitrary lossless XLSX, complete native pivot/drawing/data-model behavior, VBA, Power Query/DAX, enterprise coauthoring and printer fidelity. No proprietary runtime/artwork/fonts are bundled. MIT licensed; notices.

Scoped names and naming tools (0.8)

Workbook and worksheet Names collections now coexist, with scope-aware rename, metadata, reference-valued LET/LAMBDA bindings and JSON/ordinary XLSX persistence. Home/Formulas → Named formulas creates a live example; Name manager, Define name and Create from selection belong to the reusable control. See the naming contract, updated feature audit and verification. Source ZIPs record, but do not embed, the independently pinned Blazor runtime in SOURCE-GITLINKS.json.