/excel-utils

utils...for excel...maybe

Primary LanguageTypeScriptMIT LicenseMIT

excel-utils

npm-version Build Status dependencies dev dependencies peer dependencies

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]