Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.
TypeScript agentaiai-agentsall-in-onecrmcrm-systememaillinearmcpmessagingnotesnotionofficerustslackslack-alternativestartupstartup-toolstypescriptworkspace
import { useSplitPanelOrThrow } from '@components/app/split-layout/layoutUtils';
import { useBlockId } from '@core/block';
import { toast } from '@core/component/Toast/Toast';
import { blockMetadataSignal } from '@core/signal/load';
import { useBlockDocumentName } from '@core/util/currentBlockDocumentName';
import { fireAndForget } from '@core/util/fireAndForget';
import { downloadFile } from '@filesystem/download';
import { createQuery } from '@tanstack/solid-query';
import { Button } from '@ui';
import { createSignal, For, onCleanup, Show } from 'solid-js';
import { SpreadsheetSkeleton } from '../components/SpreadsheetSkeleton';
import {
prepareSpreadsheetImport,
registerSpreadsheetImport,
SPREADSHEET_IMPORT_CHUNK_CELLS,
writeSpreadsheetImportCells,
} from '../core/workbook-document';
import type { WorkbookFileData } from '../core/workbook-file-types';
import { yieldToPage } from '../core/yield-to-page';
import { createDraftActions } from '../primitives/create-draft-actions';
import { createLocalSpreadsheetSource } from '../primitives/create-local-spreadsheet-source';
import { createSpreadsheetStore } from '../primitives/create-spreadsheet-store';
import { importWorkbookFile } from '../primitives/workbook-file-client';
import { createSpreadsheetDocument } from '../queries/create-spreadsheet';
import { saveSpreadsheetDraft } from '../queries/save-spreadsheet-draft';
import { uploadedWorkbookQuery } from '../queries/uploaded-workbook';
import { spreadsheetMentions } from '../spreadsheet-mentions';
import { SpreadsheetEditor } from './SpreadsheetEditor';
/** Used by both the old /unknown URLs and CSV blocks, including channel splits. */
export default function UploadedWorkbook() {
const id = useBlockId();
const query = createQuery(() =>
uploadedWorkbookQuery(
{
id,
version: blockMetadataSignal.get()?.documentVersionId ?? 0,
fileType: blockMetadataSignal.get()?.fileType ?? '',
},
importWorkbookFile
)
);
return (
<Show
when={query.isSuccess ? query.data : undefined}
keyed
fallback={
<Show when={query.isError} fallback={<SpreadsheetSkeleton />}>
<div
class="flex size-full flex-col items-center justify-center gap-3 p-6 text-sm text-ink-muted"
role="status"
>
<span>
{query.error instanceof Error
? query.error.message
: 'Unable to open this workbook.'}
</span>
<Button
variant="ghost"
size="sm"
onClick={() =>
fireAndForget(query.refetch(), 'uploaded-workbook')
}
>
Try again
</Button>
</div>
</Show>
}
>
{(workbook) => <UploadedWorkbookImport workbook={workbook} />}
</Show>
);
}
/** Write the workbook into a local document in steps, so a large file
* leaves the page responsive, then show it. */
function UploadedWorkbookImport(props: { workbook: WorkbookFileData }) {
const source = createLocalSpreadsheetSource();
const [ready, setReady] = createSignal(false);
const [error, setError] = createSignal('');
let disposed = false;
onCleanup(() => {
disposed = true;
});
const write = async () => {
const doc = source.doc()!;
const plan = prepareSpreadsheetImport(
doc,
props.workbook.sheets,
true,
props.workbook.images
);
const formulas = await writeSpreadsheetImportCells(doc, plan, {
chunk: SPREADSHEET_IMPORT_CHUNK_CELLS,
pause: yieldToPage,
check: () => {
if (disposed) throw new Error('The preview closed.');
},
});
registerSpreadsheetImport(doc, plan, formulas);
};
write().then(
() => setReady(true),
(reason: unknown) => {
if (!disposed)
setError(
reason instanceof Error
? reason.message
: 'Unable to open this workbook.'
);
}
);
return (
<Show
when={ready()}
fallback={
<Show when={error()} fallback={<SpreadsheetSkeleton />}>
<div
class="flex size-full items-center justify-center p-6 text-sm text-ink-muted"
role="status"
>
{error()}
</div>
</Show>
}
>
<UploadedWorkbookPreview source={source} workbook={props.workbook} />
</Show>
);
}
function UploadedWorkbookPreview(props: {
source: ReturnType<typeof createLocalSpreadsheetSource>;
workbook: WorkbookFileData;
}) {
const panel = useSplitPanelOrThrow();
const name = useBlockDocumentName('Imported spreadsheet');
const source = props.source;
const store = createSpreadsheetStore({ source, canEdit: () => false });
const actions = createDraftActions({
snapshot: () => source.doc()?.export({ mode: 'snapshot' }),
context: () => ({}),
createDocument: () =>
createSpreadsheetDocument({
title: name(),
source: 'spreadsheet-upload',
}),
saveDocument: saveSpreadsheetDraft,
openChat: async () => false,
openDocument: (id) =>
panel.handle.replace({
next: { type: 'spreadsheet', id },
mergeHistory: true,
referredFrom: 'entity-actions-menu',
}),
onSaveFailure: () =>
toast.failure('Could not save spreadsheet', {
subtext: 'Your original file is unchanged. Try converting again.',
}),
});
return (
<div class="flex size-full min-h-0 flex-col">
<div class="flex shrink-0 flex-wrap items-center justify-between gap-2 border-b border-edge-muted px-3 py-2 text-xs text-ink-muted">
<span>
Uploaded workbook · Convert to edit and collaborate. The original file
stays available.
</span>
<Button
size="sm"
variant="primary"
disabled={!!actions.pending()}
onClick={() => fireAndForget(actions.edit(), 'uploaded-workbook')}
>
{actions.pending() ? 'Saving…' : 'Edit in Macro'}
</Button>
<Show when={props.workbook.warnings.length}>
<details class="w-full">
<summary>Import notes ({props.workbook.warnings.length})</summary>
<ul class="list-disc pl-5 pt-2">
<For each={props.workbook.warnings}>
{(warning) => <li>{warning}</li>}
</For>
</ul>
</details>
</Show>
</div>
<SpreadsheetEditor
mentions={spreadsheetMentions}
store={store}
name={name()}
onExportXlsx={(bytes) =>
downloadFile(
new Blob([bytes.slice().buffer], {
type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
}),
`${name()}.xlsx`
)
}
onExport={(content) =>
downloadFile(
new Blob([content], { type: 'text/csv;charset=utf-8' }),
`${name()}.csv`
)
}
/>
</div>
);
}