excel-utils

Some utilities if you're programmatically working with spreadsheets

Usage no npm install needed!

<script type="module">
  import excelUtils from 'https://cdn.skypack.dev/excel-utils';
</script>

README

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]