Manipulating Spreadsheet

Manipulating spreadsheets with Ruby - rspreadsheet

Note that

  • all indexes are 1-based. This applies to rows, cells cordinates, and all array like structures like list od worksheets etc. Spreadsheet world is 1-based, ruby is 0-based so I had to make a decision. I intend to make an global option for this, but in early stage I need to keep things simple.
  • with numeric coordinates row always comes before col as in (row,col)
  • with alphanumerical col always comes before row as in F12
  • Shorter syntax worksheet[x,y] returns value, longer syntax worksheet.cell(x,y) return cell objects. This allows to work conviniently with values using short syntax and access the cell object if needed (to access formatting for example).
  • Singular and plural like sheet/sheets, row/rows, cell/cells can be used intergangebly.
Written on January 7, 2023, Last update on January 7, 2023
ruby office