TypeScript
"use client"
import * as React from "react"
import dynamic from "next/dynamic"
import { withUiBasePath } from "@/lib/zone-path"
import { Button } from "@/components/ui/button"
import { Spinner } from "@/components/ui/spinner"
import {
DocsSourceCodeBlock,
DocsViewCodeBlock,
} from "@/components/docs-code-block"
const SAMPLE_XLSX_URL = withUiBasePath("/samples/crazy-chart-zoo.xlsx")
function ViewerPreviewLoading() {
return (
<div className="grid h-[640px] place-items-center bg-background">
<Spinner className="size-4" />
</div>
)
}
const XlsxViewerPreview = dynamic(
() =>
import("@/components/extend/xlsx-viewer").then(
(mod) => mod.XlsxViewerPreview
),
{
ssr: false,
loading: () => <ViewerPreviewLoading />,
}
)
export function XlsxViewerDemo() {
const [isDark, setIsDark] = React.useState(false)
return (
<div
data-slot="component-preview"
className="group relative mt-4 mb-12 flex flex-col overflow-hidden rounded-xl border"
>
<XlsxViewerPreview
src={SAMPLE_XLSX_URL}
isDark={isDark}
onIsDarkChange={setIsDark}
/>
<DocsViewCodeBlock code={xlsxViewerUsageCode} />
</div>
)
}
const xlsxViewerUsageCode = `"use client";
import * as React from "react";
import { XlsxViewerPreview } from "@/components/extend/xlsx-viewer";
export function XlsxViewerExample() {
const [isDark, setIsDark] = React.useState(false);
return (
<XlsxViewerPreview
src="/path/to/workbook.xlsx"
isDark={isDark}
onIsDarkChange={setIsDark}
/>
);
}`
const xlsxViewerSourceCode =
'"use client"\n\nimport * as React from "react"\nimport {\n useXlsxViewer,\n useXlsxViewerController,\n useXlsxViewerThumbnails,\n useXlsxViewerZoom,\n XlsxViewer,\n XlsxViewerProvider,\n type XlsxCellAddress,\n type XlsxContextMenuRenderProps,\n type XlsxScrollerRenderProps,\n type XlsxSheetData,\n type XlsxTableHeaderMenuRenderProps,\n type XlsxViewerController,\n} from "@extend-ai/react-xlsx"\nimport { createPortal } from "react-dom"\n\nimport { cn } from "@/lib/utils"\nimport { Button } from "@/components/ui/button"\nimport {\n ContextMenuSeparator,\n ContextMenuShortcut,\n} from "@/components/ui/context-menu"\nimport {\n DropdownMenu,\n DropdownMenuCheckboxItem,\n DropdownMenuContent,\n DropdownMenuItem,\n DropdownMenuRadioGroup,\n DropdownMenuRadioItem,\n DropdownMenuSeparator,\n DropdownMenuTrigger,\n} from "@/components/ui/dropdown-menu"\nimport { Input } from "@/components/ui/input"\nimport {\n Popover,\n PopoverContent,\n PopoverTrigger,\n} from "@/components/ui/popover"\nimport { ScrollArea } from "@/components/ui/scroll-area"\nimport {\n Select,\n SelectContent,\n SelectItem,\n SelectTrigger,\n SelectValue,\n} from "@/components/ui/select"\nimport { Separator } from "@/components/ui/separator"\nimport { Spinner } from "@/components/ui/spinner"\nimport { Tabs, TabsList, TabsTrigger } from "@/components/ui/tabs"\nimport {\n Tooltip,\n TooltipContent,\n TooltipProvider,\n TooltipTrigger,\n} from "@/components/ui/tooltip"\nimport { IconPlaceholder } from "@/components/icon-placeholder"\n\nexport const XLSX_CONTEXT_MENU_CLASS_NAME =\n "origin-(--transform-origin) rounded-lg border bg-popover text-popover-foreground shadow-lg/5 outline-none not-dark:bg-clip-padding before:pointer-events-none before:absolute before:inset-0 before:rounded-[calc(var(--radius-lg)-1px)] before:shadow-[0_1px_--theme(--color-black/4%)] dark:before:shadow-[0_-1px_--theme(--color-white/6%)]"\n\nexport const xlsxContextMenuStyle = {\n background: "var(--popover)",\n border: "1px solid var(--border)",\n borderRadius: "var(--radius-lg, var(--radius))",\n boxShadow: "var(--tw-shadow)",\n color: "var(--popover-foreground)",\n font: "inherit",\n minWidth: "min(14rem, calc(100vw - 16px))",\n padding: 0,\n} satisfies NonNullable<\n React.ComponentProps<typeof XlsxViewer>["contextMenuStyle"]\n>\n\nexport function renderXlsxContextMenu({\n actions,\n runAction,\n busy,\n}: XlsxContextMenuRenderProps) {\n return (\n <div className="p-1">\n {actions.map((action, index) => (\n <React.Fragment key={action.id}>\n {action.separatorBefore && index > 0 ? (\n <ContextMenuSeparator />\n ) : null}\n <button\n type="button"\n role="menuitem"\n tabIndex={-1}\n disabled={busy || action.disabled}\n data-action={action.id}\n className={cn(\n "flex min-h-8 w-full cursor-default items-center gap-2 rounded-sm px-2 py-1 text-left text-base text-foreground outline-none select-none hover:bg-accent hover:text-accent-foreground focus:bg-accent focus:text-accent-foreground disabled:pointer-events-none disabled:opacity-64 sm:min-h-7 sm:text-sm",\n action.destructive && "text-destructive-foreground"\n )}\n onPointerMove={(event) =>\n event.currentTarget.focus({ preventScroll: true })\n }\n onClick={(event) => {\n event.currentTarget\n .closest<HTMLElement>(\'[role="menu"]\')\n ?.focus({ preventScroll: true })\n void runAction(action.id)\n }}\n >\n {action.label}\n {action.shortcut ? (\n <ContextMenuShortcut>{action.shortcut}</ContextMenuShortcut>\n ) : null}\n </button>\n </React.Fragment>\n ))}\n </div>\n )\n}\n\nconst XLSX_LOADING_INDICATOR_DELAY_MS = 300\nconst XLSX_DROPDOWN_Z_INDEX_CLASS = "z-40"\nconst XLSX_SEARCH_BATCH_ROW_COUNT = 500\nconst XLSX_SEARCH_DEBOUNCE_MS = 300\nconst XLSX_GRID_HEADER_HEIGHT = 24\nconst XLSX_GRID_ROW_HEADER_WIDTH = 40\nconst XLSX_MAX_FILE_SIZE_BYTES = 50 * 1024 * 1024\nconst ZOOM_OPTIONS = [10, 25, 50, 75, 100, 125, 150, 175, 200, 400] as const\n\n// Stable reference so the thumbnails memo isn\'t invalidated on every render\n// (e.g. by selection changes), which would recompute every sheet thumbnail.\nconst XLSX_SHEET_TAB_THUMBNAIL_OPTIONS = {\n resolution: {\n maxHeight: 360,\n maxWidth: 560,\n },\n} as const\n\ntype UploadedWorkbook = {\n buffer: ArrayBuffer\n fileName: string\n identity: string\n}\n\ntype XlsxSearchResult = {\n cell: XlsxCellAddress\n displayValue: string\n formula?: string\n sheetIndex: number\n sheetName: string\n workbookSheetIndex: number\n}\n\ntype XlsxBatchCell = {\n col?: unknown\n formula?: unknown\n value?: unknown\n}\n\ntype XlsxBatchRow = {\n cells?: unknown\n index?: unknown\n}\n\nfunction formatWorkbookName(fileName: string | undefined, url: string) {\n if (fileName?.trim()) return fileName\n\n const pathname = url.split("?")[0] ?? ""\n const rawName = pathname.split("/").pop() ?? "workbook.xlsx"\n\n try {\n return decodeURIComponent(rawName)\n } catch {\n return rawName\n }\n}\n\nfunction ensureWorkbookExtension(fileName: string) {\n const lowerFileName = fileName.toLowerCase()\n return lowerFileName.endsWith(".xlsx") || lowerFileName.endsWith(".xls")\n ? fileName\n : `${fileName}.xlsx`\n}\n\nfunction downloadWorkbookBuffer(buffer: ArrayBuffer, fileName: string) {\n const resolvedFileName = ensureWorkbookExtension(fileName)\n const blob = new Blob([buffer], {\n type: resolvedFileName.toLowerCase().endsWith(".xls")\n ? "application/vnd.ms-excel"\n : "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",\n })\n const url = URL.createObjectURL(blob)\n const anchor = document.createElement("a")\n\n anchor.href = url\n anchor.download = resolvedFileName\n anchor.rel = "noopener"\n document.body.append(anchor)\n anchor.click()\n anchor.remove()\n window.setTimeout(() => URL.revokeObjectURL(url), 0)\n}\n\nfunction normalizeSearchText(value: unknown) {\n return typeof value === "string"\n ? value\n : value === null || value === undefined\n ? ""\n : String(value)\n}\n\nfunction cellValueToSearchText(value: unknown) {\n if (!value || typeof value !== "object") return normalizeSearchText(value)\n\n const record = value as {\n asBoolean?: () => boolean | null\n asError?: () => string | null\n asNumber?: () => number | null\n asText?: () => string | null\n is_boolean?: boolean\n is_empty?: boolean\n is_error?: boolean\n is_number?: boolean\n is_text?: boolean\n }\n\n if (record.is_empty) return ""\n if (record.is_error) return record.asError?.() ?? ""\n if (record.is_text) return record.asText?.() ?? ""\n if (record.is_number) return normalizeSearchText(record.asNumber?.())\n if (record.is_boolean) return record.asBoolean?.() ? "TRUE" : "FALSE"\n\n return normalizeSearchText(value)\n}\n\nfunction getCellSearchText(\n controller: XlsxViewerController,\n sheet: XlsxSheetData,\n row: number,\n col: number\n) {\n const worksheet = controller.workbook?.getSheet(sheet.workbookSheetIndex)\n if (!worksheet) return { displayValue: "", formula: "" }\n\n const formula = worksheet.getFormulaAt(row, col) ?? ""\n const cachedFormulaValue = formula\n ? sheet.cachedFormulaValues[cellAddressToA1({ row, col })]\n : undefined\n const formatted = worksheet.getFormattedValueAt(row, col)\n\n if (\n formatted &&\n !(formula && cachedFormulaValue !== undefined && formatted.startsWith("#"))\n ) {\n return { displayValue: formatted, formula }\n }\n\n const calculated = worksheet.getCalculatedValueAt(row, col)\n const displayValue =\n formula && cachedFormulaValue !== undefined && calculated.is_error\n ? cachedFormulaValue\n : cellValueToSearchText(calculated)\n\n return { displayValue, formula }\n}\n\nfunction getBatchRows(rows: unknown): XlsxBatchRow[] {\n return Array.isArray(rows) ? (rows as XlsxBatchRow[]) : []\n}\n\nfunction getBatchCells(row: XlsxBatchRow): XlsxBatchCell[] {\n return Array.isArray(row.cells) ? (row.cells as XlsxBatchCell[]) : []\n}\n\nfunction cellMatchesQuery(\n displayValue: string,\n formula: string,\n query: string\n) {\n return (\n displayValue.toLowerCase().includes(query) ||\n formula.toLowerCase().includes(query)\n )\n}\n\nfunction cellAddressToA1({ col, row }: XlsxCellAddress) {\n let columnNumber = col + 1\n let columnName = ""\n\n while (columnNumber > 0) {\n const remainder = (columnNumber - 1) % 26\n columnName = String.fromCharCode(65 + remainder) + columnName\n columnNumber = Math.floor((columnNumber - 1) / 26)\n }\n\n return `${columnName}${row + 1}`\n}\n\nasync function findXlsxSearchResults(\n controller: XlsxViewerController,\n rawQuery: string\n) {\n const query = rawQuery.trim().toLowerCase()\n if (!query) return []\n\n const results: XlsxSearchResult[] = []\n\n for (const [sheetIndex, sheet] of controller.sheets.entries()) {\n const startRow = Math.max(0, sheet.minUsedRow)\n const endRow = Math.max(startRow, sheet.maxUsedRow)\n const visibleCols = sheet.visibleCols.filter(\n (col) => col >= sheet.minUsedCol && col <= sheet.maxUsedCol\n )\n const visibleRowSet = new Set(sheet.visibleRows)\n const visibleColSet = new Set(visibleCols)\n\n if (!visibleCols.length || sheet.maxUsedRow < sheet.minUsedRow) continue\n\n const worksheet = controller.workbook?.getSheet(sheet.workbookSheetIndex)\n const worksheetWithBatch = worksheet as\n | {\n getRowsBatch?: (\n startRow: number,\n rowCount: number,\n options?: Record<string, unknown>\n ) => unknown\n }\n | undefined\n\n for (\n let batchStartRow = startRow;\n batchStartRow <= endRow;\n batchStartRow += XLSX_SEARCH_BATCH_ROW_COUNT\n ) {\n const rowCount = Math.min(\n XLSX_SEARCH_BATCH_ROW_COUNT,\n endRow - batchStartRow + 1\n )\n const rows = controller.getRowsBatchAsync\n ? await controller.getRowsBatchAsync(\n sheet.workbookSheetIndex,\n batchStartRow,\n rowCount\n )\n : worksheetWithBatch?.getRowsBatch?.(batchStartRow, rowCount, {\n includeFormulas: true,\n useFormattedValues: true,\n })\n\n if (rows) {\n for (const rowEntry of getBatchRows(rows)) {\n const row = Number(rowEntry.index)\n if (!Number.isInteger(row) || !visibleRowSet.has(row)) {\n continue\n }\n\n for (const cellEntry of getBatchCells(rowEntry)) {\n const col = Number(cellEntry.col)\n if (!Number.isInteger(col) || !visibleColSet.has(col)) continue\n\n const displayValue = normalizeSearchText(cellEntry.value)\n const formula = normalizeSearchText(cellEntry.formula)\n\n if (!cellMatchesQuery(displayValue, formula, query)) continue\n\n results.push({\n cell: { row, col },\n displayValue,\n formula,\n sheetIndex,\n sheetName: sheet.name,\n workbookSheetIndex: sheet.workbookSheetIndex,\n })\n }\n }\n continue\n }\n\n if (!worksheet) continue\n\n const batchEndRow = batchStartRow + rowCount - 1\n for (const row of sheet.visibleRows) {\n if (row < batchStartRow || row > batchEndRow) continue\n\n for (const col of visibleCols) {\n const { displayValue, formula } = getCellSearchText(\n controller,\n sheet,\n row,\n col\n )\n\n if (!cellMatchesQuery(displayValue, formula, query)) continue\n\n results.push({\n cell: { row, col },\n displayValue,\n formula,\n sheetIndex,\n sheetName: sheet.name,\n workbookSheetIndex: sheet.workbookSheetIndex,\n })\n }\n }\n }\n }\n\n return results\n}\n\nfunction sumAxisBefore(values: number[], endIndex: number, zoomFactor: number) {\n let total = 0\n for (let index = 0; index < endIndex; index += 1) {\n total += (values[index] ?? 0) * zoomFactor\n }\n return total\n}\n\nfunction scrollXlsxCellIntoView({\n controller,\n result,\n viewport,\n}: {\n controller: XlsxViewerController\n result: XlsxSearchResult\n viewport: HTMLDivElement | null\n}) {\n if (!viewport) return\n\n const sheet = controller.sheets[result.sheetIndex]\n if (!sheet) return\n\n const rowIndex = sheet.visibleRows.indexOf(result.cell.row)\n const colIndex = sheet.visibleCols.indexOf(result.cell.col)\n if (rowIndex < 0 || colIndex < 0) return\n\n const zoomFactor = Math.max(0.1, controller.zoomScale / 100)\n const headerHeight = XLSX_GRID_HEADER_HEIGHT * zoomFactor\n const rowHeaderWidth = XLSX_GRID_ROW_HEADER_WIDTH * zoomFactor\n const rowStart =\n headerHeight + sumAxisBefore(sheet.rowHeights, rowIndex, zoomFactor)\n const colStart =\n rowHeaderWidth + sumAxisBefore(sheet.colWidths, colIndex, zoomFactor)\n const rowHeight =\n (sheet.rowHeights[rowIndex] ?? sheet.defaultRowHeightPx) * zoomFactor\n const colWidth =\n (sheet.colWidths[colIndex] ?? sheet.defaultColWidthPx) * zoomFactor\n const rowEnd = rowStart + rowHeight\n const colEnd = colStart + colWidth\n let nextTop = viewport.scrollTop\n let nextLeft = viewport.scrollLeft\n const visibleTop = viewport.scrollTop + headerHeight\n const visibleLeft = viewport.scrollLeft + rowHeaderWidth\n const visibleBottom = viewport.scrollTop + viewport.clientHeight\n const visibleRight = viewport.scrollLeft + viewport.clientWidth\n\n if (rowStart < visibleTop) {\n nextTop = rowStart - headerHeight\n } else if (rowEnd > visibleBottom) {\n nextTop = rowEnd - viewport.clientHeight\n }\n\n if (colStart < visibleLeft) {\n nextLeft = colStart - rowHeaderWidth\n } else if (colEnd > visibleRight) {\n nextLeft = colEnd - viewport.clientWidth\n }\n\n viewport.scrollTo({\n left: Math.max(0, nextLeft),\n top: Math.max(0, nextTop),\n behavior: "auto",\n })\n}\n\nfunction useDelayedLoadingIndicator(isLoading: boolean, delayMs: number) {\n const [showSpinner, setShowSpinner] = React.useState(false)\n const [previousIsLoading, setPreviousIsLoading] = React.useState(isLoading)\n\n if (previousIsLoading !== isLoading) {\n setPreviousIsLoading(isLoading)\n setShowSpinner(false)\n }\n\n React.useEffect(() => {\n if (!isLoading) return\n\n const timeoutId = window.setTimeout(() => {\n setShowSpinner(true)\n }, delayMs)\n\n return () => window.clearTimeout(timeoutId)\n }, [delayMs, isLoading])\n\n return isLoading && showSpinner\n}\n\nfunction ToolbarTooltip({\n label,\n children,\n}: {\n label: string\n children: React.ReactNode\n}) {\n return (\n <Tooltip>\n <TooltipTrigger asChild>\n <span className="inline-flex">{children}</span>\n </TooltipTrigger>\n <TooltipContent side="bottom">{label}</TooltipContent>\n </Tooltip>\n )\n}\n\nfunction ViewerLoadingSurface({\n showSpinner = true,\n}: {\n showSpinner?: boolean\n}) {\n return (\n <div className="grid h-full min-h-52 w-full min-w-full place-items-center bg-transparent">\n {showSpinner ? <Spinner className="size-4" /> : null}\n </div>\n )\n}\n\nfunction WorkbookFileActionsMenu({\n isDark,\n onDownload,\n onIsDarkChange,\n onUploadClick,\n showDownloadButton,\n showNightRenderToggle = false,\n showUploadButton,\n}: {\n isDark?: boolean\n onDownload?: () => void\n onIsDarkChange?: (checked: boolean) => void\n onUploadClick: () => void\n showDownloadButton: boolean\n showNightRenderToggle?: boolean\n showUploadButton: boolean\n}) {\n const showThemeControl = showNightRenderToggle && Boolean(onIsDarkChange)\n const showFileActions = (showDownloadButton && onDownload) || showUploadButton\n if (!showThemeControl && !showFileActions) return null\n\n return (\n <DropdownMenu>\n <DropdownMenuTrigger asChild>\n <Button\n type="button"\n variant="ghost"\n size="icon-sm"\n aria-label="Open workbook actions"\n >\n <IconPlaceholder\n lucide="Ellipsis"\n tabler="IconDots"\n hugeicons="MoreHorizontalIcon"\n phosphor="DotsThreeIcon"\n remixicon="RiMoreLine"\n className="size-4"\n />\n </Button>\n </DropdownMenuTrigger>\n <DropdownMenuContent\n align="end"\n className={cn("w-52", XLSX_DROPDOWN_Z_INDEX_CLASS)}\n >\n {showThemeControl ? (\n <>\n <DropdownMenuCheckboxItem\n checked={Boolean(isDark)}\n variant="switch"\n onCheckedChange={(checked) => onIsDarkChange?.(checked === true)}\n >\n <span className="flex min-w-0 items-center gap-2">\n <IconPlaceholder\n lucide="Moon"\n tabler="IconMoon"\n hugeicons="Moon02Icon"\n phosphor="MoonIcon"\n remixicon="RiMoonLine"\n className="size-4"\n />\n Dark mode\n </span>\n </DropdownMenuCheckboxItem>\n {showFileActions ? <DropdownMenuSeparator /> : null}\n </>\n ) : null}\n {showDownloadButton && onDownload ? (\n <DropdownMenuItem onClick={onDownload}>\n <IconPlaceholder\n lucide="Download"\n tabler="IconDownload"\n hugeicons="Download01Icon"\n phosphor="DownloadSimpleIcon"\n remixicon="RiDownload2Line"\n className="size-4"\n />\n Download\n </DropdownMenuItem>\n ) : null}\n {showUploadButton ? (\n <DropdownMenuItem onClick={onUploadClick}>\n <IconPlaceholder\n lucide="Upload"\n tabler="IconUpload"\n hugeicons="Upload01Icon"\n phosphor="UploadSimpleIcon"\n remixicon="RiUpload2Line"\n className="size-4"\n />\n Upload\n </DropdownMenuItem>\n ) : null}\n </DropdownMenuContent>\n </DropdownMenu>\n )\n}\n\nexport function renderXlsxScroller({\n children,\n viewportProps,\n}: XlsxScrollerRenderProps) {\n return (\n <ScrollArea\n className="h-full min-h-0 w-full min-w-0 flex-1"\n viewportProps={viewportProps}\n >\n {children}\n </ScrollArea>\n )\n}\n\nexport function WorkbookTableHeaderMenu({\n direction,\n sortAscending,\n sortDescending,\n triggerIcon,\n triggerProps,\n}: XlsxTableHeaderMenuRenderProps) {\n const [open, setOpen] = React.useState(false)\n\n return (\n <DropdownMenu open={open} onOpenChange={setOpen}>\n <DropdownMenuTrigger asChild>\n <Button\n {...triggerProps}\n type="button"\n variant="ghost"\n size="icon-sm"\n className={cn("size-6 rounded-sm", triggerProps.className)}\n aria-label="Column menu"\n >\n {triggerIcon ? (\n triggerIcon\n ) : (\n <IconPlaceholder\n lucide="Ellipsis"\n tabler="IconDots"\n hugeicons="MoreHorizontalIcon"\n phosphor="DotsThreeIcon"\n remixicon="RiMoreLine"\n className="size-3.5"\n />\n )}\n </Button>\n </DropdownMenuTrigger>\n <DropdownMenuContent\n align="end"\n className={cn("w-40", XLSX_DROPDOWN_Z_INDEX_CLASS)}\n >\n <DropdownMenuRadioGroup\n value={direction ?? ""}\n onValueChange={(value) => {\n if (value === "ascending") {\n sortAscending()\n } else {\n sortDescending()\n }\n setOpen(false)\n }}\n >\n <DropdownMenuRadioItem value="ascending">\n Sort ascending\n </DropdownMenuRadioItem>\n <DropdownMenuRadioItem value="descending">\n Sort descending\n </DropdownMenuRadioItem>\n </DropdownMenuRadioGroup>\n </DropdownMenuContent>\n </DropdownMenu>\n )\n}\n\nfunction WorkbookSearchPopover({\n viewportRef,\n}: {\n viewportRef: React.RefObject<HTMLDivElement | null>\n}) {\n const controller = useXlsxViewer()\n const [searchDraft, setSearchDraft] = React.useState("")\n const [searchQuery, setSearchQuery] = React.useState("")\n const [searchResults, setSearchResults] = React.useState<XlsxSearchResult[]>(\n []\n )\n const [activeResultIndex, setActiveResultIndex] = React.useState(0)\n const [isSearching, setIsSearching] = React.useState(false)\n const controllerRef = React.useRef(controller)\n const searchRequestIdRef = React.useRef(0)\n const appliedResultKeyRef = React.useRef("")\n const activeResult = searchResults[activeResultIndex] ?? null\n const activeResultKey = activeResult\n ? `${activeResult.workbookSheetIndex}:${activeResult.cell.row}:${activeResult.cell.col}`\n : ""\n const controlsDisabled =\n controller.isLoading ||\n Boolean(controller.error) ||\n !controller.sheets.length\n const hasActiveQuery = Boolean(searchQuery.trim())\n const resultLabel = isSearching\n ? "Searching"\n : !hasActiveQuery\n ? "No search"\n : searchResults.length\n ? `${activeResultIndex + 1} / ${searchResults.length}`\n : "No results"\n\n React.useEffect(() => {\n controllerRef.current = controller\n }, [controller])\n\n const runSearch = React.useCallback((rawQuery: string) => {\n const nextQuery = rawQuery.trim()\n const requestId = searchRequestIdRef.current + 1\n searchRequestIdRef.current = requestId\n appliedResultKeyRef.current = ""\n setSearchQuery(nextQuery)\n setActiveResultIndex(0)\n\n if (!nextQuery) {\n setSearchResults([])\n setIsSearching(false)\n return\n }\n\n setIsSearching(true)\n void findXlsxSearchResults(controllerRef.current, nextQuery)\n .then((nextResults) => {\n if (searchRequestIdRef.current !== requestId) return\n setSearchResults(nextResults)\n })\n .catch(() => {\n if (searchRequestIdRef.current !== requestId) return\n setSearchResults([])\n })\n .finally(() => {\n if (searchRequestIdRef.current !== requestId) return\n setIsSearching(false)\n })\n }, [])\n\n React.useEffect(() => {\n if (!searchDraft.trim()) return\n\n const timeoutId = window.setTimeout(() => {\n runSearch(searchDraft)\n }, XLSX_SEARCH_DEBOUNCE_MS)\n\n return () => window.clearTimeout(timeoutId)\n }, [runSearch, searchDraft])\n\n const handleSearchDraftChange = (nextDraft: string) => {\n searchRequestIdRef.current += 1\n setSearchDraft(nextDraft)\n if (!nextDraft.trim()) {\n runSearch("")\n return\n }\n setIsSearching(true)\n }\n\n const clearSearch = React.useCallback(() => {\n searchRequestIdRef.current += 1\n setSearchDraft("")\n setSearchQuery("")\n setSearchResults([])\n setActiveResultIndex(0)\n setIsSearching(false)\n appliedResultKeyRef.current = ""\n controller.clearSelection()\n }, [controller])\n\n const goToRelativeResult = React.useCallback(\n (direction: 1 | -1) => {\n if (!searchResults.length) return\n\n setActiveResultIndex((currentIndex) => {\n return (\n (currentIndex + direction + searchResults.length) %\n searchResults.length\n )\n })\n },\n [searchResults.length]\n )\n\n React.useEffect(() => {\n return () => {\n searchRequestIdRef.current += 1\n }\n }, [])\n\n React.useEffect(() => {\n if (!activeResult) return\n\n if (controller.activeSheetIndex !== activeResult.sheetIndex) {\n appliedResultKeyRef.current = ""\n controller.setActiveSheetIndex(activeResult.sheetIndex)\n return\n }\n\n if (appliedResultKeyRef.current === activeResultKey) return\n appliedResultKeyRef.current = activeResultKey\n controller.selectCell(activeResult.cell)\n\n const frame = window.requestAnimationFrame(() => {\n scrollXlsxCellIntoView({\n controller,\n result: activeResult,\n viewport: viewportRef.current,\n })\n })\n\n return () => window.cancelAnimationFrame(frame)\n }, [\n activeResult,\n activeResultKey,\n controller,\n controller.activeSheetIndex,\n viewportRef,\n ])\n\n return (\n <Popover>\n <ToolbarTooltip label="Search workbook">\n <PopoverTrigger asChild>\n <Button\n type="button"\n variant="ghost"\n size="icon-sm"\n aria-label="Search workbook"\n disabled={controlsDisabled}\n >\n <IconPlaceholder\n lucide="Search"\n tabler="IconSearch"\n hugeicons="Search01Icon"\n phosphor="MagnifyingGlassIcon"\n remixicon="RiSearchLine"\n className="size-4"\n />\n </Button>\n </PopoverTrigger>\n </ToolbarTooltip>\n <PopoverContent align="end" className="w-72">\n <div className="space-y-3">\n <Input\n placeholder="Search workbook"\n value={searchDraft}\n onChange={(event) => handleSearchDraftChange(event.target.value)}\n onKeyDown={(event) => {\n if (event.key !== "Enter") return\n\n event.preventDefault()\n if (event.shiftKey && searchResults.length) {\n goToRelativeResult(-1)\n } else if (searchResults.length) {\n goToRelativeResult(1)\n } else if (searchDraft.trim()) {\n runSearch(searchDraft)\n }\n }}\n />\n <div className="flex items-center justify-between gap-2">\n <div className="min-w-0 text-xs text-muted-foreground">\n <div className="truncate">\n {searchResults.length ? (\n <>\n <span className="text-primary">\n {activeResultIndex + 1}\n </span>\n {` / ${searchResults.length}`}\n </>\n ) : (\n resultLabel\n )}\n </div>\n {activeResult ? (\n <div className="mt-0.5 truncate">\n {activeResult.sheetName}!{cellAddressToA1(activeResult.cell)}\n </div>\n ) : null}\n </div>\n <div className="flex shrink-0 items-center gap-1">\n <Button\n type="button"\n variant="outline"\n size="icon-sm"\n aria-label="Previous result"\n disabled={isSearching || searchResults.length === 0}\n onClick={() => goToRelativeResult(-1)}\n >\n <IconPlaceholder\n lucide="ChevronLeft"\n tabler="IconChevronLeft"\n hugeicons="ArrowLeft01Icon"\n phosphor="CaretLeftIcon"\n remixicon="RiArrowLeftSLine"\n className="size-4"\n />\n </Button>\n <Button\n type="button"\n variant="outline"\n size="icon-sm"\n aria-label="Next result"\n disabled={isSearching || searchResults.length === 0}\n onClick={() => goToRelativeResult(1)}\n >\n <IconPlaceholder\n lucide="ArrowRight"\n tabler="IconArrowRight"\n hugeicons="ArrowRight01Icon"\n phosphor="ArrowRightIcon"\n remixicon="RiArrowRightLine"\n className="size-4"\n />\n </Button>\n </div>\n </div>\n <div className="flex justify-end">\n <Button\n type="button"\n variant="outline"\n size="sm"\n onClick={clearSearch}\n >\n Clear\n </Button>\n </div>\n </div>\n </PopoverContent>\n </Popover>\n )\n}\n\nfunction WorkbookToolbar({\n isDark,\n onDownload,\n onIsDarkChange,\n onUploadClick,\n showDownloadButton = true,\n showNightRenderToggle,\n showUploadButton = true,\n toolbarActions,\n viewportRef,\n workbookIdentity,\n}: {\n isDark: boolean\n onDownload?: () => void\n onIsDarkChange: (checked: boolean) => void\n onUploadClick: () => void\n showDownloadButton?: boolean\n showNightRenderToggle: boolean\n showUploadButton?: boolean\n toolbarActions?: React.ReactNode\n viewportRef: React.RefObject<HTMLDivElement | null>\n workbookIdentity: string\n}) {\n const { canZoomIn, canZoomOut, setZoomScale, zoomIn, zoomOut, zoomScale } =\n useXlsxViewerZoom()\n const currentZoom = Math.round(zoomScale)\n\n React.useEffect(() => {\n setZoomScale(100)\n }, [setZoomScale, workbookIdentity])\n\n return (\n <div className="flex min-h-12 flex-wrap items-center justify-end gap-2 border-b bg-background px-3 py-2">\n <TooltipProvider>\n <div className="ml-auto flex min-w-0 flex-wrap items-center justify-end gap-1">\n <div className="flex flex-none items-center gap-1">\n <ToolbarTooltip label="Zoom out">\n <Button\n type="button"\n variant="ghost"\n size="icon-sm"\n disabled={!canZoomOut}\n aria-label="Zoom out"\n onClick={zoomOut}\n >\n <IconPlaceholder\n lucide="CircleMinus"\n tabler="IconCircleMinus"\n hugeicons="MinusSignCircleIcon"\n phosphor="MinusCircleIcon"\n remixicon="RiIndeterminateCircleLine"\n className="size-4"\n />\n </Button>\n </ToolbarTooltip>\n <Select\n value={currentZoom.toString()}\n onValueChange={(value) => setZoomScale(Number(value))}\n modal={false}\n >\n <SelectTrigger\n size="sm"\n className="w-[84px] min-w-[84px]"\n aria-label="Zoom level"\n >\n <SelectValue>{currentZoom}%</SelectValue>\n </SelectTrigger>\n <SelectContent\n align="end"\n alignItemWithTrigger={false}\n className={XLSX_DROPDOWN_Z_INDEX_CLASS}\n >\n {ZOOM_OPTIONS.map((value) => (\n <SelectItem key={value} value={value.toString()}>\n {value}%\n </SelectItem>\n ))}\n </SelectContent>\n </Select>\n <ToolbarTooltip label="Zoom in">\n <Button\n type="button"\n variant="ghost"\n size="icon-sm"\n disabled={!canZoomIn}\n aria-label="Zoom in"\n onClick={zoomIn}\n >\n <IconPlaceholder\n lucide="CirclePlusIcon"\n tabler="IconCirclePlusFilled"\n hugeicons="PlusSignCircleIcon"\n phosphor="PlusCircleIcon"\n remixicon="RiAddCircleFill"\n className="size-4"\n />\n </Button>\n </ToolbarTooltip>\n </div>\n <Separator orientation="vertical" className="mx-1 h-4 self-center" />\n <WorkbookSearchPopover\n key={workbookIdentity}\n viewportRef={viewportRef}\n />\n {toolbarActions ? (\n <>\n <Separator\n orientation="vertical"\n className="mx-1 h-4 self-center"\n />\n {toolbarActions}\n </>\n ) : null}\n {(showDownloadButton && onDownload) ||\n showUploadButton ||\n showNightRenderToggle ? (\n <>\n <Separator\n orientation="vertical"\n className="mx-1 h-4 self-center"\n />\n <WorkbookFileActionsMenu\n isDark={isDark}\n onDownload={onDownload}\n onIsDarkChange={onIsDarkChange}\n onUploadClick={onUploadClick}\n showDownloadButton={showDownloadButton}\n showNightRenderToggle={showNightRenderToggle}\n showUploadButton={showUploadButton}\n />\n </>\n ) : null}\n </div>\n </TooltipProvider>\n </div>\n )\n}\n\nfunction WorkbookStandaloneToolbar({\n onUploadClick,\n showUploadButton = true,\n toolbarActions,\n}: {\n onUploadClick: () => void\n showUploadButton?: boolean\n toolbarActions?: React.ReactNode\n}) {\n return (\n <div className="flex min-h-12 flex-wrap items-center justify-end gap-2 border-b bg-background px-3 py-2">\n <TooltipProvider>\n <div className="ml-auto flex min-w-0 flex-wrap items-center justify-end gap-1">\n {toolbarActions ? <>{toolbarActions}</> : null}\n {showUploadButton ? (\n <>\n {toolbarActions ? (\n <Separator\n orientation="vertical"\n className="mx-1 h-4 self-center"\n />\n ) : null}\n <WorkbookFileActionsMenu\n onUploadClick={onUploadClick}\n showDownloadButton={false}\n showUploadButton={showUploadButton}\n />\n </>\n ) : null}\n </div>\n </TooltipProvider>\n </div>\n )\n}\n\ntype WorkbookSheetTab = {\n name: string\n workbookSheetIndex: number\n}\n\ntype WorkbookSheetTabsInnerProps = {\n activeSheetIndex: number\n onActiveSheetIndexChange: (index: number) => void\n sheets: WorkbookSheetTab[]\n}\n\nexport function WorkbookSheetTabs({\n workbookIdentity,\n}: {\n workbookIdentity: string\n}) {\n const { activeSheetIndex, setActiveSheetIndex, sheets } = useXlsxViewer()\n\n const handleActiveSheetIndexChange = React.useCallback(\n (index: number) => setActiveSheetIndex(index),\n [setActiveSheetIndex]\n )\n\n return (\n <WorkbookSheetTabsInner\n key={workbookIdentity}\n activeSheetIndex={activeSheetIndex}\n onActiveSheetIndexChange={handleActiveSheetIndexChange}\n sheets={sheets}\n />\n )\n}\n\nconst WorkbookSheetTabsInner = React.memo(function WorkbookSheetTabsInner({\n activeSheetIndex,\n onActiveSheetIndexChange,\n sheets,\n}: WorkbookSheetTabsInnerProps) {\n const [visiblePreviewIndex, setVisiblePreviewIndex] = React.useState<\n number | null\n >(null)\n const [previewPosition, setPreviewPosition] = React.useState({\n left: 0,\n top: 0,\n })\n const { thumbnails } = useXlsxViewerThumbnails(\n XLSX_SHEET_TAB_THUMBNAIL_OPTIONS\n )\n const [thumbnailUrls, setThumbnailUrls] = React.useState<\n Record<number, string>\n >({})\n const scrollRef = React.useRef<HTMLDivElement | null>(null)\n const itemRefs = React.useRef<Record<number, HTMLButtonElement | null>>({})\n const openTimeoutRef = React.useRef<ReturnType<typeof setTimeout> | null>(\n null\n )\n const closeTimeoutRef = React.useRef<ReturnType<typeof setTimeout> | null>(\n null\n )\n const previewWidth = 220\n const previewHeight = (previewWidth * 7) / 11\n const previewGap = 12\n const previewOpenDelayMs = 500\n\n const clearOpenTimeout = React.useCallback(() => {\n if (openTimeoutRef.current) {\n clearTimeout(openTimeoutRef.current)\n openTimeoutRef.current = null\n }\n }, [])\n\n const clearCloseTimeout = React.useCallback(() => {\n if (closeTimeoutRef.current) {\n clearTimeout(closeTimeoutRef.current)\n closeTimeoutRef.current = null\n }\n }, [])\n\n const getPreviewPosition = React.useCallback(\n (sheetIndex: number) => {\n const item = itemRefs.current[sheetIndex]\n if (!item || typeof window === "undefined") {\n return { left: 0, top: 0 }\n }\n\n const itemRect = item.getBoundingClientRect()\n const centeredLeft = itemRect.left + itemRect.width / 2 - previewWidth / 2\n const minLeft = 8\n const maxLeft = Math.max(minLeft, window.innerWidth - previewWidth - 8)\n const left = Math.max(minLeft, Math.min(centeredLeft, maxLeft))\n const top = Math.max(8, itemRect.top - previewHeight - previewGap)\n\n return { left, top }\n },\n [previewHeight]\n )\n\n const updatePreviewPosition = React.useCallback(\n (sheetIndex: number) => {\n setPreviewPosition(getPreviewPosition(sheetIndex))\n },\n [getPreviewPosition]\n )\n\n const handleItemEnter = React.useCallback(\n (sheetIndex: number) => {\n clearCloseTimeout()\n const nextPreviewPosition = getPreviewPosition(sheetIndex)\n\n if (visiblePreviewIndex !== null) {\n clearOpenTimeout()\n setPreviewPosition(nextPreviewPosition)\n setVisiblePreviewIndex(sheetIndex)\n return\n }\n\n clearOpenTimeout()\n openTimeoutRef.current = setTimeout(() => {\n setPreviewPosition(nextPreviewPosition)\n setVisiblePreviewIndex(sheetIndex)\n }, previewOpenDelayMs)\n },\n [\n clearCloseTimeout,\n clearOpenTimeout,\n getPreviewPosition,\n visiblePreviewIndex,\n ]\n )\n\n const handleContainerLeave = React.useCallback(() => {\n clearOpenTimeout()\n clearCloseTimeout()\n closeTimeoutRef.current = setTimeout(() => {\n setVisiblePreviewIndex(null)\n }, 80)\n }, [clearCloseTimeout, clearOpenTimeout])\n\n React.useEffect(() => {\n return () => {\n clearOpenTimeout()\n clearCloseTimeout()\n }\n }, [clearCloseTimeout, clearOpenTimeout])\n\n React.useEffect(() => {\n thumbnails.forEach((thumbnail) => {\n setThumbnailUrls((current) => {\n if (current[thumbnail.sheetIndex]) return current\n\n const canvas = document.createElement("canvas")\n canvas.width = thumbnail.width\n canvas.height = thumbnail.height\n\n if (!thumbnail.paint(canvas)) return current\n\n return {\n ...current,\n [thumbnail.sheetIndex]: canvas.toDataURL("image/png"),\n }\n })\n })\n }, [thumbnails])\n\n React.useEffect(() => {\n if (visiblePreviewIndex === null) return\n\n const handleReposition = () => updatePreviewPosition(visiblePreviewIndex)\n handleReposition()\n\n const scrollElement = scrollRef.current\n window.addEventListener("resize", handleReposition)\n scrollElement?.addEventListener("scroll", handleReposition, {\n passive: true,\n })\n\n return () => {\n window.removeEventListener("resize", handleReposition)\n scrollElement?.removeEventListener("scroll", handleReposition)\n }\n }, [updatePreviewPosition, visiblePreviewIndex])\n\n // The preview card portals to document.body, so it outlives the tab\n // strip\'s own visibility: when the viewer is hidden or reparented under\n // the cursor (keep-alive preview pools, a closing dialog) no mouseleave\n // fires and the card would hang on screen. While the preview is open,\n // poll the strip\'s effective visibility and dismiss as soon as it stops\n // being shown.\n React.useEffect(() => {\n if (visiblePreviewIndex === null) return\n\n const dismissWhenHidden = () => {\n const element = scrollRef.current\n const isVisible = Boolean(\n element?.isConnected &&\n (element.checkVisibility?.({ checkVisibilityCSS: true }) ?? true)\n )\n\n if (isVisible) return\n clearOpenTimeout()\n clearCloseTimeout()\n setVisiblePreviewIndex(null)\n }\n const interval = setInterval(dismissWhenHidden, 200)\n\n return () => clearInterval(interval)\n }, [clearCloseTimeout, clearOpenTimeout, visiblePreviewIndex])\n\n if (sheets.length <= 1) return null\n\n const previewSheet =\n visiblePreviewIndex === null ? null : sheets[visiblePreviewIndex]\n const previewUrl =\n visiblePreviewIndex === null\n ? null\n : (thumbnailUrls[visiblePreviewIndex] ?? null)\n\n return (\n <div\n className="border-t bg-muted/40 px-3 py-2"\n onMouseLeave={handleContainerLeave}\n >\n <Tabs\n value={String(activeSheetIndex)}\n onValueChange={(value) => onActiveSheetIndexChange(Number(value))}\n className="gap-0"\n >\n <ScrollArea\n orientation="horizontal"\n scrollbarGutter\n className="h-10 w-full has-[[data-slot=scroll-area-viewport][data-has-overflow-x]]:h-[50px]"\n viewportClassName="overflow-y-hidden"\n viewportRef={scrollRef}\n >\n <div className="flex h-full items-center">\n <TabsList className="shrink-0">\n {sheets.map((sheet, index) => (\n <TabsTrigger\n key={`${sheet.workbookSheetIndex}-${sheet.name}`}\n ref={(node) => {\n itemRefs.current[index] = node\n }}\n value={String(index)}\n className="max-w-48 flex-none"\n onMouseEnter={() => handleItemEnter(index)}\n >\n <span className="truncate">{sheet.name}</span>\n </TabsTrigger>\n ))}\n </TabsList>\n </div>\n </ScrollArea>\n </Tabs>\n {typeof document !== "undefined" &&\n previewSheet &&\n visiblePreviewIndex !== null &&\n previewUrl\n ? createPortal(\n <div\n className="pointer-events-none fixed z-40 translate-y-0 overflow-hidden rounded-lg border bg-background/95 opacity-100 shadow-xl backdrop-blur-md transition-[opacity,transform] duration-100"\n style={{\n left: previewPosition.left,\n top: previewPosition.top,\n width: previewWidth,\n }}\n >\n <div className="relative aspect-[11/7] w-full overflow-hidden bg-muted/60">\n {/* eslint-disable-next-line @next/next/no-img-element -- Workbook sheet previews are generated runtime image URLs. */}\n <img\n key={`${visiblePreviewIndex}-${previewUrl}`}\n src={previewUrl}\n alt={`${previewSheet.name} preview`}\n className="absolute inset-0 h-full w-full object-cover object-left-top"\n />\n </div>\n </div>,\n document.body\n )\n : null}\n </div>\n )\n})\n\nexport function XlsxWorkbookSurface({\n className,\n isDark,\n onDownload,\n onIsDarkChange,\n onUploadClick,\n renderTableHeaderMenu,\n showDownloadButton = true,\n showNightRenderToggle,\n showToolbar = true,\n showUploadButton = true,\n toolbarActions,\n workbookIdentity,\n}: {\n className?: string\n isDark: boolean\n onDownload?: () => void\n onIsDarkChange: (checked: boolean) => void\n onUploadClick: () => void\n renderTableHeaderMenu: (\n props: XlsxTableHeaderMenuRenderProps\n ) => React.ReactNode\n showDownloadButton?: boolean\n showNightRenderToggle: boolean\n showToolbar?: boolean\n showUploadButton?: boolean\n toolbarActions?: React.ReactNode\n workbookIdentity: string\n}) {\n const { error } = useXlsxViewer()\n const viewportRef = React.useRef<HTMLDivElement | null>(null)\n const renderSearchableScroller = React.useCallback(\n ({ children, viewportProps }: XlsxScrollerRenderProps) => (\n <ScrollArea\n className="h-full min-h-0 w-full min-w-0 flex-1"\n viewportProps={viewportProps}\n viewportRef={viewportRef}\n >\n {children}\n </ScrollArea>\n ),\n []\n )\n\n return (\n <div\n className={cn(\n "flex h-[640px] min-h-0 flex-col overflow-hidden bg-background",\n className\n )}\n >\n {showToolbar ? (\n <WorkbookToolbar\n isDark={isDark}\n onDownload={onDownload}\n onIsDarkChange={onIsDarkChange}\n onUploadClick={onUploadClick}\n showDownloadButton={showDownloadButton}\n showNightRenderToggle={showNightRenderToggle}\n showUploadButton={showUploadButton}\n toolbarActions={toolbarActions}\n viewportRef={viewportRef}\n workbookIdentity={workbookIdentity}\n />\n ) : null}\n <div className="flex min-h-0 flex-1 flex-col">\n <div className="min-h-0 flex-1 bg-muted/20">\n <XlsxViewer\n experimentalCanvas\n allowResizeInReadOnly\n className="h-full min-h-0 min-w-0"\n height="100%"\n isDark={isDark}\n readOnly\n rounded={false}\n showDefaultToolbar={false}\n showImages\n fileTooLargeState={\n <div className="grid h-full w-full min-w-full place-items-center p-6">\n <div className="max-w-sm rounded-lg border bg-background p-4 text-sm">\n <p className="font-medium">File too large</p>\n <p className="mt-1 text-muted-foreground">\n This workbook exceeds the display limit. Download it to view\n the full file.\n </p>\n </div>\n </div>\n }\n loadingState={<ViewerLoadingSurface />}\n renderScroller={renderSearchableScroller}\n errorState={\n <div className="grid h-full w-full min-w-full place-items-center p-6 text-sm text-destructive">\n {error?.message ?? "Unable to display workbook."}\n </div>\n }\n contextMenuClassName={XLSX_CONTEXT_MENU_CLASS_NAME}\n contextMenuStyle={xlsxContextMenuStyle}\n renderContextMenu={renderXlsxContextMenu}\n renderTableHeaderMenu={renderTableHeaderMenu}\n />\n </div>\n <WorkbookSheetTabs workbookIdentity={workbookIdentity} />\n </div>\n </div>\n )\n}\n\nexport function XlsxViewerPreview({\n className,\n fileName,\n isDark,\n onIsDarkChange,\n showDownload = true,\n showToolbar = true,\n showUpload = true,\n src,\n toolbarActions,\n}: {\n className?: string\n fileName?: string\n isDark: boolean\n onIsDarkChange: (isDark: boolean) => void\n showDownload?: boolean\n showToolbar?: boolean\n showUpload?: boolean\n src?: string\n toolbarActions?: React.ReactNode\n}) {\n return (\n <XlsxViewerContent\n key={src}\n className={className}\n effectiveIsDark={isDark}\n fileName={fileName}\n setNightRenderEnabled={onIsDarkChange}\n shouldRenderNightMode\n showDownload={showDownload}\n showToolbar={showToolbar}\n showUpload={showUpload}\n toolbarActions={toolbarActions}\n url={src}\n />\n )\n}\n\nfunction XlsxViewerContent({\n className,\n effectiveIsDark,\n fileName,\n setNightRenderEnabled,\n shouldRenderNightMode,\n showDownload,\n showToolbar = true,\n showUpload,\n toolbarActions,\n url,\n}: {\n className?: string\n effectiveIsDark: boolean\n fileName?: string\n setNightRenderEnabled: (checked: boolean) => void\n shouldRenderNightMode: boolean\n showDownload: boolean\n showToolbar?: boolean\n showUpload: boolean\n toolbarActions?: React.ReactNode\n url?: string\n}) {\n const fileInputRef = React.useRef<HTMLInputElement>(null)\n const [uploadedWorkbook, setUploadedWorkbook] =\n React.useState<UploadedWorkbook | null>(null)\n const sourceFileName = React.useMemo(\n () =>\n url ? formatWorkbookName(fileName, url) : (fileName ?? "workbook.xlsx"),\n [fileName, url]\n )\n const displayFileName = React.useMemo(\n () => uploadedWorkbook?.fileName ?? sourceFileName,\n [sourceFileName, uploadedWorkbook?.fileName]\n )\n const workbookIdentity = React.useMemo(\n () => uploadedWorkbook?.identity ?? `${url ?? "empty"}::${displayFileName}`,\n [displayFileName, uploadedWorkbook?.identity, url]\n )\n const [workbookBuffer, setWorkbookBuffer] =\n React.useState<ArrayBuffer | null>(null)\n const [loadError, setLoadError] = React.useState<string>()\n const shouldShowLoadingSpinner = useDelayedLoadingIndicator(\n !workbookBuffer && !loadError && !uploadedWorkbook,\n XLSX_LOADING_INDICATOR_DELAY_MS\n )\n\n React.useEffect(() => {\n let isCurrent = true\n\n async function loadWorkbook(): Promise<void> {\n if (!url) return\n\n try {\n const response = await fetch(url)\n if (!response.ok) {\n throw new Error(`Failed to fetch XLSX (${response.status})`)\n }\n\n const nextWorkbookBuffer = await response.arrayBuffer()\n if (!isCurrent) return\n\n setWorkbookBuffer(nextWorkbookBuffer)\n } catch (error) {\n if (!isCurrent) return\n\n setLoadError(\n error instanceof Error ? error.message : "Unknown XLSX load error"\n )\n }\n }\n\n void loadWorkbook()\n\n return () => {\n isCurrent = false\n }\n }, [url])\n\n async function handleUpload(event: React.ChangeEvent<HTMLInputElement>) {\n const file = event.target.files?.[0]\n event.target.value = ""\n\n if (!file) return\n\n const buffer = await file.arrayBuffer()\n setLoadError(undefined)\n setUploadedWorkbook({\n buffer,\n fileName: file.name,\n identity: `${file.name}-${file.size}-${file.lastModified}`,\n })\n }\n\n const activeBuffer = uploadedWorkbook?.buffer ?? workbookBuffer\n const activeFileName = uploadedWorkbook?.fileName ?? displayFileName\n const activeIdentity = workbookIdentity\n\n if (!url && !uploadedWorkbook) {\n return (\n <div\n className={cn(\n "flex h-[640px] min-h-0 flex-col overflow-hidden bg-background",\n className\n )}\n >\n <input\n ref={fileInputRef}\n type="file"\n accept=".xlsx,.xls,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.ms-excel"\n className="hidden"\n onChange={handleUpload}\n />\n <WorkbookStandaloneToolbar\n onUploadClick={() => fileInputRef.current?.click()}\n showUploadButton={showUpload}\n toolbarActions={toolbarActions}\n />\n <div className="grid min-h-0 flex-1 place-items-center bg-muted/30 p-4">\n <div className="max-w-md rounded-lg border bg-background p-4 text-center text-sm shadow-xs">\n <p className="font-medium">Upload a workbook to preview</p>\n <p className="mt-1 text-muted-foreground">\n Pass an XLSX URL with the <code>src</code> prop or upload a file.\n </p>\n <Button\n type="button"\n variant="outline"\n size="sm"\n className="mt-4"\n onClick={() => fileInputRef.current?.click()}\n >\n <IconPlaceholder\n lucide="Upload"\n tabler="IconUpload"\n hugeicons="Upload01Icon"\n phosphor="UploadSimpleIcon"\n remixicon="RiUpload2Line"\n className="size-4"\n />\n Upload XLSX\n </Button>\n </div>\n </div>\n </div>\n )\n }\n\n if (loadError && !activeBuffer) {\n return (\n <div\n className={cn(\n "flex h-[640px] min-h-0 flex-col overflow-hidden bg-background",\n className\n )}\n >\n <input\n ref={fileInputRef}\n type="file"\n accept=".xlsx,.xls,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.ms-excel"\n className="hidden"\n onChange={handleUpload}\n />\n <WorkbookStandaloneToolbar\n onUploadClick={() => fileInputRef.current?.click()}\n showUploadButton={showUpload}\n toolbarActions={toolbarActions}\n />\n <div className="grid min-h-0 flex-1 place-items-center bg-muted/30 p-4">\n <div className="max-w-md rounded-lg border bg-background p-4 text-sm">\n <p className="font-medium">Unable to display workbook</p>\n <p className="mt-1 text-muted-foreground">{loadError}</p>\n <Button\n type="button"\n variant="outline"\n size="sm"\n className="mt-4"\n onClick={() => fileInputRef.current?.click()}\n >\n <IconPlaceholder\n lucide="Upload"\n tabler="IconUpload"\n hugeicons="Upload01Icon"\n phosphor="UploadSimpleIcon"\n remixicon="RiUpload2Line"\n className="size-4"\n />\n Upload XLSX\n </Button>\n </div>\n </div>\n </div>\n )\n }\n\n if (!activeBuffer) {\n return (\n <div\n className={cn(\n "flex h-[640px] min-h-0 flex-col overflow-hidden bg-background",\n className\n )}\n >\n <input\n ref={fileInputRef}\n type="file"\n accept=".xlsx,.xls,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.ms-excel"\n className="hidden"\n onChange={handleUpload}\n />\n <WorkbookStandaloneToolbar\n onUploadClick={() => fileInputRef.current?.click()}\n showUploadButton={showUpload}\n toolbarActions={toolbarActions}\n />\n <ViewerLoadingSurface showSpinner={shouldShowLoadingSpinner} />\n </div>\n )\n }\n\n return (\n <div className={cn("overflow-hidden", className)}>\n <input\n ref={fileInputRef}\n type="file"\n accept=".xlsx,.xls,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.ms-excel"\n className="hidden"\n onChange={handleUpload}\n />\n <XlsxWorkbookLoadedViewer\n className={className}\n fileName={activeFileName}\n isDark={effectiveIsDark}\n onDownload={() => downloadWorkbookBuffer(activeBuffer, activeFileName)}\n onIsDarkChange={setNightRenderEnabled}\n onUploadClick={() => fileInputRef.current?.click()}\n renderTableHeaderMenu={(props) => (\n <WorkbookTableHeaderMenu {...props} />\n )}\n showDownloadButton={showDownload}\n showNightRenderToggle={shouldRenderNightMode}\n showToolbar={showToolbar}\n showUploadButton={showUpload}\n toolbarActions={toolbarActions}\n workbookBuffer={activeBuffer}\n workbookIdentity={activeIdentity}\n />\n </div>\n )\n}\n\nfunction XlsxWorkbookLoadedViewer({\n className,\n fileName,\n isDark,\n onDownload,\n onIsDarkChange,\n onUploadClick,\n renderTableHeaderMenu,\n showDownloadButton,\n showNightRenderToggle,\n showToolbar = true,\n showUploadButton,\n toolbarActions,\n workbookBuffer,\n workbookIdentity,\n}: {\n className?: string\n fileName: string\n isDark: boolean\n onDownload: () => void\n onIsDarkChange: (checked: boolean) => void\n onUploadClick: () => void\n renderTableHeaderMenu: (\n props: XlsxTableHeaderMenuRenderProps\n ) => React.ReactNode\n showDownloadButton: boolean\n showNightRenderToggle: boolean\n showToolbar?: boolean\n showUploadButton: boolean\n toolbarActions?: React.ReactNode\n workbookBuffer: ArrayBuffer\n workbookIdentity: string\n}) {\n const controller = useXlsxViewerController(\n React.useMemo(\n () => ({\n allowResizeInReadOnly: true,\n file: workbookBuffer,\n fileName,\n maxFileSizeBytes: XLSX_MAX_FILE_SIZE_BYTES,\n readOnly: true,\n useWorker: true,\n }),\n [fileName, workbookBuffer]\n )\n )\n\n return (\n <XlsxViewerProvider controller={controller} isDark={isDark}>\n <XlsxWorkbookSurface\n className={className}\n isDark={isDark}\n onDownload={onDownload}\n onIsDarkChange={onIsDarkChange}\n onUploadClick={onUploadClick}\n renderTableHeaderMenu={renderTableHeaderMenu}\n showDownloadButton={showDownloadButton}\n showNightRenderToggle={showNightRenderToggle}\n showToolbar={showToolbar}\n showUploadButton={showUploadButton}\n toolbarActions={toolbarActions}\n workbookIdentity={workbookIdentity}\n />\n </XlsxViewerProvider>\n )\n}\n'
export function XlsxViewerSource() {
return (
<DocsSourceCodeBlock
code={xlsxViewerSourceCode}
fileName="components/extend/xlsx-viewer.tsx"
/>
)
}