Skip to content

Convert between cell reference styles (A1 notation & R1C1 notation)

License

Notifications You must be signed in to change notification settings

mike182uk/cellref

Repository files navigation

cellref

Version Build Status Coveralls npm License

Convert between cell reference styles (A1 notation & R1C1 notation).

Installation

npm install --save cellref

Usage

Convert A1 to R1C1

const cellref = require('cellref')

cellref.toR1C1('BU59') // will return R59C73

Convert R1C1 to A1

const cellref = require('cellref')

cellref.toA1('R59C73') // will return BU59

Convert automatically based on the input

const cellref = require('cellref')

cellref('R59C73') // will return BU59
cellref('BU59') // will return R59C73

If an invalid cell reference (not A1 or R1C1 notation) is passed as an argument to any of cellref functions, an Error will be thrown.

About

Convert between cell reference styles (A1 notation & R1C1 notation)

Topics

Resources

License

Stars

Watchers

Forks