4e:I[707087,["/_next/static/immutable/chunks/2985g-hklwiee.js","/_next/static/immutable/chunks/0qkc3dps_9x_i.js","/_next/static/immutable/chunks/2nvof3-29tvc3.js","/_next/static/immutable/chunks/3thksmxn95rly.js","/_next/static/immutable/chunks/15bpbjna9-vr3.js","/_next/static/immutable/chunks/3tjobt77z_9dj.js","/_next/static/immutable/chunks/0agonoz1szsjm.js","/_next/static/immutable/chunks/1ynd3dcge2kn1.js","/_next/static/immutable/chunks/0krdn-21gkgjt.js","/_next/static/immutable/chunks/0n9w9riw96l80.js","/_next/static/immutable/chunks/0w75qangey2ys.js","/_next/static/immutable/chunks/1tge7vcvsb70s.js","/_next/static/immutable/chunks/35ju_ac0ysz07.js"],"RegistryDependencies"] 4f:I[512940,["/_next/static/immutable/chunks/2985g-hklwiee.js","/_next/static/immutable/chunks/0qkc3dps_9x_i.js","/_next/static/immutable/chunks/2nvof3-29tvc3.js","/_next/static/immutable/chunks/3thksmxn95rly.js","/_next/static/immutable/chunks/15bpbjna9-vr3.js","/_next/static/immutable/chunks/3tjobt77z_9dj.js","/_next/static/immutable/chunks/0agonoz1szsjm.js","/_next/static/immutable/chunks/1ynd3dcge2kn1.js","/_next/static/immutable/chunks/0krdn-21gkgjt.js","/_next/static/immutable/chunks/0n9w9riw96l80.js","/_next/static/immutable/chunks/0w75qangey2ys.js","/_next/static/immutable/chunks/1tge7vcvsb70s.js","/_next/static/immutable/chunks/35ju_ac0ysz07.js"],"Installation"] 50:I[314491,["/_next/static/immutable/chunks/2985g-hklwiee.js","/_next/static/immutable/chunks/0qkc3dps_9x_i.js","/_next/static/immutable/chunks/2nvof3-29tvc3.js","/_next/static/immutable/chunks/3thksmxn95rly.js","/_next/static/immutable/chunks/15bpbjna9-vr3.js","/_next/static/immutable/chunks/3tjobt77z_9dj.js","/_next/static/immutable/chunks/0agonoz1szsjm.js","/_next/static/immutable/chunks/1ynd3dcge2kn1.js","/_next/static/immutable/chunks/0krdn-21gkgjt.js","/_next/static/immutable/chunks/0n9w9riw96l80.js","/_next/static/immutable/chunks/0w75qangey2ys.js","/_next/static/immutable/chunks/1tge7vcvsb70s.js","/_next/static/immutable/chunks/35ju_ac0ysz07.js"],"FilesView"] 51:T22a5,"use client"; import * as React from "react"; import { FileSpreadsheet, TableProperties } from "lucide-react"; import { cn } from "@/lib/utils"; import { CsvViewerDocument } from "@/components/ui/csv-viewer"; import { FileViewer, FileViewerContent, FileViewerControls, FileViewerHeader, FileViewerInset, FileViewerProvider, FileViewerSidebar, FileViewerSidebarContent, FileViewerSidebarTrigger, FileViewerTitle, FileViewerViewport, } from "@/components/ui/file-viewer"; import { XlsxViewer } from "@/components/ui/xlsx-viewer"; import { SEGMENT_PALETTE } from "@/lib/segments"; import csvOutputs from "@/components/viewers/sample-data/excel-splitting.json"; const WORKBOOK_ID = "workbook"; const WORKBOOK_NAME = "nvidia-financials-fy2024.xlsx"; const XLSX_URL = "/samples/nvidia-financials-fy2024.xlsx"; const WORKBOOK_SOURCE = { kind: "url" as const, url: XLSX_URL, fileName: WORKBOOK_NAME, }; type CsvId = keyof typeof csvOutputs; /** * One CSV the Excel splitter emitted. `sheetLabel` is the workbook sheet it was * carved from; `enrichment` is the reconstruction step that turned that raw * sheet into a clean, partition-ready table. The CSV text itself lives in the * sample-data JSON, keyed by `id`. */ type CsvOutput = { id: CsvId; fileName: string; sheetLabel: string; enrichment: string; }; const CSV_OUTPUTS: CsvOutput[] = [ { id: "income-statement", fileName: "income-statement.csv", sheetLabel: "Consolidated Statements of Income", enrichment: "Period columns flattened to one header", }, { id: "comprehensive-income", fileName: "comprehensive-income.csv", sheetLabel: "Consolidated Statements of Comprehensive Income", enrichment: "Section banners kept as label rows", }, { id: "balance-sheet", fileName: "balance-sheet.csv", sheetLabel: "Consolidated Balance Sheets", enrichment: "Merged title cell dropped", }, { id: "shareholders-equity", fileName: "shareholders-equity.csv", sheetLabel: "Consolidated Statements of Shareholders' Equity", enrichment: "Equity-component matrix melted to columns", }, { id: "cash-flows", fileName: "cash-flows.csv", sheetLabel: "Consolidated Statements of Cash Flows", enrichment: "Blank filler cells cleared", }, ]; // Stable {kind:"text"} source per CSV so selecting one swaps the document // without re-creating the viewer resource on every render. const CSV_SOURCE_BY_ID = new Map( CSV_OUTPUTS.map((output) => [ output.id, { kind: "text" as const, text: csvOutputs[output.id], fileName: output.fileName, }, ]), ); function csvShape(id: CsvId) { const lines = csvOutputs[id].split("\n"); return { rows: lines.length, cols: lines[0]?.split(",").length ?? 0 }; } function outputColor(index: number) { return SEGMENT_PALETTE[index % SEGMENT_PALETTE.length]; } /** * Excel splitting block — one Excel workbook fanned out into several clean CSVs. * A left sidebar lists the source workbook first, then every CSV the splitter * emitted. Selecting an entry swaps the main viewer to that document: the XLSX * viewer for the workbook, the CSV viewer for each output. */ export function ExcelSplittingViewerBlock() { const [activeId, setActiveId] = React.useState(WORKBOOK_ID); const isWorkbook = activeId === WORKBOOK_ID; const activeSource = isWorkbook ? WORKBOOK_SOURCE : CSV_SOURCE_BY_ID.get(activeId as CsvId)!; return (

