@memberjunction/excel-addin
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.
What it does
Section titled “What it does”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.
What’s in this package
Section titled “What’s in this package”| 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.
How sign-in works
Section titled “How sign-in works”- The pane makes a one-time RSA key pair and opens an Office dialog on its own host (
connect.html). - That page sends the dialog to Explorer’s
office/connectpage with the public key. The person signs in to Explorer as they always do and approves the connection. ExcelAddin.CreateConnectionmints 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 toconnected.htmlwith the sealed text in the URL fragment.connected.htmlhands 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.
Building
Section titled “Building”pnpm run build # tsc for the library, then tsc -p tsconfig.web.json + esbuild for the panepnpm test