Online Excel

online demo

Start

git clone https://github.com/nusr/excel.git
cd excel

npm i -g pnpm jscpd
pnpm i
npm run start

Directory Description

src
├── canvas         # two layer canvas
├── components     # basic components
├── containers     # spreadsheet view
│   ├── Excel      # Excel export and import
│   ├── hooks      # common React hooks
│   └── store      # global state management
├── controller     # spreadsheet controller
├── formula        # Recursive descent parser parse Excel formulas
├── i18n           # i18n
├── model          # spreadsheet model
├── theme          # dark mode
├── types          # TypeScript types
└── util           # common methods

All Dependencies

• esbulid
• react
• jszip
• chart.js
• ssf

Supported Features

• [x] Worker parse formulas
• [x] OffScreenCanvas
• [x] Undo
• [x] Redo
• [x] Copy
• [x] Cut
• [x] Paste
• [x] Formulas
• [x] Font Family
• [x] Font Size
• [x] Font Color
• [x] Fill Color
• [x] Bold
• [x] Italic
• [x] Strike
• [x] Underline
• [x] Border
• [x] Text Vertical Align
• [x] Text Horizontal Align
• [x] Text Wrapping
• [x] Number Format
• [x] Merge Cells
• [x] Chart
• [x] Floating Picture
• [x] Define Name
• [x] Insert Row
• [x] Insert Column
• [x] Delete Row
• [x] Delete Column
• [x] Hide Row
• [x] Hide Column
• [x] Row Height
• [x] Column Width
• [x] Insert Sheet
• [x] Delete Sheet
• [x] Rename Sheet
• [x] Hide Sheet
• [x] Unhide Sheet
• [x] Import XLSX
• [x] Export XLSX
• [x] Import CSV
• [x] Export CSV
• [x] Dark Mode
• [x] I18N

Supported Formulas

Math

• [x] ABS
• [x] ACOS
• [x] ACOSH
• [x] ACOT
• [x] ACOTH
• [x] ASIN
• [x] ASINH
• [x] ATAN
• [x] ATAN2
• [x] ATANH
• [x] AVERAGE
• [x] COS
• [x] COT
• [x] E
• [x] EXP
• [x] INT
• [x] PI
• [x] SIN
• [x] SUM

Text

• [x] CHAR
• [x] CODE
• [x] CONCAT
• [x] CONCATENATE
• [x] LEN
• [x] LOWER
• [x] SPLIT
• [x] T
• [x] TRIM
• [x] UNICHAR
• [x] UNICODE
• [x] UPPER