1.0.1 • Published 3 years ago
excelcolumncharacters v1.0.1
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 ]