Integrate Unsiloed with Microsoft Excel

import { defineConfig } from "vite";
import devCerts from "office-addin-dev-certs";

export default defineConfig(async ({ command }) => {
  if (command !== "serve") return {};

  return {
    server: {
      host: "localhost",
      port: 3000,
      strictPort: true,
      https: await devCerts.getHttpsServerOptions(),
      proxy: {
        "/unsiloed-usage": {
          target: "https://platformbackend.unsiloed.ai",
          changeOrigin: true,
          rewrite: () => "/api/v1/org/get_usage",
        },
      },
    },
  };
});

<!doctype html>
<html lang="en">
<head>
  <meta charset="UTF-8" />
  <meta name="viewport" content="width=device-width, initial-scale=1" />
  <title>Unsiloed Connection</title>
  <script src="https://appsforoffice.microsoft.com/lib/1/hosted/office.js"></script>
</head>
<body>
  <h1>Connect to Unsiloed</h1>
  <form id="form">
    <label for="api-key">Unsiloed API key</label>
    <input id="api-key" type="password" autocomplete="off" required />
    <button id="check" type="submit" disabled>Check connection</button>
  </form>
  <p id="status" role="status">Open this page as an Excel add-in.</p>

  <script type="module">
    const form = document.querySelector("#form");
    const keyInput = document.querySelector("#api-key");
    const button = document.querySelector("#check");
    const status = document.querySelector("#status");

    Office.onReady((info) => {
      if (info.host === Office.HostType.Excel) {
        button.disabled = false;
        status.textContent = "Enter your API key to check the connection.";
      }
    });

    form.addEventListener("submit", async (event) => {
      event.preventDefault();
      button.disabled = true;
      status.textContent = "Checking connection…";

      try {
        const response = await fetch("/unsiloed-usage", {
          headers: { "api-key": keyInput.value.trim() },
          signal: AbortSignal.timeout(15000),
        });
        if (!response.ok) {
          const hint = response.status === 401 ? " Check your API key." : "";
          throw new Error(`Connection failed (HTTP ${response.status}).${hint}`);
        }
        const usage = await response.json();
        if (typeof usage.org_name !== "string") {
          throw new Error("Unsiloed returned no organization name.");
        }
        const name = /^[=+\-@]/.test(usage.org_name)
          ? "'" + usage.org_name
          : usage.org_name;

        await Excel.run(async (context) => {
          const sheet = context.workbook.worksheets.add();
          const range = sheet.getRange("A1:B1");
          sheet.getRange("B1").numberFormat = [["@"]];
          range.values = [["Unsiloed organization", name]];
          range.format.autofitColumns();
          sheet.activate();
          await context.sync();
        });
        status.textContent = `Connected to ${usage.org_name}. Added a worksheet.`;
      } catch (error) {
        status.textContent = error.name === "TimeoutError"
          ? "Unsiloed didn't respond within 15 seconds. Try again."
          : error.message;
      } finally {
        button.disabled = false;
      }
    });
  </script>
</body>
</html>

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<OfficeApp xmlns="http://schemas.microsoft.com/office/appforoffice/1.1"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:type="TaskPaneApp">
  <Id>4e796815-b704-4a27-87a0-8358602112e7</Id>
  <Version>1.0.0.0</Version>
  <ProviderName>Unsiloed AI</ProviderName>
  <DefaultLocale>en-US</DefaultLocale>
  <DisplayName DefaultValue="Unsiloed Connection" />
  <Description DefaultValue="Check the Unsiloed connection from Excel." />
  <IconUrl DefaultValue="https://www.unsiloed.ai/docs/logo/dark.png" />
  <SupportUrl DefaultValue="https://www.unsiloed.ai/docs" />
  <Hosts>
    <Host Name="Workbook" />
  </Hosts>
  <DefaultSettings>
    <SourceLocation DefaultValue="https://localhost:3000/index.html" />
  </DefaultSettings>
  <Permissions>ReadWriteDocument</Permissions>
</OfficeApp>