A1 notation

About

This library is for working with A1 notations such as "A1" or "A1:B2". The library is exported as a UMD module.

Install

npm i @segment/a1-notation -d

Or

yarn add @segment/a1-notation

Download

ESNext.min(5 KB), UMD(22 KB)

What is the difference?

• converter 1 or converter 2? The difference is in the algorithm of convertation. You can compare the first method with the second method.
• "ES5" or "ESNext"? ES5 has already converted to ES5 standard with all needed polyfills. ESNext uses the original syntax of the code.
• "UMD"? UMD - Unified Module Definition, more in Google.
• ".min"? Minified version.
• Default version in npm is UMD ESNext. This version is not transpiled and minified, so you need to transpile and minify it.

Initialization

import A1 from '@segment/a1-notation';
// or
const A1 = require('@segment/a1-notation');

API

Note: A1 string could be represented in any register. A1 === a1, A1:B2 === a1:b2 === A1:b2 === a1:B2

• static isValid(a1: string): boolean
• static getCol(a1: string, converter: 1 | 2 = 1): number
• static getLastCol(a1: string, converter: 1 | 2 = 1): number
• static getRow(a1: string): number
• static getLastRow(a1: string): number
• static getWidth(a1: string, converter: 1 | 2 = 1): number
• static getHeight(a1: string): number
• static toCol(col: number): string
• static toRow(row: number): string
• constructor
• get(): string
• toString(): string
• toJSON(): result
• getCol(): number
• getLastCol(): number
• getRow(): number
• getLastRow(): number
• getWidth(): number
• getHeight(): number
• setCol(val: string | number): this
• setLastCol(val: string | number): this
• setRow(val: string | number): this
• setLastRow(val: string | number): this
• copy(): A1
• addX(count: number): this
• addY(count: number): this
• add(countX: number, countY: number): this
• removeX(count: number): this
• removeY(count: number): this
• remove(countX: number, countY: number): this
• shiftX(offset: number): this
• shiftY(offset: number): this
• shift(offsetX: number, offsetY: number): this

License

MIT

Changelog

The latest updates