# @shogo82148/a1notation@0.2.1Built and signed on GitHub ActionsBuilt and signed on GitHub Actions

Built and signed on GitHub Actions

latest

shogo82148/a1notationparse A1 Notation, commonly used in spreadsheets like Excel and Google Sheets

This package works with Cloudflare Workers, Node.js, Deno, Bun, Browsers

JSR Score

100%

Published

3 weeks ago (0.2.1)

# a1notation

This library is designed to parse A1 Notation, commonly used in spreadsheets like Excel and Google Sheets, and convert it to row and column indices. It also allows for the reverse operation, converting row and column indices back to A1 Notation.

## Usage

## Parsing A1 Notation

`import { A1Notation } from "@shogo82148/a1notation"; const a1 = A1Notation.parse("Sheet1!A1:B2"); console.log(a1.sheetName); // "Sheet1" console.log(a1.left); // 1 console.log(a1.top); // 1 console.log(a1.right); // 2 console.log(a1.bottom); // 2`

## Generating A1 Notation

`import { A1Notation } from "@shogo82148/a1notation"; const a1 = new A1Notation("Sheet1", 3, 2); console.log(`${a1}`); // Sheet1!C2`

Built and signed on

View transparency logGitHub Actions

Add Package

`deno add @shogo82148/a1notation`

Import symbol

`import * as mod from "@shogo82148/a1notation/";`

Add Package

`npx jsr add @shogo82148/a1notation`

Import symbol

`import * as mod from "@shogo82148/a1notation/";`

Add Package

`yarn dlx jsr add @shogo82148/a1notation`

Import symbol

`import * as mod from "@shogo82148/a1notation/";`

Add Package

`pnpm dlx jsr add @shogo82148/a1notation`

Import symbol

`import * as mod from "@shogo82148/a1notation/";`

Add Package

`bunx jsr add @shogo82148/a1notation`

Import symbol

`import * as mod from "@shogo82148/a1notation/";`