Hidden rows and columns

Any row or columns can be hidden using hiddenColumns or hiddenRows attribute in sheets

const sheets = [
  {
    name: 'Sheet 1',
    id: 1,
    hiddenRows: [2],
    hiddenColumns: [2],
    cells: {
      1: {
        1: {
          text: 200.00,
          format: '\\S$ #.00'
        }
      }
    }
  },
]

<SpreadSheet initialSheets={sheets} />

Edit this page