Split output

Source workbook → {CSV_OUTPUTS.length} CSVs

setActiveId(WORKBOOK_ID)} />
Reconstructed CSVs
setActiveId(output.id)} />

{isWorkbook ? ( ) : ( )} ); } /** The source workbook — the first sidebar entry. */ function WorkbookRow({ active, onSelect, }: { active: boolean; onSelect: () => void; }) { return ( ); } /** One reconstructed CSV in the sidebar. */ function CsvOutputRow({ output, color, rows, cols, active, onSelect, }: { output: CsvOutput; color: string; rows: number; cols: number; active: boolean; onSelect: () => void; }) { return ( ); } 52:T1fe5,{ "income-statement": "Line item,\"Jan 28, 2024\",\"Jan 29, 2023\",\"Jan 30, 2022\"\nIncome Statement [Abstract],,,\nRevenue,60922,26974,26914\nCost of revenue,16621,11618,9439\nGross profit,44301,15356,17475\nOperating expenses,,,\nResearch and development,8675,7339,5268\n\"Sales, general and administrative\",2654,2440,2166\nAcquisition termination cost,0,1353,0\nTotal operating expenses,11329,11132,7434\nOperating income,32972,4224,10041\nInterest income,866,267,29\nInterest expense,-257,-262,-236\n\"Other, net\",237,-48,107\n\"Other income (expense), net\",846,-43,-100\nIncome before income tax,33818,4181,9941\nIncome tax expense (benefit),4058,-187,189\nNet income,29760,4368,9752\nNet income per share:,,,\nBasic (in USD per share),12.05,1.76,3.91\nDiluted (in USD per share),11.93,1.74,3.85\nWeighted average shares used in per share computation:,,,\nBasic (in shares),2469,2487,2496\nDiluted (in shares),2494,2507,2535", "comprehensive-income": "Line item,\"Jan 28, 2024\",\"Jan 29, 2023\",\"Jan 30, 2022\"\nStatement of Comprehensive Income [Abstract],,,\nNet income,29760,4368,9752\nAvailable-for-sale securities:,,,\nNet change in unrealized gain (loss),80,-31,-16\nReclassification adjustments for net realized gain included in net income,0,1,0\nNet change in unrealized gain (loss),80,-30,-16\nCash flow hedges:,,,\nNet change in unrealized gain (loss),38,47,-43\nReclassification adjustments for net realized gain (loss) included in net income,-48,-49,29\nNet change in unrealized loss,-10,-2,-14\n\"Other comprehensive income (loss), net of tax\",70,-32,-30\nTotal comprehensive income,29830,4336,9722", "balance-sheet": "Line item,\"Jan 28, 2024\",\"Jan 29, 2023\"\nCurrent assets:,,\nCash and cash equivalents,7280,3389\nMarketable securities,18704,9907\n\"Accounts receivable, net\",9999,3827\nInventories,5282,5159\nPrepaid expenses and other current assets,3080,791\nTotal current assets,44345,23073\n\"Property and equipment, net\",3914,3807\nOperating lease assets,1346,1038\nGoodwill,4430,4372\n\"Intangible assets, net\",1112,1676\nDeferred income tax assets,6081,3396\nOther assets,4500,3820\nTotal assets,65728,41182\nCurrent liabilities:,,\nAccounts payable,2699,1193\nAccrued and other current liabilities,6682,4120\nShort-term debt,1250,1250\nTotal current liabilities,10631,6563\nLong-term debt,8459,9703\nLong-term operating lease liabilities,1119,902\nOther long-term liabilities,2541,1913\nTotal liabilities,22750,19081\nCommitments and contingencies - see Note 13,,\nShareholders’ equity:,,\n\"Preferred stock, $0.001 par value; 2 shares authorized; none issued\",0,0\n\"Common stock, $0.001 par value; 8,000 shares authorized; 2,464 shares issued and outstanding as of January 28, 2024; 2,466 shares issued and outstanding as of January 29, 2023\",2,2\nAdditional paid-in capital,13132,11971\nAccumulated other comprehensive income (loss),27,-43\nRetained earnings,29817,10171\nTotal shareholders' equity,42978,22101\nTotal liabilities and shareholders' equity,65728,41182", "shareholders-equity": "Line item,Total,Common Stock Outstanding,Additional Paid-in Capital,Treasury Stock,Accumulated Other Comprehensive Income (Loss),Retained Earnings\n\"Beginning balance, common stock outstanding (in shares) at Jan. 31, 2021\",,2479,,,,\n\"Beginning balances, shareholders' equity at Jan. 31, 2021\",16893,3,8719,-10756,19,18908\nIncrease (Decrease) in Shareholders' Equity,,,,,,\nNet income,9752,,,,,9752\nOther comprehensive (loss) income,-30,,,,-30,\nIssuance of common stock from stock plans (in shares),,35,,,,\nIssuance of common stock from stock plans,281,,281,,,\nTax withholding related to vesting of restricted stock units (in shares),,-8,,,,\nTax withholding related to vesting of restricted stock units,-1904,,-614,-1290,,\nCash dividends declared and paid,-399,,,,,-399\nFair value of partially vested equity awards assumed in connection with acquisitions,18,,18,,,\nStock-based compensation,2001,,2001,,,\nRetirement of Treasury Stock,0,,-20,12046,,-12026\n\"Ending balance, common stock outstanding (in shares) at Jan. 30, 2022\",,2506,,,,\n\"Ending balances, shareholders' equity at Jan. 30, 2022\",26612,3,10385,0,-11,16235\nIncrease (Decrease) in Shareholders' Equity,,,,,,\nCash dividends declared and paid (USD per common share),0.16,,,,,\nNet income,4368,,,,,4368\nOther comprehensive (loss) income,-32,,,,-32,\nIssuance of common stock from stock plans (in shares),,31,,,,\nIssuance of common stock from stock plans,355,,355,,,\nTax withholding related to vesting of restricted stock units (in shares),,-8,,,,\nTax withholding related to vesting of restricted stock units,-1475,,-1475,,,\nShare repurchased (in shares),,-63,,,,\nShares repurchased,-10039,-1,-4,,,-10034\nCash dividends declared and paid,-398,,,,,-398\nStock-based compensation,2710,,2710,,,\n\"Ending balance, common stock outstanding (in shares) at Jan. 29, 2023\",2466,2466,,,,\n\"Ending balances, shareholders' equity at Jan. 29, 2023\",22101,2,11971,0,-43,10171\nIncrease (Decrease) in Shareholders' Equity,,,,,,\nCash dividends declared and paid (USD per common share),0.16,,,,,\nNet income,29760,,,,,29760\nOther comprehensive (loss) income,70,,,,70,\nIssuance of common stock from stock plans (in shares),,26,,,,\nIssuance of common stock from stock plans,403,,403,,,\nTax withholding related to vesting of restricted stock units (in shares),,-7,,,,\nTax withholding related to vesting of restricted stock units,-2783,,-2783,,,\nShare repurchased (in shares),-21,-21,,,,\nShares repurchased,-9746,,-27,,,-9719\nCash dividends declared and paid,-395,,,,,-395\nStock-based compensation,3568,,3568,,,\n\"Ending balance, common stock outstanding (in shares) at Jan. 28, 2024\",2464,2464,,,,\n\"Ending balances, shareholders' equity at Jan. 28, 2024\",42978,2,13132,0,27,29817\nIncrease (Decrease) in Shareholders' Equity,,,,,,\nCash dividends declared and paid (USD per common share),0.16,,,,,", "cash-flows": "Line item,\"Jan 28, 2024\",\"Jan 29, 2023\",\"Jan 30, 2022\"\nCash flows from operating activities:,,,\nNet income,29760,4368,9752\nAdjustments to reconcile net income to net cash provided by operating activities:,,,\nStock-based compensation expense,3549,2709,2004\nDepreciation and amortization,1508,1544,1174\nDeferred income taxes,-2489,-2164,-406\n\"(Gains) losses on investments in non-affiliated entities, net\",-238,45,-100\nAcquisition termination cost,0,1353,0\nOther,-278,-7,47\n\"Changes in operating assets and liabilities, net of acquisitions:\",,,\nAccounts receivable,-6172,822,-2215\nInventories,-98,-2554,-774\nPrepaid expenses and other assets,-1522,-1517,-1715\nAccounts payable,1531,-551,568\nAccrued and other current liabilities,2025,1341,581\nOther long-term liabilities,514,252,192\nNet cash provided by operating activities,28090,5641,9108\nCash flows from investing activities:,,,\nProceeds from maturities of marketable securities,9732,19425,15197\nProceeds from sales of marketable securities,50,1806,1023\nPurchases of marketable securities,-18211,-11897,-24787\nPurchases related to property and equipment and intangible assets,-1069,-1833,-976\n\"Acquisitions, net of cash acquired\",-83,-49,-263\n\"Investments in non-affiliated entities and other, net\",-985,-77,-24\nNet cash provided by (used in) investing activities,-10566,7375,-9830\nCash flows from financing activities:,,,\nProceeds related to employee stock plans,403,355,281\nPayments related to repurchases of common stock,-9533,-10039,0\nPayments related to tax on restricted stock units,-2783,-1475,-1904\nRepayment of debt,-1250,0,-1000\nDividends paid,-395,-398,-399\nPrincipal payments on property and equipment and intangible assets,-74,-58,-83\n\"Issuance of debt, net of issuance costs\",0,0,4977\nOther,-1,-2,-7\nNet cash provided by (used in) financing activities,-13633,-11617,1865\nChange in cash and cash equivalents,3891,1399,1143\nCash and cash equivalents at beginning of period,3389,1990,847\nCash and cash equivalents at end of period,7280,3389,1990\nSupplemental disclosures of cash flow information:,,,\n\"Cash paid for income taxes, net\",6549,1404,396\nCash paid for interest,252,254,246" } 4a:["$","div",null,{"className":"flex flex-col gap-12","children":[["$","div",null,{"className":"pt-10 flex flex-col gap-4","children":[["$","ul",null,{"className":"flex gap-2 flex-wrap","children":[["$","li","lucide-react",{"children":["$","a",null,{"href":"https://www.npmjs.com/package/lucide-react","target":"_blank","rel":"noopener noreferrer","className":"rounded-md border p-2 text-sm flex items-center gap-1 ","children":[["$","svg",null,{"viewBox":"0 0 24 24","className":"size-3","children":["$","path",null,{"d":"M1.763 0C.786 0 0 .786 0 1.763v20.474C0 23.214.786 24 1.763 24h20.474c.977 0 1.763-.786 1.763-1.763V1.763C24 .786 23.214 0 22.237 0zM5.13 5.323l13.837.019-.009 13.836h-3.464l.01-10.382h-3.456L12.04 19.17H5.113z","fill":"currentColor"}]}],["$","span",null,{"className":"text-xs font-medium","children":"lucide-react"}]]}]}]]}],["$","$L4e",null,{"registryDependencies":["@retab/file-viewer","@retab/csv-viewer","@retab/xlsx-viewer","@retab/segments"]}]]}],["$","$L4f",null,{"sourceUrl":"https://ui.retab.com/r/excel-splitting-viewer-block.json","proxyUrl":"https://shadcnregistry.com/r/retab/excel-splitting-viewer-block","itemId":"@retab/excel-splitting-viewer-block"}],["$","section",null,{"className":"flex flex-col gap-4","id":"files","children":[["$","h2",null,{"className":"text-lg md:text-2xl font-bold font-mono","children":"Files"}],["$","$L50",null,{"files":[{"path":"registry/new-york-v4/blocks/excel-splitting-viewer-block.tsx","content":"$51","type":"registry:component","target":"@components/blocks/excel-splitting-viewer-block.tsx"},{"path":"components/viewers/sample-data/excel-splitting.json","content":"$52","type":"registry:file","target":"@components/viewers/sample-data/excel-splitting.json"}]}]]}],"$L53"]}]

Excel Splitting

Installation

Files

@components

Styles