The browser-safe half of MemberJunction's Excel add-in. Its server half is
@memberjunction/excel-addin-server, and the admin guide is
guides/EXCEL_ADDIN_GUIDE.md.
Open in Excel, in MJ Explorer's views grid and query results grid, downloads a connected workbook. The workbook holds headings and no rows. Opening it in Excel opens the MemberJunction pane, the person signs in once, and every sheet fills with what that person can see. Refresh brings current data.
| Module | For |
|---|---|
contract |
The workbook format the server writes and the pane reads/updates: one data sheet per entity, saved view, or saved query, and a very-hidden MJ_Sources sheet recording each source. ParseWorkbookManifest validates it, because a workbook is user-editable. |
catalog-types |
Dependency-free catalog and source-resolution DTOs shared between the browser pane and server operations. |
operations |
The typed Remote Operations Explorer and the Excel pane call: ExcelAddin.GetStatus, ExcelAddin.CreateConnection, ExcelAddin.BuildWorkbook, ExcelAddin.GetCatalog, ExcelAddin.GetEntityViews, and ExcelAddin.ResolveSource. These bases are not registered; the server package registers their bodies. |
handoff |
The encrypted sign-in handoff between Explorer's connect page and the pane (RSA-OAEP-wrapped AES-GCM, Web Crypto only). |
client |
ExcelAddinClient: caches the add-in's status per provider and downloads a workbook. Used by the grids. |
src/web |
The pane itself, bundled with esbuild to dist/web. Plain TypeScript and Office.js, no framework. |
contract and handoff import nothing, so the pane bundle carries no MemberJunction runtime.
connect.html).office/connect page with the public key. The person
signs in to Explorer as they always do and approves the connection.ExcelAddin.CreateConnection mints an MJ API key for that person that can only run views and
queries (view:run, query:run) and expires. Explorer seals it, with Explorer's own GraphQL
address, to the pane's public key, and returns to connected.html with the sealed text in the
URL fragment.connected.html hands the sealed text to the pane, which opens it with its private key and keeps
the connection in its own storage.The key is never in a URL in plain text, can't change data, and is revocable on Explorer's API Keys page.
pnpm run build # tsc for the library, then tsc -p tsconfig.web.json + esbuild for the pane
pnpm test