Excel Column Characters

Install

$ npm i excelcolumncharacters

Usage

A simple set of functions to generate character(s) like excel columns names.

Excel column name by column number

Convert a column number to corresponding excel column name.

Example

const { getColumnName } = require("excelcolumncharacters");

const columnName1 = await getColumnName(2); // returns a promise
const columnName2 = await getColumnName(26); // returns a promise
const columnName3 = await getColumnName(51); // returns a promise
const columnName4 = await getColumnName(52); // returns a promise
const columnName5 = await getColumnName(80); // returns a promise
const columnName6 = await getColumnName(676); // returns a promise
const columnName7 = await getColumnName(702); // returns a promise
const columnName8 = await getColumnName(705); // returns a promise

console.log(columnName1);
console.log(columnName2);
console.log(columnName3);
console.log(columnName4);
console.log(columnName5);
console.log(columnName6);
console.log(columnName7);
console.log(columnName8);

Output

B
Z
AY
AZ
CB
YZ
ZZ
AAC

Excel column names in array till given column number

Generate array of excel column characters till given column number.

Example

const { getColumnArray } = require("excelcolumncharacters");

const columnArray = await getColumnArray(20); // returns a promise

console.log(columnArray);

Output

[
 'A', 'B', 'C', 'D', 'E',
 'F', 'G', 'H', 'I', 'J',
 'K', 'L', 'M', 'N', 'O',
 'P', 'Q', 'R', 'S', 'T'
]

Excel column number from given column name

Convert a column name to corresponding excel column number.

Example

const { getColumnNumber } = require("excelcolumncharacters");

const columnNumber = await getColumnNumber("AAC"); // returns a promise

console.log(columnNumber);

Output

705

Excel column number from given column name

Generate array of excel column numbers from provided array of column numbers.

Example

const { getColumnNumberArray } = require("excelcolumncharacters");

const columnNumberArray = await getColumnNumberArray(["a", "aac"]); // returns a promise

console.log(columnNumberArray);

Output

[ 1, 705 ]