AFNum

Introduction

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.

See wiki for API documentation.

Installation

AFNum is available as an npm package. Simpy, install with

npm install afnum

Testing

An extensive suite of tests is can be viewed at spec/afnum_spec.js. You can run the tests in node with:

npm test

or in the browser, by GET'ing spec/runner.html.