excel-utils

Some utilities if you're lucky enough to be programmatically working with spreadsheets.

Installation

node

npm install excel-utils

API

encodeColumn(column: string)

Returns the alphabetic column as a number. Useful for incrementing columns.

import {encodeColumn} from 'excel-utils';
 
encodeColumn('AA'); // => 27

decodedColumn(column: number)

Turns the numerically encoded column back in to the alphabetic representation.

import {decodeColumn} from 'excel-utils';
 
encodeColumn(27); // => 'AA'

Development

git clone https://github.com/darrinholst/excel-utils
cd excel-utils
npm install
npm test

Release

release-it [semver]