@okitan/grid-for-sheet

utilities for google spreadsheet griddata generation

Usage no npm install needed!

<script type="module">
  import okitanGridForSheet from 'https://cdn.skypack.dev/@okitan/grid-for-sheet';
</script>

README

@okitan/grid-for-sheet

utilities for google spreadsheet griddata generation

Installation

$ npm install @okitan/grid-for-sheet

Usage

import { Grid } from "@okitan/grid-for-sheet";

const grid = new Grid({ data: [["strong", 0]] });

grid.toGridData();
/* returns
{
  rowData: [
    { values: [
      {
        userEnteredValue: { stringValue: "strong" }
      },
      {
        userEnteredValue: { numberValue: 0 }
      }
    ]}
  ]
}
 */

More usage: tests/grid.test.ts.

Terminology

     A     B     C     D
1 |     | C1  | C2  |     | ← columnHeader
2 |     | SUM | SUM | SOS | ← columnTotalHeader
3 | R1  |     |     | SUM |
4 | R2  |     |     | SUM |
    ↑ rowHeader        ↑ rowTotal
  • columnHeader
    • activated by column.showHeader
  • columnTotalHeader
    • activated by sum.column
  • rowHeader
    • activated by row.showHeader
  • rowTotal
    • activated by sum.row

Labels

On the upper table, these cells can be set by labels.

  • gridLable(A1)
    • set label, but only shown when rowHeader and columnHeader are present
  • rowTotalLabel(D1)
    • set sum.row.label, but only shown when rowTotal and columnHeader are present
  • columnTotalHeaderLabel(A2)
    • set sum.column.label, but only shown when rowHeader and columnTotalHeader are present