AFNum provides several types that can be used for spreadsheet coordinate calculation. They are:
Row - A row represents a row of cells in a spreadsheet. Its value can range from 1 to Number.MAX_SAFE_INTEGER
Column - A column represents a column of cells in a spreadsheet. Its value ranges from 'A' to 'Z', 'AA' to 'AZ', and so on.
Cell - A cell represents a cell in a spreadsheet. It consists of row and a column.
Range - A range represents a block of cells in a spreadsheet. It consists of a start and an end.
Collection - A collection represents a group of the above types.
AFNum is available as an npm package. Simpy, install with
npm install afnum
An extensive suite of tests is can be viewed at spec/afnum_spec.js. You can run the tests in node with:
or in the browser, by GET'ing spec/runner.html.