excel-utils
v1.0.1
Published
Some utilities if you're programmatically working with spreadsheets
Downloads
5
Readme
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]