Menu

Building a Browser-Based Excel Editor with Next.js and Univer
📰

Building a Browser-Based Excel Editor with Next.js and Univer

DEV Community: nextjs·yixiang xiao·8 days ago
#1cHl6FQK
#devtonextjs#devto#dev#workbook#editor
Reading 0:00
15s threshold

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…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.