excel-column-name icon indicating copy to clipboard operation
excel-column-name copied to clipboard

Converts zero based index to Excel column name and back

excel-column-name Build Status

Converts one based index to Excel column name and back

Install

$ npm install --save excel-column-name

Usage

var excelColumnName = require('excel-column-name');

excelColumnName.intToExcelCol(287) == 'KA';
excelColumnName.excelColToInt('KA') == 287;

API

intToExcelCol(number)

number

Required
Type: integer

excelColToInt(columnName)

columnName

Required
Type: string