Opening a spreadsheet, fixing a few cells, and downloading the result sounds like a small task. Building a browser application that handles that workflow involves more than putting an editable grid on a page.
An Excel workbook carries formulas, formatting, merged cells, multiple sheets, and sometimes charts or pivot tables. Those details need to survive the trip through the editor.
I'm building Workbook Editor , a browser-based spreadsheet editor built with Next.js, React, and Univer. This article covers three parts of its implementation: file conversion, loading the editor, and recovering local work.
The architecture: separate the grid from the file format
The project gives different libraries different jobs:
Layer Responsibility
Next.js and React Pages, navigation, and application UI
Univer The spreadsheet editing experience
ExcelJS The main XLSX import and export path
SheetJS The XLS, CSV, and TSV conversion path
IndexedDB Local recovery snapshots and version history
Univer provides the…