Grid Sheet React

A powerful Google Sheets-like spreadsheet editor for React with Excel import/export, formulas, cell formatting, and more.

Features

• 📊 Google Sheets-like UI - Familiar spreadsheet interface
• 📥 Excel Import/Export - Open and save .xlsx, .xls, .csv files
• 🧮 Formula Support - SUM, AVERAGE, COUNT, MIN, MAX, and basic math
• 🎨 Cell Formatting - Bold, italic, underline, alignment
• 📋 Copy/Paste - Full clipboard support with Ctrl+C/V/X
• ↩️ Undo/Redo - Full history with Ctrl+Z/Y
• 📑 Multiple Sheets - Add, rename, delete sheets
• 🖱️ Drag Selection - Select ranges like Excel
• 📈 Selection Stats - Sum, Average, Count in status bar
• ⌨️ Keyboard Navigation - Arrow keys, Tab, Enter
• 🎯 Full-screen Layout - Responsive design

Installation

npm install grid-sheet-react

Usage

import React from 'react';
import { SpreadsheetEditor } from 'grid-sheet-react';

function App() {
  return (
    <SpreadsheetEditor />
  );
}

export default App;

Props

| Prop | Type | Default | Description | |------|------|---------|-------------| | initialData | object | {} | Initial spreadsheet data | | onDataChange | function | - | Callback when data changes | | fileName | string | 'Untitled spreadsheet' | Initial file name |

Keyboard Shortcuts

| Shortcut | Action | |----------|--------| | Ctrl+Z | Undo | | Ctrl+Y | Redo | | Ctrl+C | Copy | | Ctrl+X | Cut | | Ctrl+V | Paste | | Ctrl+B | Bold | | Ctrl+I | Italic | | Ctrl+U | Underline | | Ctrl+A | Select All | | Enter | Edit cell / Move down | | Tab | Move right | | Shift+Enter | Move up | | Shift+Tab | Move left | | Delete | Clear cell(s) | | F2 | Edit cell | | Escape | Cancel edit |

Formula Support

=SUM(A1:B10)      - Sum of range
=AVERAGE(A1:B10)  - Average of range
=COUNT(A1:B10)    - Count non-empty cells
=MIN(A1:B10)      - Minimum value
=MAX(A1:B10)      - Maximum value
=A1+B1            - Add cells
=A1*B1            - Multiply cells
=A1-B1            - Subtract cells
=A1/B1            - Divide cells
=(A1+B1)*2        - Complex expressions

Peer Dependencies

• React >= 17.0.0
• React DOM >= 17.0.0

License

MIT