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 EditorPreviewLoading() {
return (
<div className="grid h-[640px] place-items-center bg-background">
<Spinner className="size-4" />
</div>
)
}
const XlsxEditorPreview = dynamic(
() =>
import("@/components/extend/xlsx-editor").then(
(mod) => mod.XlsxEditorPreview
),
{
ssr: false,
loading: () => <EditorPreviewLoading />,
}
)
export function XlsxEditorDemo() {
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"
>
<XlsxEditorPreview
src={SAMPLE_XLSX_URL}
isDark={isDark}
onIsDarkChange={setIsDark}
/>
<DocsViewCodeBlock code={xlsxEditorUsageCode} />
</div>
)
}
const xlsxEditorUsageCode = `"use client";
import * as React from "react";
import { XlsxEditorPreview } from "@/components/extend/xlsx-editor";
export function XlsxEditorExample() {
const [isDark, setIsDark] = React.useState(false);
return (
<XlsxEditorPreview
src="/path/to/workbook.xlsx"
isDark={isDark}
onIsDarkChange={setIsDark}
/>
);
}`
const xlsxEditorSourceCode =
'"use client"\n\nimport * as React from "react"\nimport {\n useXlsxViewer,\n useXlsxViewerController,\n useXlsxViewerEditing,\n useXlsxViewerSelection,\n useXlsxViewerZoom,\n XlsxViewer,\n XlsxViewerProvider,\n type XlsxCellAlignmentInput,\n type XlsxCellBorderEdgeInput,\n type XlsxCellRange,\n type XlsxCellStyleInput,\n type XlsxSheetData,\n type XlsxTableHeaderMenuRenderProps,\n} from "@extend-ai/react-xlsx"\n\nimport type { RegistryIconProps } from "@/lib/registry-icon-props"\nimport { cn } from "@/lib/utils"\nimport { Button } from "@/components/ui/button"\nimport { ColorPicker, ColorPickerPanel } from "@/components/ui/color-picker"\nimport {\n DropdownMenu,\n DropdownMenuContent,\n DropdownMenuGroup,\n DropdownMenuItem,\n DropdownMenuSeparator,\n DropdownMenuSub,\n DropdownMenuSubContent,\n DropdownMenuSubTrigger,\n DropdownMenuTrigger,\n} from "@/components/ui/dropdown-menu"\nimport { Group, GroupSeparator, GroupText } from "@/components/ui/group"\nimport { Input } from "@/components/ui/input"\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 { ToggleGroup, ToggleGroupItem } from "@/components/ui/toggle"\nimport {\n Tooltip,\n TooltipContent,\n TooltipProvider,\n TooltipTrigger,\n} from "@/components/ui/tooltip"\nimport {\n renderXlsxContextMenu,\n renderXlsxScroller,\n WorkbookSheetTabs,\n WorkbookTableHeaderMenu,\n XLSX_CONTEXT_MENU_CLASS_NAME,\n xlsxContextMenuStyle,\n} from "@/components/extend/xlsx-viewer"\nimport { IconPlaceholder } from "@/components/icon-placeholder"\n\nfunction BorderAll01Glyph(props: RegistryIconProps) {\n return (\n <IconPlaceholder\n lucide="Grid2x2"\n tabler="IconBorderAll"\n hugeicons="BorderAll01Icon"\n phosphor="GridFourIcon"\n remixicon="RiGridLine"\n {...props}\n />\n )\n}\n\nfunction BorderBottom01Glyph(props: RegistryIconProps) {\n return (\n <IconPlaceholder\n lucide="PanelBottom"\n tabler="IconBorderBottom"\n hugeicons="BorderBottom01Icon"\n phosphor="SquareHalfBottomIcon"\n remixicon="RiLayoutBottomLine"\n {...props}\n />\n )\n}\n\nfunction BorderLeft01Glyph(props: RegistryIconProps) {\n return (\n <IconPlaceholder\n lucide="PanelLeft"\n tabler="IconBorderLeft"\n hugeicons="BorderLeft01Icon"\n phosphor="SquareHalfIcon"\n remixicon="RiLayoutLeftLine"\n {...props}\n />\n )\n}\n\nfunction BorderNone01Glyph(props: RegistryIconProps) {\n return (\n <IconPlaceholder\n lucide="SquareDashed"\n tabler="IconBorderNone"\n hugeicons="BorderNone01Icon"\n phosphor="SelectionIcon"\n remixicon="RiCheckboxBlankLine"\n {...props}\n />\n )\n}\n\nfunction BorderRight01Glyph(props: RegistryIconProps) {\n return (\n <IconPlaceholder\n lucide="PanelRight"\n tabler="IconBorderRight"\n hugeicons="BorderRight01Icon"\n phosphor="SquareHalfIcon"\n remixicon="RiLayoutRightLine"\n {...props}\n />\n )\n}\n\nfunction BorderTop01Glyph(props: RegistryIconProps) {\n return (\n <IconPlaceholder\n lucide="PanelTop"\n tabler="IconBorderTop"\n hugeicons="BorderTop01Icon"\n phosphor="AlignTopSimpleIcon"\n remixicon="RiLayoutTopLine"\n {...props}\n />\n )\n}\n\nfunction Calendar03Glyph(props: RegistryIconProps) {\n return (\n <IconPlaceholder\n lucide="Calendar"\n tabler="IconCalendar"\n hugeicons="Calendar03Icon"\n phosphor="CalendarIcon"\n remixicon="RiCalendarLine"\n {...props}\n />\n )\n}\n\nfunction DollarCircleGlyph(props: RegistryIconProps) {\n return (\n <IconPlaceholder\n lucide="CircleDollarSign"\n tabler="IconCurrencyDollar"\n hugeicons="DollarCircleIcon"\n phosphor="CurrencyCircleDollarIcon"\n remixicon="RiMoneyDollarCircleLine"\n {...props}\n />\n )\n}\n\nfunction Moon02Glyph(props: RegistryIconProps) {\n return (\n <IconPlaceholder\n lucide="Moon"\n tabler="IconMoon"\n hugeicons="Moon02Icon"\n phosphor="MoonIcon"\n remixicon="RiMoonLine"\n {...props}\n />\n )\n}\n\nfunction PaintBucketGlyph(props: RegistryIconProps) {\n return (\n <IconPlaceholder\n lucide="PaintBucket"\n tabler="IconPaint"\n hugeicons="PaintBucketIcon"\n phosphor="PaintBucketIcon"\n remixicon="RiPaintFill"\n {...props}\n />\n )\n}\n\nfunction PercentGlyph(props: RegistryIconProps) {\n return (\n <IconPlaceholder\n lucide="Percent"\n tabler="IconPercentage"\n hugeicons="PercentIcon"\n phosphor="PercentIcon"\n remixicon="RiPercentLine"\n {...props}\n />\n )\n}\n\nfunction Sun03Glyph(props: RegistryIconProps) {\n return (\n <IconPlaceholder\n lucide="Sun"\n tabler="IconSun"\n hugeicons="Sun03Icon"\n phosphor="SunIcon"\n remixicon="RiSunLine"\n {...props}\n />\n )\n}\n\nfunction TextColorGlyph(props: RegistryIconProps) {\n return (\n <IconPlaceholder\n lucide="Baseline"\n tabler="IconTextColor"\n hugeicons="TextColorIcon"\n phosphor="TextAaIcon"\n remixicon="RiFontColor"\n {...props}\n />\n )\n}\n\nfunction TextNumberSignGlyph(props: RegistryIconProps) {\n return (\n <IconPlaceholder\n lucide="Hash"\n tabler="IconHash"\n hugeicons="TextNumberSignIcon"\n phosphor="HashIcon"\n remixicon="RiHashtag"\n {...props}\n />\n )\n}\n\nfunction TextWrapGlyph(props: RegistryIconProps) {\n return (\n <IconPlaceholder\n lucide="WrapText"\n tabler="IconTextWrap"\n hugeicons="TextWrapIcon"\n phosphor="ArrowElbowDownLeftIcon"\n remixicon="RiTextWrap"\n {...props}\n />\n )\n}\n\nconst XLSX_LOADING_INDICATOR_DELAY_MS = 300\nconst XLSX_EDITOR_READ_ONLY_THRESHOLD_BYTES = 5 * 1024 * 1024\nconst XLSX_DROPDOWN_Z_INDEX_CLASS = "z-40"\nconst ZOOM_OPTIONS = [50, 75, 100, 125, 150, 200, 400] as const\nconst DEFAULT_FONT_FAMILY = "Arial"\nconst FONT_FAMILIES = [\n "Arial",\n "Times New Roman",\n "Georgia",\n "Helvetica",\n "Courier New",\n] as const\nconst FONT_SIZE_OPTIONS = [\n 8, 9, 10, 11, 12, 14, 16, 18, 20, 24, 28, 32, 36, 48,\n] as const\nconst DEFAULT_TEXT_COLOR = "#111827"\nconst DEFAULT_FILL_COLOR = "#fde68a"\nconst DEFAULT_BORDER_COLOR = "#111827"\nconst XLSX_EDITOR_SELECT_CHROME_CLASS =\n "shadow-none before:shadow-none not-data-disabled:not-focus-visible:not-aria-invalid:not-data-pressed:before:shadow-none dark:not-data-disabled:not-focus-visible:not-aria-invalid:not-data-pressed:before:shadow-none"\nconst XLSX_EDITOR_FORMULA_INPUT_CHROME_CLASS =\n "has-disabled:opacity-100 dark:has-disabled:before:shadow-[0_-1px_--theme(--color-white/6%)]"\n\ntype UploadedWorkbook = {\n buffer: ArrayBuffer\n fileName: string\n identity: string\n}\n\ntype NumberFormatOption = {\n formatString?: string\n formatType: NonNullable<XlsxCellStyleInput["numberFormat"]>["formatType"]\n icon: React.ComponentType<RegistryIconProps>\n id?: number\n label: string\n value: string\n}\n\ntype BorderOption = {\n action: XlsxBorderAction\n icon: React.ComponentType<RegistryIconProps>\n label: string\n}\n\ntype XlsxResolvedCellStyle = XlsxSheetData["styleById"][number]\ntype XlsxResolvedStyleGroup = Record<string, unknown>\n\ntype HorizontalAlignment = NonNullable<XlsxCellAlignmentInput["horizontal"]>\n\ntype VerticalAlignment = NonNullable<XlsxCellAlignmentInput["vertical"]>\n\ntype HorizontalAlignmentToggleValue = Extract<\n HorizontalAlignment,\n "left" | "center" | "right"\n>\n\ntype VerticalAlignmentToggleValue = Extract<\n VerticalAlignment,\n "top" | "center" | "bottom"\n>\n\ntype XlsxFontToggleValue = "bold" | "italic" | "underline" | "strikethrough"\n\ntype XlsxMergeRegion = XlsxCellRange\n\ntype XlsxBorderEdgeKey = "bottom" | "left" | "top" | "right"\n\ntype XlsxBorderAction = "all" | "outside" | "none" | XlsxBorderEdgeKey\n\ntype XlsxWorksheetWithMergeRegions = {\n mergedRegions?: unknown[]\n unmergeCells?: (range: string) => boolean\n}\n\nconst NUMBER_FORMAT_OPTIONS: NumberFormatOption[] = [\n {\n formatType: "general",\n icon: TextNumberSignGlyph,\n label: "General",\n value: "General",\n },\n {\n formatString: "0.00",\n formatType: "custom",\n icon: TextNumberSignGlyph,\n label: "Number",\n value: "Number",\n },\n {\n formatString: "$#,##0.00",\n formatType: "custom",\n icon: DollarCircleGlyph,\n label: "Currency",\n value: "Currency",\n },\n {\n formatString: "0.00%",\n formatType: "custom",\n icon: PercentGlyph,\n label: "Percent",\n value: "Percent",\n },\n {\n formatString: "m/d/yyyy",\n formatType: "custom",\n icon: Calendar03Glyph,\n label: "Date",\n value: "Date",\n },\n]\n\nconst GENERAL_NUMBER_FORMAT_VALUE = "General"\nconst BUILTIN_NUMBER_FORMAT_VALUE_PREFIX = "builtin:"\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 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 normalizeHexColor(value: string, fallback = DEFAULT_TEXT_COLOR) {\n const trimmed = value.trim()\n const threeDigit = /^#?([0-9a-f]{3})$/i.exec(trimmed)\n if (threeDigit?.[1]) {\n const [red, green, blue] = threeDigit[1].split("")\n return `#${red}${red}${green}${green}${blue}${blue}`.toLowerCase()\n }\n\n const sixDigit = /^#?([0-9a-f]{6})$/i.exec(trimmed)\n if (sixDigit?.[1]) {\n return `#${sixDigit[1].toLowerCase()}`\n }\n\n return fallback\n}\n\nfunction toXlsxRgbColor(value: string) {\n return {\n colorType: "rgb" as const,\n hex: normalizeHexColor(value).slice(1).toUpperCase(),\n }\n}\n\nfunction asResolvedStyleGroup(\n value: unknown\n): XlsxResolvedStyleGroup | undefined {\n return value && typeof value === "object" && !Array.isArray(value)\n ? (value as XlsxResolvedStyleGroup)\n : undefined\n}\n\nfunction mergeResolvedCellStyle(\n base: XlsxResolvedCellStyle | null | undefined,\n overlay: XlsxResolvedCellStyle | null | undefined\n): XlsxResolvedCellStyle | null {\n if (!base && !overlay) return null\n\n const nextStyle = { ...(base ?? {}), ...(overlay ?? {}) }\n const baseFont = asResolvedStyleGroup(base?.font)\n const overlayFont = asResolvedStyleGroup(overlay?.font)\n\n if (baseFont || overlayFont) {\n nextStyle.font = overlayFont ?? baseFont\n }\n\n return nextStyle\n}\n\nfunction resolveInheritedCellStyle(\n sheet: XlsxSheetData | null,\n row: number,\n col: number\n): XlsxResolvedCellStyle | null {\n if (!sheet) return null\n\n const colStyleId = sheet.colStyleIds[col]\n const rowStyleId = sheet.rowStyleIds[row]\n const colStyle =\n colStyleId !== undefined ? sheet.styleById[colStyleId] : undefined\n const rowStyle =\n rowStyleId !== undefined ? sheet.styleById[rowStyleId] : undefined\n\n return mergeResolvedCellStyle(colStyle, rowStyle)\n}\n\nfunction getFontToggleValuesFromStyle(\n style: XlsxResolvedCellStyle | null\n): XlsxFontToggleValue[] {\n const font = asResolvedStyleGroup(style?.font)\n const values: XlsxFontToggleValue[] = []\n\n if (font?.bold === true) values.push("bold")\n if (font?.italic === true) values.push("italic")\n if (font?.underline && font.underline !== "none") values.push("underline")\n if (font?.strikethrough === true) values.push("strikethrough")\n\n return values\n}\n\nfunction getFontFamilyValue(style: XlsxResolvedCellStyle | null) {\n const font = asResolvedStyleGroup(style?.font)\n const fontName = font?.name\n\n return typeof fontName === "string" && fontName.trim()\n ? fontName.trim()\n : undefined\n}\n\nfunction getHorizontalAlignmentValue(\n style: XlsxResolvedCellStyle | null\n): HorizontalAlignmentToggleValue[] {\n const alignment = asResolvedStyleGroup(style?.alignment)\n const horizontal = alignment?.horizontal\n\n return horizontal === "left" ||\n horizontal === "center" ||\n horizontal === "right"\n ? [horizontal]\n : []\n}\n\nfunction getVerticalAlignmentValue(\n style: XlsxResolvedCellStyle | null\n): VerticalAlignmentToggleValue[] {\n const alignment = asResolvedStyleGroup(style?.alignment)\n const vertical = alignment?.vertical\n\n if (vertical === undefined || vertical === null) return ["bottom"]\n\n return vertical === "top" || vertical === "center" || vertical === "bottom"\n ? [vertical]\n : []\n}\n\nfunction getNumberFormatValue(style: XlsxResolvedCellStyle | null) {\n const numberFormat = asResolvedStyleGroup(style?.numberFormat)\n\n if (!numberFormat) return GENERAL_NUMBER_FORMAT_VALUE\n\n const formatType = numberFormat.formatType\n const formatString =\n typeof numberFormat.formatString === "string"\n ? numberFormat.formatString.trim()\n : ""\n const id = getNumericValue(numberFormat.id)\n\n if (formatString) {\n const matchingOption = NUMBER_FORMAT_OPTIONS.find(\n (option) => option.formatString === formatString\n )\n\n return matchingOption?.value ?? formatString\n }\n if (formatType === "builtin" && id !== undefined) {\n const matchingOption = NUMBER_FORMAT_OPTIONS.find(\n (option) => option.id === id\n )\n\n if (matchingOption) return matchingOption.value\n\n return `${BUILTIN_NUMBER_FORMAT_VALUE_PREFIX}${id}`\n }\n if (formatType === "general") return GENERAL_NUMBER_FORMAT_VALUE\n\n return GENERAL_NUMBER_FORMAT_VALUE\n}\n\nfunction getNumberFormatLabel(value: string) {\n if (value === GENERAL_NUMBER_FORMAT_VALUE) return "General"\n\n const matchingOption = NUMBER_FORMAT_OPTIONS.find(\n (option) => option.value === value\n )\n if (matchingOption) return matchingOption.label\n\n if (value.startsWith(BUILTIN_NUMBER_FORMAT_VALUE_PREFIX)) {\n return `Builtin ${value.slice(BUILTIN_NUMBER_FORMAT_VALUE_PREFIX.length)}`\n }\n\n return value\n}\n\nfunction getNumberFormatIcon(value: string) {\n return (\n NUMBER_FORMAT_OPTIONS.find((option) => option.value === value)?.icon ??\n TextNumberSignGlyph\n )\n}\n\nfunction createNumberFormatStyle(value: string): XlsxCellStyleInput {\n const matchingOption = NUMBER_FORMAT_OPTIONS.find(\n (option) => option.value === value\n )\n\n if (matchingOption) {\n return {\n numberFormat: {\n formatString: matchingOption.formatString,\n formatType: matchingOption.formatType,\n id: matchingOption.id,\n },\n }\n }\n\n if (value.startsWith(BUILTIN_NUMBER_FORMAT_VALUE_PREFIX)) {\n const id = Number(value.slice(BUILTIN_NUMBER_FORMAT_VALUE_PREFIX.length))\n\n if (Number.isFinite(id)) {\n return {\n numberFormat: {\n formatType: "builtin",\n id: Math.max(0, Math.trunc(id)),\n },\n }\n }\n }\n\n return {\n numberFormat: {\n formatString: value,\n formatType: "custom",\n },\n }\n}\n\nfunction normalizeCellRange(range: XlsxCellRange): XlsxCellRange {\n return {\n start: {\n row: Math.min(range.start.row, range.end.row),\n col: Math.min(range.start.col, range.end.col),\n },\n end: {\n row: Math.max(range.start.row, range.end.row),\n col: Math.max(range.start.col, range.end.col),\n },\n }\n}\n\nfunction getNumericValue(value: unknown) {\n return typeof value === "number" && Number.isFinite(value)\n ? Math.max(0, Math.trunc(value))\n : undefined\n}\n\nfunction getWorksheetMergeRegions(\n worksheet: XlsxWorksheetWithMergeRegions | null\n): XlsxMergeRegion[] {\n if (!Array.isArray(worksheet?.mergedRegions)) return []\n\n return worksheet.mergedRegions.flatMap((entry) => {\n if (!entry || typeof entry !== "object") return []\n\n const region = entry as Record<string, unknown>\n const start = asResolvedStyleGroup(region.start)\n const end = asResolvedStyleGroup(region.end)\n const startRow = getNumericValue(region.startRow ?? start?.row)\n const startCol = getNumericValue(region.startCol ?? start?.col)\n const endRow = getNumericValue(region.endRow ?? end?.row)\n const endCol = getNumericValue(region.endCol ?? end?.col)\n\n if (\n startRow === undefined ||\n startCol === undefined ||\n endRow === undefined ||\n endCol === undefined\n ) {\n return []\n }\n\n return [\n normalizeCellRange({\n start: { row: startRow, col: startCol },\n end: { row: endRow, col: endCol },\n }),\n ]\n })\n}\n\nfunction rangesIntersect(\n firstRange: XlsxCellRange,\n secondRange: XlsxCellRange\n) {\n const first = normalizeCellRange(firstRange)\n const second = normalizeCellRange(secondRange)\n\n return (\n first.start.row <= second.end.row &&\n first.end.row >= second.start.row &&\n first.start.col <= second.end.col &&\n first.end.col >= second.start.col\n )\n}\n\nfunction isSingleCellRange(range: XlsxCellRange) {\n const normalizedRange = normalizeCellRange(range)\n\n return (\n normalizedRange.start.row === normalizedRange.end.row &&\n normalizedRange.start.col === normalizedRange.end.col\n )\n}\n\nfunction getCellColumnLabel(col: number) {\n let label = ""\n let value = col\n\n do {\n label = String.fromCharCode(65 + (value % 26)) + label\n value = Math.floor(value / 26) - 1\n } while (value >= 0)\n\n return label\n}\n\nfunction cellAddressToA1(cell: XlsxCellRange["start"]) {\n return `${getCellColumnLabel(cell.col)}${cell.row + 1}`\n}\n\nfunction rangeToA1(range: XlsxCellRange) {\n const normalizedRange = normalizeCellRange(range)\n\n return `${cellAddressToA1(normalizedRange.start)}:${cellAddressToA1(\n normalizedRange.end\n )}`\n}\n\nfunction getRangeKey(range: XlsxCellRange) {\n const normalizedRange = normalizeCellRange(range)\n\n return `${normalizedRange.start.row}:${normalizedRange.start.col}:${normalizedRange.end.row}:${normalizedRange.end.col}`\n}\n\nfunction createBorderEdge(\n color = DEFAULT_BORDER_COLOR\n): XlsxCellBorderEdgeInput {\n return {\n color: toXlsxRgbColor(color),\n style: "thin",\n }\n}\n\nfunction createBorderPatch(\n entries: Partial<Record<XlsxBorderEdgeKey, XlsxCellBorderEdgeInput>>\n): XlsxCellStyleInput {\n return {\n border: entries,\n }\n}\n\nfunction createNoBorderPatch(): XlsxCellStyleInput {\n return {\n border: {\n bottom: { style: "none" },\n left: { style: "none" },\n right: { style: "none" },\n top: { style: "none" },\n },\n }\n}\n\nfunction createBorderOptions(): BorderOption[] {\n return [\n {\n action: "bottom",\n icon: BorderBottom01Glyph,\n label: "Bottom border",\n },\n {\n action: "left",\n icon: BorderLeft01Glyph,\n label: "Left border",\n },\n {\n action: "top",\n icon: BorderTop01Glyph,\n label: "Top border",\n },\n {\n action: "right",\n icon: BorderRight01Glyph,\n label: "Right border",\n },\n {\n action: "all",\n icon: BorderAll01Glyph,\n label: "All borders",\n },\n {\n action: "outside",\n icon: BorderAll01Glyph,\n label: "Outside border",\n },\n {\n action: "none",\n icon: BorderNone01Glyph,\n label: "No border",\n },\n ]\n}\n\nfunction getBorderEdgeRange(\n range: XlsxCellRange,\n edgeKey: XlsxBorderEdgeKey\n): XlsxCellRange {\n const normalizedRange = normalizeCellRange(range)\n\n if (edgeKey === "top") {\n return {\n start: normalizedRange.start,\n end: { row: normalizedRange.start.row, col: normalizedRange.end.col },\n }\n }\n\n if (edgeKey === "bottom") {\n return {\n start: { row: normalizedRange.end.row, col: normalizedRange.start.col },\n end: normalizedRange.end,\n }\n }\n\n if (edgeKey === "left") {\n return {\n start: normalizedRange.start,\n end: { row: normalizedRange.end.row, col: normalizedRange.start.col },\n }\n }\n\n return {\n start: { row: normalizedRange.start.row, col: normalizedRange.end.col },\n end: normalizedRange.end,\n }\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 EditorLoadingSurface({\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 ToolbarIconButton({\n active,\n children,\n label,\n ...props\n}: React.ComponentProps<typeof Button> & {\n active?: boolean\n label: string\n}) {\n return (\n <ToolbarTooltip label={label}>\n <Button\n type="button"\n variant={active ? "secondary" : "ghost"}\n size="icon-sm"\n aria-label={label}\n data-pressed={active ? "" : undefined}\n {...props}\n >\n {children}\n </Button>\n </ToolbarTooltip>\n )\n}\n\nfunction ToolbarSeparator() {\n return <Separator orientation="vertical" className="mx-1 h-4 self-center" />\n}\n\nfunction StyleDropdownItem({\n children,\n icon,\n onClick,\n}: {\n children: React.ReactNode\n icon: React.ComponentType<RegistryIconProps>\n onClick: () => void\n}) {\n const IconComponent = icon\n return (\n <DropdownMenuItem onClick={onClick}>\n <IconComponent className="size-4" />\n {children}\n </DropdownMenuItem>\n )\n}\n\nfunction MergeCellsMenu({\n canMerge,\n canMergeAcross,\n canUnmerge,\n disabled,\n isMerged,\n onMergeAcross,\n onMergeAndCenter,\n onMergeCells,\n onUnmergeCells,\n}: {\n canMerge: boolean\n canMergeAcross: boolean\n canUnmerge: boolean\n disabled: boolean\n isMerged: boolean\n onMergeAcross: () => void\n onMergeAndCenter: () => void\n onMergeCells: () => void\n onUnmergeCells: () => void\n}) {\n return (\n <DropdownMenu>\n <div\n className={cn(\n "inline-flex shrink-0 overflow-hidden rounded-lg border border-transparent"\n )}\n >\n <ToolbarTooltip\n label={isMerged ? "Unmerge cells from the menu" : "Merge & Center"}\n >\n <Button\n type="button"\n variant={isMerged ? "secondary" : "ghost"}\n size="sm"\n aria-label="Merge & Center"\n className="h-7 rounded-r-none border-0 px-2.5 before:rounded-r-none"\n data-pressed={isMerged ? "" : undefined}\n disabled={disabled || !canMerge}\n onClick={onMergeAndCenter}\n >\n <IconPlaceholder\n lucide="TableCellsMerge"\n tabler="IconArrowMerge"\n hugeicons="PathfinderMergeIcon"\n phosphor="ArrowsMergeIcon"\n remixicon="RiMergeCellsVertical"\n className="size-4"\n />\n <span className="hidden text-xs font-medium lg:inline">\n Merge & Center\n </span>\n </Button>\n </ToolbarTooltip>\n <DropdownMenuTrigger asChild>\n <Button\n type="button"\n variant={isMerged ? "secondary" : "ghost"}\n size="icon-sm"\n aria-label="Merge cells options"\n className="h-7 w-6 rounded-l-none border-0 px-0 before:rounded-l-none"\n data-pressed={isMerged ? "" : undefined}\n disabled={disabled}\n >\n <IconPlaceholder\n lucide="ChevronDown"\n tabler="IconChevronDown"\n hugeicons="ChevronDownIcon"\n phosphor="CaretDownIcon"\n remixicon="RiArrowDownSLine"\n className="size-3.5 opacity-100"\n />\n </Button>\n </DropdownMenuTrigger>\n </div>\n <DropdownMenuContent\n align="start"\n className={cn("w-56", XLSX_DROPDOWN_Z_INDEX_CLASS)}\n >\n <DropdownMenuItem disabled={!canMerge} onClick={onMergeAndCenter}>\n <IconPlaceholder\n lucide="TableCellsMerge"\n tabler="IconArrowMerge"\n hugeicons="PathfinderMergeIcon"\n phosphor="ArrowsMergeIcon"\n remixicon="RiMergeCellsVertical"\n className="size-4"\n />\n Merge & Center\n </DropdownMenuItem>\n <DropdownMenuItem disabled={!canMergeAcross} onClick={onMergeAcross}>\n <IconPlaceholder\n lucide="TableRowsSplit"\n tabler="IconArrowsSplit"\n hugeicons="TableRowsSplitIcon"\n phosphor="ArrowsSplitIcon"\n remixicon="RiSplitCellsVertical"\n className="size-4"\n />\n Merge Across\n </DropdownMenuItem>\n <DropdownMenuItem disabled={!canMerge} onClick={onMergeCells}>\n <IconPlaceholder\n lucide="Grid3x3"\n tabler="IconGrid4x4"\n hugeicons="CellsIcon"\n phosphor="GridNineIcon"\n remixicon="RiMergeCellsHorizontal"\n className="size-4"\n />\n Merge Cells\n </DropdownMenuItem>\n <DropdownMenuSeparator />\n <DropdownMenuItem disabled={!canUnmerge} onClick={onUnmergeCells}>\n <IconPlaceholder\n lucide="Grid2x2X"\n tabler="IconTableMinus"\n hugeicons="Grid2X2XIcon"\n phosphor="SelectionSlashIcon"\n remixicon="RiSplitCellsHorizontal"\n className="size-4"\n />\n Unmerge Cells\n </DropdownMenuItem>\n </DropdownMenuContent>\n </DropdownMenu>\n )\n}\n\nfunction NumberFormatSelect({\n disabled,\n onApplyStyle,\n value,\n}: {\n disabled: boolean\n onApplyStyle: (style: XlsxCellStyleInput) => void\n value: string\n}) {\n const hasMatchingOption = NUMBER_FORMAT_OPTIONS.some(\n (option) => option.value === value\n )\n const currentLabel = getNumberFormatLabel(value)\n const currentIcon = React.createElement(getNumberFormatIcon(value), {\n className: "size-4",\n })\n\n return (\n <Select\n value={value}\n onValueChange={(nextValue) => {\n if (!nextValue) return\n onApplyStyle(createNumberFormatStyle(nextValue))\n }}\n disabled={disabled}\n >\n <SelectTrigger\n size="sm"\n className={cn(\n "w-[132px] min-w-[132px]",\n XLSX_EDITOR_SELECT_CHROME_CLASS\n )}\n aria-label="Number format"\n >\n {currentIcon}\n <SelectValue placeholder="General" />\n </SelectTrigger>\n <SelectContent\n align="start"\n alignItemWithTrigger={false}\n className={XLSX_DROPDOWN_Z_INDEX_CLASS}\n >\n {NUMBER_FORMAT_OPTIONS.map((option) => (\n <SelectItem key={option.value} value={option.value}>\n <span className="flex min-w-0 items-center gap-2">\n <option.icon className="size-4" />\n <span className="truncate">{option.label}</span>\n </span>\n </SelectItem>\n ))}\n {!hasMatchingOption && value !== GENERAL_NUMBER_FORMAT_VALUE ? (\n <SelectItem value={value}>\n <span className="flex min-w-0 items-center gap-2">\n {currentIcon}\n <span className="truncate">{currentLabel}</span>\n </span>\n </SelectItem>\n ) : null}\n </SelectContent>\n </Select>\n )\n}\n\nfunction BorderMenu({\n borderColor,\n disabled,\n onApplyBorder,\n onBorderColorChange,\n}: {\n borderColor: string\n disabled: boolean\n onApplyBorder: (action: XlsxBorderAction) => void\n onBorderColorChange: (color: string) => void\n}) {\n const borderOptions = React.useMemo(() => createBorderOptions(), [])\n const edgeBorderOptions = borderOptions.filter(\n (option) =>\n option.action === "bottom" ||\n option.action === "left" ||\n option.action === "top" ||\n option.action === "right"\n )\n const groupedBorderOptions = borderOptions.filter(\n (option) =>\n option.action === "all" ||\n option.action === "outside" ||\n option.action === "none"\n )\n\n return (\n <DropdownMenu>\n <DropdownMenuTrigger asChild>\n <Button\n type="button"\n variant="ghost"\n size="icon-sm"\n disabled={disabled}\n aria-label="Cell borders"\n className="relative"\n >\n <IconPlaceholder\n lucide="Grid2x2"\n tabler="IconBorderAll"\n hugeicons="BorderAll01Icon"\n phosphor="GridFourIcon"\n remixicon="RiGridLine"\n className="size-4"\n />\n <span\n className="absolute right-1 bottom-1 h-1 w-4 rounded-full border border-background"\n style={{ backgroundColor: borderColor }}\n />\n </Button>\n </DropdownMenuTrigger>\n <DropdownMenuContent\n align="start"\n className={cn("w-48", XLSX_DROPDOWN_Z_INDEX_CLASS)}\n >\n {edgeBorderOptions.map((option) => (\n <StyleDropdownItem\n key={option.label}\n icon={option.icon}\n onClick={() => onApplyBorder(option.action)}\n >\n {option.label}\n </StyleDropdownItem>\n ))}\n <DropdownMenuSeparator />\n <DropdownMenuGroup>\n {groupedBorderOptions.map((option) => (\n <StyleDropdownItem\n key={option.label}\n icon={option.icon}\n onClick={() => onApplyBorder(option.action)}\n >\n {option.label}\n </StyleDropdownItem>\n ))}\n </DropdownMenuGroup>\n <DropdownMenuSeparator />\n <DropdownMenuSub>\n <DropdownMenuSubTrigger>\n <IconPlaceholder\n lucide="Baseline"\n tabler="IconTextColor"\n hugeicons="TextColorIcon"\n phosphor="TextAaIcon"\n remixicon="RiFontColor"\n className="size-4 text-muted-foreground"\n />\n Border color\n <span\n className="h-3 w-5 rounded-full border border-border"\n style={{ backgroundColor: borderColor }}\n />\n </DropdownMenuSubTrigger>\n <DropdownMenuSubContent\n className={cn("w-auto p-3", XLSX_DROPDOWN_Z_INDEX_CLASS)}\n >\n <ColorPickerPanel\n label="Border color"\n color={borderColor}\n onChange={(color) =>\n onBorderColorChange(normalizeHexColor(color))\n }\n />\n </DropdownMenuSubContent>\n </DropdownMenuSub>\n </DropdownMenuContent>\n </DropdownMenu>\n )\n}\n\nfunction AlignmentMoreMenu({\n disabled,\n onApplyStyle,\n}: {\n disabled: boolean\n onApplyStyle: (style: XlsxCellStyleInput) => void\n}) {\n return (\n <DropdownMenu>\n <DropdownMenuTrigger asChild>\n <Button\n type="button"\n variant="ghost"\n size="icon-sm"\n disabled={disabled}\n aria-label="More alignment"\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="start"\n className={cn("w-48", XLSX_DROPDOWN_Z_INDEX_CLASS)}\n >\n <StyleDropdownItem\n icon={TextWrapGlyph}\n onClick={() => onApplyStyle({ alignment: { wrapText: false } })}\n >\n Do not wrap\n </StyleDropdownItem>\n <StyleDropdownItem\n icon={TextWrapGlyph}\n onClick={() => onApplyStyle({ alignment: { shrinkToFit: true } })}\n >\n Shrink to fit\n </StyleDropdownItem>\n <StyleDropdownItem\n icon={TextWrapGlyph}\n onClick={() => onApplyStyle({ alignment: { shrinkToFit: false } })}\n >\n Do not shrink\n </StyleDropdownItem>\n </DropdownMenuContent>\n </DropdownMenu>\n )\n}\n\nfunction EditorFileActionsMenu({\n canExport,\n exportXlsx,\n onUploadClick,\n}: {\n canExport: boolean\n exportXlsx: () => void\n onUploadClick: () => void\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-40", XLSX_DROPDOWN_Z_INDEX_CLASS)}\n >\n <DropdownMenuItem disabled={!canExport} onClick={exportXlsx}>\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 <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 </DropdownMenuContent>\n </DropdownMenu>\n )\n}\n\nfunction EditorToolbar({\n isDark,\n onIsDarkChange,\n onUploadClick,\n showNightRenderToggle,\n workbookIdentity,\n}: {\n isDark: boolean\n onIsDarkChange: (checked: boolean) => void\n onUploadClick: () => void\n showNightRenderToggle: boolean\n workbookIdentity: string\n}) {\n const {\n activeSheet,\n activeSheetIndex,\n canExport,\n exportXlsx,\n getActiveWorksheet,\n revision,\n setActiveSheetIndex,\n sheets,\n } = useXlsxViewer()\n const { activeCell, activeCellAddress, selectRange, selection } =\n useXlsxViewerSelection()\n const {\n addSheet,\n canRedo,\n canUndo,\n mergeSelection,\n pasteStructuredClipboardData,\n readOnly,\n redo,\n removeActiveSheet,\n selectedFormula,\n selectedValue,\n setCellStyle,\n setCellFormula,\n setCellValue,\n setRangeStyle,\n setSelectedCellStyle,\n undo,\n unmergeSelection,\n } = useXlsxViewerEditing()\n const { canZoomIn, canZoomOut, setZoomScale, zoomIn, zoomOut, zoomScale } =\n useXlsxViewerZoom()\n const [formulaDraft, setFormulaDraft] = React.useState("")\n const [formulaFocused, setFormulaFocused] = React.useState(false)\n const [fontFamily, setFontFamily] = React.useState(DEFAULT_FONT_FAMILY)\n const [fontSize, setFontSize] = React.useState(11)\n const [textColor, setTextColor] = React.useState(DEFAULT_TEXT_COLOR)\n const [fillColor, setFillColor] = React.useState(DEFAULT_FILL_COLOR)\n const [borderColor, setBorderColor] = React.useState(DEFAULT_BORDER_COLOR)\n const [appliedMergeRegions, setAppliedMergeRegions] = React.useState<\n XlsxMergeRegion[]\n >([])\n const lastStyleTargetRef = React.useRef<{\n range: XlsxCellRange\n sheetIndex: number\n workbookIdentity: string\n } | null>(null)\n const formulaEditCellRef = React.useRef<typeof activeCell>(null)\n const formulaInitialValueRef = React.useRef("")\n const hasWorkbook = sheets.length > 0\n const hasSelection = Boolean(selection)\n const hasActiveCell = Boolean(activeCell)\n const canStyleSelection = (hasSelection || hasActiveCell) && !readOnly\n const activeRange = React.useMemo<XlsxCellRange | null>(() => {\n if (selection) return normalizeCellRange(selection)\n if (!activeCell) return null\n\n return {\n start: activeCell,\n end: activeCell,\n }\n }, [activeCell, selection])\n\n React.useEffect(() => {\n if (!activeRange) return\n\n lastStyleTargetRef.current = {\n range: activeRange,\n sheetIndex: activeSheetIndex,\n workbookIdentity,\n }\n }, [activeRange, activeSheetIndex, workbookIdentity])\n const worksheetMergeRegions = React.useMemo(() => {\n void revision\n\n return getWorksheetMergeRegions(\n getActiveWorksheet() as XlsxWorksheetWithMergeRegions | null\n )\n }, [getActiveWorksheet, revision])\n const mergeRegions = React.useMemo(\n () => [...worksheetMergeRegions, ...appliedMergeRegions],\n [appliedMergeRegions, worksheetMergeRegions]\n )\n const selectionIntersectsMerge = Boolean(\n activeRange &&\n mergeRegions.some((mergeRegion) =>\n rangesIntersect(activeRange, mergeRegion)\n )\n )\n\n const pendingMergeRegions = appliedMergeRegions.filter(\n (currentRegion) =>\n !worksheetMergeRegions.some((worksheetRegion) =>\n rangesIntersect(currentRegion, worksheetRegion)\n )\n )\n if (pendingMergeRegions.length !== appliedMergeRegions.length) {\n setAppliedMergeRegions(pendingMergeRegions)\n }\n\n const [previousSheetIndex, setPreviousSheetIndex] =\n React.useState(activeSheetIndex)\n if (!Object.is(previousSheetIndex, activeSheetIndex)) {\n setPreviousSheetIndex(activeSheetIndex)\n setAppliedMergeRegions([])\n }\n const selectionIsSingleCell = activeRange\n ? isSingleCellRange(activeRange)\n : true\n const selectionSpansMultipleColumns = activeRange\n ? activeRange.start.col !== activeRange.end.col\n : false\n const canMergeSelectedCells = Boolean(\n selection &&\n !readOnly &&\n !selectionIntersectsMerge &&\n !selectionIsSingleCell\n )\n const canMergeAcross = Boolean(\n selection &&\n !readOnly &&\n !selectionIntersectsMerge &&\n selectionSpansMultipleColumns\n )\n const canUnmergeSelectedCells = Boolean(\n selection && !readOnly && selectionIntersectsMerge\n )\n const currentZoom = Math.round(zoomScale)\n const selectedCellInputValue = selectedFormula || selectedValue\n\n const activeCellStyle = React.useMemo(() => {\n // Worksheet style objects are mutable; revision invalidates this read after edits.\n void revision\n\n if (!activeCell) return null\n\n const worksheet = getActiveWorksheet()\n const inheritedStyle = resolveInheritedCellStyle(\n activeSheet,\n activeCell.row,\n activeCell.col\n )\n const cellStyle = worksheet?.getCellStyleAt(\n activeCell.row,\n activeCell.col\n ) as XlsxResolvedCellStyle | null | undefined\n\n return mergeResolvedCellStyle(inheritedStyle, cellStyle)\n }, [activeCell, activeSheet, getActiveWorksheet, revision])\n const fontToggleValues = React.useMemo(\n () => getFontToggleValuesFromStyle(activeCellStyle),\n [activeCellStyle]\n )\n const fontFamilyValue = getFontFamilyValue(activeCellStyle) ?? fontFamily\n const horizontalAlignmentValue = React.useMemo(\n () => getHorizontalAlignmentValue(activeCellStyle),\n [activeCellStyle]\n )\n const verticalAlignmentValue = React.useMemo(\n () => getVerticalAlignmentValue(activeCellStyle),\n [activeCellStyle]\n )\n const numberFormatValue = React.useMemo(\n () => getNumberFormatValue(activeCellStyle),\n [activeCellStyle]\n )\n\n const commitFormula = React.useCallback(() => {\n const targetCell = formulaEditCellRef.current ?? activeCell\n if (!targetCell) return\n if (formulaDraft === formulaInitialValueRef.current) return\n\n if (formulaDraft.trim().startsWith("=")) {\n setCellFormula(targetCell, formulaDraft)\n } else {\n setCellValue(targetCell, formulaDraft)\n }\n formulaInitialValueRef.current = formulaDraft\n }, [activeCell, formulaDraft, setCellFormula, setCellValue])\n\n const applyStyle = React.useCallback(\n (style: XlsxCellStyleInput) => {\n const applyRangeStyle = (range: XlsxCellRange) => {\n const normalizedRange = normalizeCellRange(range)\n const targetRanges = [\n normalizedRange,\n ...mergeRegions.filter((mergeRegion) =>\n rangesIntersect(normalizedRange, mergeRegion)\n ),\n ]\n const uniqueTargetRanges = new Map<string, XlsxCellRange>()\n\n targetRanges.forEach((targetRange) => {\n const normalizedTargetRange = normalizeCellRange(targetRange)\n uniqueTargetRanges.set(\n getRangeKey(normalizedTargetRange),\n normalizedTargetRange\n )\n })\n\n uniqueTargetRanges.forEach((targetRange) => {\n setRangeStyle(targetRange, style)\n })\n }\n\n if (selection) {\n const normalizedSelection = normalizeCellRange(selection)\n\n if (!isSingleCellRange(normalizedSelection)) {\n applyRangeStyle(normalizedSelection)\n return true\n }\n\n if (activeCell) {\n setSelectedCellStyle(style)\n return true\n }\n\n setCellStyle(normalizedSelection.start, style)\n return true\n }\n\n if (activeCell) {\n setSelectedCellStyle(style)\n return true\n }\n\n const fallbackTarget = lastStyleTargetRef.current\n const targetRange =\n fallbackTarget?.sheetIndex === activeSheetIndex &&\n fallbackTarget.workbookIdentity === workbookIdentity\n ? fallbackTarget.range\n : null\n\n if (!targetRange) return false\n\n if (isSingleCellRange(targetRange)) {\n setCellStyle(normalizeCellRange(targetRange).start, style)\n return true\n }\n\n applyRangeStyle(targetRange)\n return true\n },\n [\n activeCell,\n activeSheetIndex,\n mergeRegions,\n selection,\n setCellStyle,\n setRangeStyle,\n setSelectedCellStyle,\n workbookIdentity,\n ]\n )\n\n const applyBorderAction = React.useCallback(\n (action: XlsxBorderAction) => {\n if (!activeRange) return\n\n const normalizedRange = normalizeCellRange(activeRange)\n const edge = createBorderEdge(borderColor)\n const allBorderPatch = createBorderPatch({\n bottom: edge,\n left: edge,\n right: edge,\n top: edge,\n })\n\n if (action === "all") {\n setRangeStyle(normalizedRange, allBorderPatch)\n return\n }\n\n if (action === "none") {\n setRangeStyle(normalizedRange, createNoBorderPatch())\n return\n }\n\n if (action === "outside") {\n if (isSingleCellRange(normalizedRange)) {\n setCellStyle(normalizedRange.start, allBorderPatch)\n return\n }\n\n const outsideEdgeKeys: XlsxBorderEdgeKey[] = [\n "top",\n "bottom",\n "left",\n "right",\n ]\n\n outsideEdgeKeys.forEach((edgeKey) => {\n setRangeStyle(\n getBorderEdgeRange(normalizedRange, edgeKey),\n createBorderPatch({ [edgeKey]: edge })\n )\n })\n return\n }\n\n setRangeStyle(\n getBorderEdgeRange(normalizedRange, action),\n createBorderPatch({ [action]: edge })\n )\n },\n [activeRange, borderColor, setCellStyle, setRangeStyle]\n )\n\n const applyHorizontalAlignment = React.useCallback(\n (horizontal: HorizontalAlignmentToggleValue | undefined) => {\n if (!horizontal) return\n\n applyStyle({ alignment: { horizontal } })\n },\n [applyStyle]\n )\n\n const applyVerticalAlignment = React.useCallback(\n (vertical: VerticalAlignmentToggleValue | undefined) => {\n if (!vertical) return\n\n applyStyle({ alignment: { vertical } })\n },\n [applyStyle]\n )\n\n const mergeSelectedCells = React.useCallback(() => {\n if (!canMergeSelectedCells || !selection) return\n\n setAppliedMergeRegions([normalizeCellRange(selection)])\n mergeSelection()\n }, [canMergeSelectedCells, mergeSelection, selection])\n\n const mergeAcrossSelectedCells = React.useCallback(() => {\n if (!activeCell || !canMergeAcross || !selection) return\n\n const normalizedRange = normalizeCellRange(selection)\n const worksheet = getActiveWorksheet()\n if (!worksheet) return\n\n const formula = worksheet.getFormulaAt(activeCell.row, activeCell.col)\n const rawValue = worksheet.getCellAt(activeCell.row, activeCell.col).toJs()\n const colSpan = normalizedRange.end.col - normalizedRange.start.col + 1\n const rowSpan = normalizedRange.end.row - normalizedRange.start.row + 1\n const merges = Array.from({ length: rowSpan }, (_, rowOffset) => ({\n colOffset: normalizedRange.start.col - activeCell.col,\n colSpan,\n rowOffset: normalizedRange.start.row + rowOffset - activeCell.row,\n rowSpan: 1,\n }))\n const mergeRegionsByRow = Array.from({ length: rowSpan }, (_, rowOffset) =>\n normalizeCellRange({\n start: {\n col: normalizedRange.start.col,\n row: normalizedRange.start.row + rowOffset,\n },\n end: {\n col: normalizedRange.end.col,\n row: normalizedRange.start.row + rowOffset,\n },\n })\n )\n\n const didPaste = pasteStructuredClipboardData(\n JSON.stringify({\n cells: [\n formula\n ? { colOffset: 0, formula, rowOffset: 0 }\n : { colOffset: 0, rowOffset: 0, value: rawValue ?? "" },\n ],\n cols: colSpan,\n merges,\n rows: rowSpan,\n })\n )\n\n if (!didPaste) return\n\n setAppliedMergeRegions(mergeRegionsByRow)\n selectRange(normalizedRange)\n }, [\n activeCell,\n canMergeAcross,\n getActiveWorksheet,\n pasteStructuredClipboardData,\n selectRange,\n selection,\n ])\n\n const mergeAndCenterSelectedCells = React.useCallback(() => {\n if (!canMergeSelectedCells || !selection) return\n\n setAppliedMergeRegions([normalizeCellRange(selection)])\n setRangeStyle(selection, { alignment: { horizontal: "center" } })\n mergeSelection()\n }, [canMergeSelectedCells, mergeSelection, selection, setRangeStyle])\n\n const unmergeSelectedCells = React.useCallback(() => {\n if (!canUnmergeSelectedCells || !activeRange) return\n\n const worksheet =\n getActiveWorksheet() as XlsxWorksheetWithMergeRegions | null\n if (!worksheet?.unmergeCells) return\n\n const normalizedRange = normalizeCellRange(activeRange)\n const uniqueMergeRegions = new Map<string, XlsxMergeRegion>()\n\n ;[...worksheetMergeRegions, ...appliedMergeRegions].forEach(\n (mergeRegion) => {\n if (!rangesIntersect(normalizedRange, mergeRegion)) return\n\n uniqueMergeRegions.set(getRangeKey(mergeRegion), mergeRegion)\n }\n )\n\n let didUnmerge = false\n\n uniqueMergeRegions.forEach((mergeRegion) => {\n didUnmerge =\n worksheet.unmergeCells?.(rangeToA1(mergeRegion)) || didUnmerge\n })\n\n if (!didUnmerge) {\n unmergeSelection()\n return\n }\n\n setAppliedMergeRegions([])\n setRangeStyle(normalizedRange, {})\n selectRange(normalizedRange)\n }, [\n activeRange,\n appliedMergeRegions,\n canUnmergeSelectedCells,\n getActiveWorksheet,\n selectRange,\n setRangeStyle,\n unmergeSelection,\n worksheetMergeRegions,\n ])\n\n const applyFontToggleValues = React.useCallback(\n (nextValues: XlsxFontToggleValue[]) => {\n const previousValues = fontToggleValues\n const changedValue =\n nextValues.find((value) => !previousValues.includes(value)) ??\n previousValues.find((value) => !nextValues.includes(value))\n\n if (!changedValue) return\n\n const isPressed = nextValues.includes(changedValue)\n\n if (changedValue === "bold") {\n applyStyle({ font: { bold: isPressed } })\n } else if (changedValue === "italic") {\n applyStyle({ font: { italic: isPressed } })\n } else if (changedValue === "underline") {\n applyStyle({ font: { underline: isPressed ? "single" : "none" } })\n } else if (changedValue === "strikethrough") {\n applyStyle({ font: { strikethrough: isPressed } })\n }\n },\n [applyStyle, fontToggleValues]\n )\n\n return (\n <div className="border-b bg-background">\n <div className="flex min-h-11 items-center justify-between gap-3 border-b px-3">\n <div className="min-w-0 flex-1" />\n <TooltipProvider>\n <div className="flex shrink-0 items-center gap-1">\n {showNightRenderToggle ? (\n <>\n <ToolbarTooltip\n label={isDark ? "Use light workbook" : "Use dark workbook"}\n >\n <Button\n type="button"\n variant="ghost"\n size="icon-sm"\n aria-label={\n isDark ? "Use light workbook" : "Use dark workbook"\n }\n onClick={() => onIsDarkChange(!isDark)}\n >\n {isDark ? (\n <Sun03Glyph className="size-4" />\n ) : (\n <Moon02Glyph className="size-4" />\n )}\n </Button>\n </ToolbarTooltip>\n <Separator\n orientation="vertical"\n className="mx-1 h-4 self-center"\n />\n </>\n ) : null}\n <EditorFileActionsMenu\n canExport={canExport}\n exportXlsx={exportXlsx}\n onUploadClick={onUploadClick}\n />\n </div>\n </TooltipProvider>\n </div>\n <TooltipProvider>\n <div className="flex min-h-12 flex-wrap items-center gap-2 border-b bg-background px-3 py-2">\n <div className="flex shrink-0 items-center gap-1">\n <ToolbarTooltip label="Undo">\n <Button\n type="button"\n variant="ghost"\n size="icon-sm"\n aria-label="Undo"\n disabled={!canUndo || readOnly}\n onClick={undo}\n >\n <IconPlaceholder\n lucide="Undo2"\n tabler="IconArrowBackUp"\n hugeicons="Undo02Icon"\n phosphor="ArrowUUpLeftIcon"\n remixicon="RiArrowGoBackLine"\n className="size-4"\n />\n </Button>\n </ToolbarTooltip>\n <ToolbarTooltip label="Redo">\n <Button\n type="button"\n variant="ghost"\n size="icon-sm"\n aria-label="Redo"\n disabled={!canRedo || readOnly}\n onClick={redo}\n >\n <IconPlaceholder\n lucide="Redo2"\n tabler="IconArrowForwardUp"\n hugeicons="Redo02Icon"\n phosphor="ArrowUUpRightIcon"\n remixicon="RiArrowGoForwardLine"\n className="size-4"\n />\n </Button>\n </ToolbarTooltip>\n </div>\n <ToolbarSeparator />\n <div className="flex shrink-0 items-center gap-1">\n <Select\n value={fontFamilyValue}\n onValueChange={(value) => {\n if (!value) return\n\n if (applyStyle({ font: { name: value } })) {\n setFontFamily(value)\n }\n }}\n disabled={!canStyleSelection}\n modal={false}\n >\n <SelectTrigger\n size="sm"\n className={cn(\n "w-[132px] min-w-[132px]",\n XLSX_EDITOR_SELECT_CHROME_CLASS\n )}\n aria-label="Font family"\n >\n <SelectValue placeholder="Font">{fontFamilyValue}</SelectValue>\n </SelectTrigger>\n <SelectContent\n align="start"\n alignItemWithTrigger={false}\n className={XLSX_DROPDOWN_Z_INDEX_CLASS}\n >\n {FONT_FAMILIES.map((option) => (\n <SelectItem key={option} value={option}>\n <span style={{ fontFamily: option }}>{option}</span>\n </SelectItem>\n ))}\n </SelectContent>\n </Select>\n <Select\n value={String(fontSize)}\n onValueChange={(value) => {\n const nextFontSize = Number(value)\n if (!Number.isFinite(nextFontSize)) return\n\n setFontSize(nextFontSize)\n applyStyle({ font: { size: nextFontSize } })\n }}\n disabled={!canStyleSelection}\n modal={false}\n >\n <SelectTrigger\n size="sm"\n className={cn(\n "w-[78px] min-w-[78px]",\n XLSX_EDITOR_SELECT_CHROME_CLASS\n )}\n aria-label="Font size"\n >\n <SelectValue placeholder="Size" />\n </SelectTrigger>\n <SelectContent\n align="start"\n alignItemWithTrigger={false}\n className={XLSX_DROPDOWN_Z_INDEX_CLASS}\n >\n {FONT_SIZE_OPTIONS.map((size) => (\n <SelectItem key={size} value={String(size)}>\n {size} pt\n </SelectItem>\n ))}\n </SelectContent>\n </Select>\n </div>\n <ToolbarSeparator />\n <ToggleGroup\n className="shrink-0"\n disabled={!canStyleSelection}\n multiple\n spacing="default"\n value={fontToggleValues}\n onValueChange={(value) =>\n applyFontToggleValues(value as XlsxFontToggleValue[])\n }\n >\n <ToolbarTooltip label="Bold">\n <ToggleGroupItem aria-label="Bold" size="sm" value="bold">\n <IconPlaceholder\n lucide="Bold"\n tabler="IconBold"\n hugeicons="TextBoldIcon"\n phosphor="TextBIcon"\n remixicon="RiBold"\n className="size-4"\n />\n </ToggleGroupItem>\n </ToolbarTooltip>\n <ToolbarTooltip label="Italic">\n <ToggleGroupItem aria-label="Italic" size="sm" value="italic">\n <IconPlaceholder\n lucide="Italic"\n tabler="IconItalic"\n hugeicons="TextItalicIcon"\n phosphor="TextItalicIcon"\n remixicon="RiItalic"\n className="size-4"\n />\n </ToggleGroupItem>\n </ToolbarTooltip>\n <ToolbarTooltip label="Underline">\n <ToggleGroupItem\n aria-label="Underline"\n size="sm"\n value="underline"\n >\n <IconPlaceholder\n lucide="Underline"\n tabler="IconUnderline"\n hugeicons="TextUnderlineIcon"\n phosphor="TextUnderlineIcon"\n remixicon="RiUnderline"\n className="size-4"\n />\n </ToggleGroupItem>\n </ToolbarTooltip>\n <ToolbarTooltip label="Strikethrough">\n <ToggleGroupItem\n aria-label="Strikethrough"\n size="sm"\n value="strikethrough"\n >\n <IconPlaceholder\n lucide="Strikethrough"\n tabler="IconStrikethrough"\n hugeicons="TextStrikethroughIcon"\n phosphor="TextStrikethroughIcon"\n remixicon="RiStrikethrough"\n className="size-4"\n />\n </ToggleGroupItem>\n </ToolbarTooltip>\n </ToggleGroup>\n <ToolbarSeparator />\n <div className="flex shrink-0 items-center gap-1">\n <ColorPicker\n label="Text color"\n icon={TextColorGlyph}\n color={textColor}\n disabled={!canStyleSelection}\n onChange={(color) => {\n const nextColor = normalizeHexColor(color)\n setTextColor(nextColor)\n applyStyle({ font: { color: toXlsxRgbColor(nextColor) } })\n }}\n />\n <ColorPicker\n label="Fill color"\n icon={PaintBucketGlyph}\n color={fillColor}\n disabled={!canStyleSelection}\n onChange={(color) => {\n const nextColor = normalizeHexColor(color, DEFAULT_FILL_COLOR)\n setFillColor(nextColor)\n applyStyle({\n fill: {\n color: toXlsxRgbColor(nextColor),\n fillType: "solid",\n },\n })\n }}\n />\n <ToolbarIconButton\n label="No fill"\n disabled={!canStyleSelection}\n onClick={() => applyStyle({ fill: { fillType: "none" } })}\n >\n <IconPlaceholder\n lucide="DropletOff"\n tabler="IconDropletOff"\n hugeicons="DropletOffIcon"\n phosphor="DropSlashIcon"\n remixicon="RiDropLine"\n className="size-4"\n />\n </ToolbarIconButton>\n </div>\n <ToolbarSeparator />\n <div className="flex shrink-0 items-center gap-1">\n <ToggleGroup\n className="shrink-0"\n disabled={!canStyleSelection}\n spacing="default"\n value={horizontalAlignmentValue}\n >\n <ToolbarTooltip label="Align left">\n <ToggleGroupItem\n aria-label="Align left"\n size="sm"\n value="left"\n onClick={() => applyHorizontalAlignment("left")}\n >\n <IconPlaceholder\n lucide="AlignLeft"\n tabler="IconAlignLeft"\n hugeicons="TextAlignLeft01Icon"\n phosphor="TextAlignLeftIcon"\n remixicon="RiAlignLeft"\n className="size-4"\n />\n </ToggleGroupItem>\n </ToolbarTooltip>\n <ToolbarTooltip label="Align center">\n <ToggleGroupItem\n aria-label="Align center"\n size="sm"\n value="center"\n onClick={() => applyHorizontalAlignment("center")}\n >\n <IconPlaceholder\n lucide="AlignCenter"\n tabler="IconAlignCenter"\n hugeicons="TextAlignCenterIcon"\n phosphor="TextAlignCenterIcon"\n remixicon="RiAlignCenter"\n className="size-4"\n />\n </ToggleGroupItem>\n </ToolbarTooltip>\n <ToolbarTooltip label="Align right">\n <ToggleGroupItem\n aria-label="Align right"\n size="sm"\n value="right"\n onClick={() => applyHorizontalAlignment("right")}\n >\n <IconPlaceholder\n lucide="AlignRight"\n tabler="IconAlignRight"\n hugeicons="TextAlignRight01Icon"\n phosphor="TextAlignRightIcon"\n remixicon="RiAlignRight"\n className="size-4"\n />\n </ToggleGroupItem>\n </ToolbarTooltip>\n </ToggleGroup>\n <ToggleGroup\n className="shrink-0"\n disabled={!canStyleSelection}\n spacing="default"\n value={verticalAlignmentValue}\n >\n <ToolbarTooltip label="Align top">\n <ToggleGroupItem\n aria-label="Align top"\n size="sm"\n value="top"\n onClick={() => applyVerticalAlignment("top")}\n >\n <IconPlaceholder\n lucide="AlignVerticalJustifyStart"\n tabler="IconAlignBoxTopCenter"\n hugeicons="AlignBoxTopCenterIcon"\n phosphor="AlignTopIcon"\n remixicon="RiAlignTop"\n className="size-4"\n />\n </ToggleGroupItem>\n </ToolbarTooltip>\n <ToolbarTooltip label="Align middle">\n <ToggleGroupItem\n aria-label="Align middle"\n size="sm"\n value="center"\n onClick={() => applyVerticalAlignment("center")}\n >\n <IconPlaceholder\n lucide="AlignVerticalJustifyCenter"\n tabler="IconAlignBoxCenterMiddle"\n hugeicons="AlignBoxMiddleCenterIcon"\n phosphor="AlignCenterVerticalIcon"\n remixicon="RiAlignVertically"\n className="size-4"\n />\n </ToggleGroupItem>\n </ToolbarTooltip>\n <ToolbarTooltip label="Align bottom">\n <ToggleGroupItem\n aria-label="Align bottom"\n size="sm"\n value="bottom"\n onClick={() => applyVerticalAlignment("bottom")}\n >\n <IconPlaceholder\n lucide="AlignVerticalJustifyEnd"\n tabler="IconAlignBoxBottomCenter"\n hugeicons="AlignBoxBottomCenterIcon"\n phosphor="AlignBottomIcon"\n remixicon="RiAlignBottom"\n className="size-4"\n />\n </ToggleGroupItem>\n </ToolbarTooltip>\n </ToggleGroup>\n <ToolbarIconButton\n label="Wrap text"\n disabled={!canStyleSelection}\n onClick={() => applyStyle({ alignment: { wrapText: true } })}\n >\n <IconPlaceholder\n lucide="WrapText"\n tabler="IconTextWrap"\n hugeicons="TextWrapIcon"\n phosphor="ArrowElbowDownLeftIcon"\n remixicon="RiTextWrap"\n className="size-4"\n />\n </ToolbarIconButton>\n <AlignmentMoreMenu\n disabled={!canStyleSelection}\n onApplyStyle={applyStyle}\n />\n </div>\n <ToolbarSeparator />\n <div className="flex shrink-0 items-center gap-1">\n <NumberFormatSelect\n disabled={!canStyleSelection}\n onApplyStyle={applyStyle}\n value={numberFormatValue}\n />\n <BorderMenu\n borderColor={borderColor}\n disabled={!canStyleSelection}\n onApplyBorder={applyBorderAction}\n onBorderColorChange={setBorderColor}\n />\n </div>\n <ToolbarSeparator />\n <div className="flex shrink-0 items-center gap-1">\n <MergeCellsMenu\n canMerge={canMergeSelectedCells}\n canMergeAcross={canMergeAcross}\n canUnmerge={canUnmergeSelectedCells}\n disabled={!hasSelection || readOnly}\n isMerged={selectionIntersectsMerge}\n onMergeAcross={mergeAcrossSelectedCells}\n onMergeAndCenter={mergeAndCenterSelectedCells}\n onMergeCells={mergeSelectedCells}\n onUnmergeCells={unmergeSelectedCells}\n />\n </div>\n <ToolbarSeparator />\n <div className="flex shrink-0 items-center gap-1">\n <ToolbarTooltip label="Add sheet">\n <Button\n type="button"\n variant="ghost"\n size="icon-sm"\n aria-label="Add sheet"\n disabled={!hasWorkbook || readOnly}\n onClick={() => addSheet()}\n >\n <IconPlaceholder\n lucide="Plus"\n tabler="IconPlus"\n hugeicons="Add01Icon"\n phosphor="PlusIcon"\n remixicon="RiAddLine"\n className="size-4"\n />\n </Button>\n </ToolbarTooltip>\n <ToolbarTooltip label="Remove active sheet">\n <Button\n type="button"\n variant="ghost"\n size="icon-sm"\n aria-label="Remove active sheet"\n disabled={sheets.length <= 1 || readOnly}\n onClick={removeActiveSheet}\n >\n <IconPlaceholder\n lucide="Trash2Icon"\n tabler="IconTrash"\n hugeicons="Delete02Icon"\n phosphor="TrashIcon"\n remixicon="RiDeleteBinLine"\n className="size-4"\n />\n </Button>\n </ToolbarTooltip>\n <Select\n value={String(activeSheetIndex)}\n onValueChange={(value) => setActiveSheetIndex(Number(value))}\n disabled={!hasWorkbook}\n >\n <SelectTrigger\n size="sm"\n className={cn(\n "w-[150px] min-w-[150px]",\n XLSX_EDITOR_SELECT_CHROME_CLASS\n )}\n aria-label="Active sheet"\n >\n <SelectValue>{activeSheet?.name ?? "Sheet"}</SelectValue>\n </SelectTrigger>\n <SelectContent\n align="start"\n className={XLSX_DROPDOWN_Z_INDEX_CLASS}\n >\n {sheets.map((sheet, index) => (\n <SelectItem\n key={`${sheet.name}-${index}`}\n value={String(index)}\n >\n {sheet.name}\n </SelectItem>\n ))}\n </SelectContent>\n </Select>\n </div>\n <ToolbarSeparator />\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={!hasWorkbook || !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 disabled={!hasWorkbook}\n modal={false}\n >\n <SelectTrigger\n size="sm"\n className={cn(\n "w-[84px] min-w-[84px]",\n XLSX_EDITOR_SELECT_CHROME_CLASS\n )}\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={!hasWorkbook || !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 </div>\n <div className="border-t bg-background px-2 py-1">\n <Group className="w-full">\n <Input\n className={cn(\n "h-8 w-[92px] shrink-0 font-mono text-xs",\n XLSX_EDITOR_FORMULA_INPUT_CHROME_CLASS\n )}\n readOnly\n value={activeCellAddress ?? ""}\n />\n <GroupSeparator />\n <GroupText className="h-8 w-9 shrink-0 justify-center px-0 text-[11px] font-semibold italic">\n fx\n </GroupText>\n <GroupSeparator />\n <Input\n className={cn(\n "h-8 flex-1",\n XLSX_EDITOR_FORMULA_INPUT_CHROME_CLASS\n )}\n disabled={!hasActiveCell || readOnly}\n value={formulaFocused ? formulaDraft : selectedCellInputValue}\n onBlur={() => {\n commitFormula()\n setFormulaFocused(false)\n }}\n onChange={(event) => setFormulaDraft(event.target.value)}\n onFocus={() => {\n formulaEditCellRef.current = activeCell\n formulaInitialValueRef.current = selectedCellInputValue\n setFormulaDraft(selectedCellInputValue)\n setFormulaFocused(true)\n }}\n onKeyDown={(event) => {\n if (event.key === "Enter") {\n event.preventDefault()\n commitFormula()\n setFormulaFocused(false)\n }\n }}\n placeholder="Select a cell, then enter a value or formula"\n />\n </Group>\n </div>\n </TooltipProvider>\n </div>\n )\n}\n\nexport function XlsxEditorSurface({\n className,\n isDark,\n onIsDarkChange,\n onUploadClick,\n renderTableHeaderMenu,\n showNightRenderToggle,\n workbookIdentity,\n}: {\n className?: string\n isDark: boolean\n onIsDarkChange: (checked: boolean) => void\n onUploadClick: () => void\n renderTableHeaderMenu: (\n props: XlsxTableHeaderMenuRenderProps\n ) => React.ReactNode\n showNightRenderToggle: boolean\n workbookIdentity: string\n}) {\n const { error } = useXlsxViewer()\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 <EditorToolbar\n isDark={isDark}\n onIsDarkChange={onIsDarkChange}\n onUploadClick={onUploadClick}\n showNightRenderToggle={showNightRenderToggle}\n workbookIdentity={workbookIdentity}\n />\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 allowResizeInReadOnly\n className="h-full min-h-0 min-w-0"\n height="100%"\n isDark={isDark}\n readOnly={false}\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 for editing</p>\n <p className="mt-1 text-muted-foreground">\n This workbook exceeds the editor limit. Download it or open\n a smaller file to make changes.\n </p>\n </div>\n </div>\n }\n loadingState={<EditorLoadingSurface />}\n renderScroller={renderXlsxScroller}\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 edit 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 XlsxEditorPreview({\n className,\n fileName,\n isDark,\n onIsDarkChange,\n src,\n}: {\n className?: string\n fileName?: string\n isDark: boolean\n onIsDarkChange: (isDark: boolean) => void\n src?: string\n}) {\n return (\n <XlsxEditorContent\n key={src}\n className={className}\n effectiveIsDark={isDark}\n fileName={fileName}\n setNightRenderEnabled={onIsDarkChange}\n shouldRenderNightMode\n url={src}\n />\n )\n}\n\nfunction XlsxEditorContent({\n className,\n effectiveIsDark,\n fileName,\n setNightRenderEnabled,\n shouldRenderNightMode,\n url,\n}: {\n className?: string\n effectiveIsDark: boolean\n fileName?: string\n setNightRenderEnabled: (checked: boolean) => void\n shouldRenderNightMode: boolean\n url?: string\n}) {\n const fileInputRef = React.useRef<HTMLInputElement>(null)\n const [uploadedWorkbook, setUploadedWorkbook] =\n React.useState<UploadedWorkbook | null>(null)\n const [workbookBuffer, setWorkbookBuffer] =\n React.useState<ArrayBuffer | null>(null)\n const [loadError, setLoadError] = React.useState<string>()\n const sourceFileName = React.useMemo(\n () =>\n url ? formatWorkbookName(fileName, url) : (fileName ?? "workbook.xlsx"),\n [fileName, url]\n )\n const displayFileName = uploadedWorkbook?.fileName ?? sourceFileName\n const workbookIdentity =\n uploadedWorkbook?.identity ?? `${url ?? "empty"}::${displayFileName}`\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 setWorkbookBuffer(null)\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\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 <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 edit</p>\n <p className="mt-1 text-muted-foreground">\n Pass an XLSX URL with the <code>src</code> prop or upload a local\n 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 <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 edit 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 <EditorLoadingSurface 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 <XlsxWorkbookLoadedEditor\n fileName={displayFileName}\n isDark={effectiveIsDark}\n onIsDarkChange={setNightRenderEnabled}\n onUploadClick={() => fileInputRef.current?.click()}\n renderTableHeaderMenu={(props) => (\n <WorkbookTableHeaderMenu {...props} />\n )}\n showNightRenderToggle={shouldRenderNightMode}\n workbookBuffer={activeBuffer}\n workbookIdentity={workbookIdentity}\n />\n </div>\n )\n}\n\nfunction XlsxWorkbookLoadedEditor({\n fileName,\n isDark,\n onIsDarkChange,\n onUploadClick,\n renderTableHeaderMenu,\n showNightRenderToggle,\n workbookBuffer,\n workbookIdentity,\n}: {\n fileName: string\n isDark: boolean\n onIsDarkChange: (checked: boolean) => void\n onUploadClick: () => void\n renderTableHeaderMenu: (\n props: XlsxTableHeaderMenuRenderProps\n ) => React.ReactNode\n showNightRenderToggle: boolean\n workbookBuffer: ArrayBuffer\n workbookIdentity: string\n}) {\n const controller = useXlsxViewerController(\n React.useMemo(\n () => ({\n allowResizeInReadOnly: true,\n file: workbookBuffer,\n fileName,\n readOnly: false,\n readOnlyAboveBytes: XLSX_EDITOR_READ_ONLY_THRESHOLD_BYTES,\n useWorker: true,\n }),\n [fileName, workbookBuffer]\n )\n )\n\n return (\n <XlsxViewerProvider controller={controller} isDark={isDark}>\n <XlsxEditorSurface\n isDark={isDark}\n onIsDarkChange={onIsDarkChange}\n onUploadClick={onUploadClick}\n renderTableHeaderMenu={renderTableHeaderMenu}\n showNightRenderToggle={showNightRenderToggle}\n workbookIdentity={workbookIdentity}\n />\n </XlsxViewerProvider>\n )\n}\n'
export function XlsxEditorSource() {
return (
<DocsSourceCodeBlock
code={xlsxEditorSourceCode}
fileName="components/extend/xlsx-editor.tsx"
/>
)
}