Crate spreadsheet_column 

spreadsheet-column — convert between column numbers and letters

Convert between spreadsheet column numbers and their letter names — 1 ↔ A, 26 ↔ Z, 27 ↔ AA (the bijective base-26 used by Excel, Google Sheets, …). A faithful Rust port of the spreadsheet-column npm package.

use spreadsheet_column::{from_int, from_str};

assert_eq!(from_int(27).unwrap(), "AA");
assert_eq!(from_str("AA").unwrap(), 27);

By default columns are one-based (1 → A). Use SpreadsheetColumn::zero_based for zero-based columns (0 → A):

use spreadsheet_column::SpreadsheetColumn;

let sc = SpreadsheetColumn::zero_based();
assert_eq!(sc.from_int(0).unwrap(), "A");
assert_eq!(sc.from_str("AA").unwrap(), 26);

Zero dependencies and #![no_std].

Structs

SpreadsheetColumn

A spreadsheet column converter, optionally zero-based.

Enums

Error

An error from a column conversion.

Functions

from_int

Convert a one-based column number to its letter name (27 → "AA").

from_str

Convert a column letter name to its one-based number ("AA" → 27).