SpreadsheetJS React Component

SpreadsheetJS React is one of the library of React Component with ease to use in any React project and will not break a project

Documentation

Basic Usage

without passing any properties, it will generate sample spreadsheet

import { Spreadsheet } from "spreadsheetjs-react"

const YourParentComponent = () => {
  return (
    <Spreadsheet />
  )
}
export default YourParentComponent

To pass spreadsheet properties, it must be passed all the required properties including

cells: data in each cell,

rows_height: height of each row,

cols_width: width of each column

merged_cells: all merged cells

Example of empty 2x2 spreadsheet

import { Spreadsheet } from "spreadsheetjs-react"

const YourParentComponent = () => {
  return (
    <Spreadsheet spreadsheet={
        cells: [
            [
                {
                    value: "",
                },
                {
                    value: "",
                },
            ], [
                {
                    value: "",
                },
                {
                    value: "",
                },
            ],
        ],
        rows_height: [50, 50],
        cols_width: [100, 100],
        merged_cells: []
    } />
  )
}

Props

cells: Array[][]

cell.value: String value of this cell

cell.style: style of this cell

License

Licensed under the terms of the MIT License.

Roadmap

v1.x Features

v1.0.x

Merge Cells

Style

Resize

Delete Row & Column

Insert Row & Column

v2.x Features

Due to my bad design reason cause delete and insert features hassles, v1 will be deprecated but it still usable except those features

v2.0.x

Merge Cells

Style

Resize

Delete Row & Column

Insert Row & Column

Rotate Cell

v3.x Features

Entirely depend on speedysheet to port to other web framework

v3.0.x

Speedysheet Integration