spreadsheet-column 0.1.0

Convert between spreadsheet column numbers and letters (1 <-> A, 27 <-> AA). A faithful port of the spreadsheet-column npm package. Zero deps, no_std.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69

# spreadsheet-column

[![All Contributors](https://img.shields.io/badge/all_contributors-1-orange.svg?style=flat-square)](#contributors-)

[![crates.io](https://img.shields.io/crates/v/spreadsheet-column.svg)](https://crates.io/crates/spreadsheet-column)
[![docs.rs](https://docs.rs/spreadsheet-column/badge.svg)](https://docs.rs/spreadsheet-column)
[![CI](https://github.com/trananhtung/spreadsheet-column/actions/workflows/ci.yml/badge.svg)](https://github.com/trananhtung/spreadsheet-column/actions/workflows/ci.yml)
[![license](https://img.shields.io/crates/l/spreadsheet-column.svg)](#license)

**Convert between spreadsheet column numbers and letters** — `1` ↔ `A`, `26` ↔ `Z`, `27` ↔
`AA` (the bijective base-26 used by Excel, Google Sheets, …).

A faithful Rust port of the
[`spreadsheet-column`](https://www.npmjs.com/package/spreadsheet-column) npm package.

- **Zero dependencies**, **`#![no_std]`**
- One-based (default) or zero-based columns
- Differential-tested against the reference `spreadsheet-column` implementation (60k cases)

## Install

```toml
[dependencies]
spreadsheet-column = "0.1"
```

## Usage

```rust
use spreadsheet_column::{from_int, from_str, SpreadsheetColumn};

assert_eq!(from_int(27).unwrap(), "AA");
assert_eq!(from_str("AA").unwrap(), 27);
assert_eq!(from_int(16384).unwrap(), "XFD"); // Excel's last column

// Zero-based columns:
let sc = SpreadsheetColumn::zero_based();
assert_eq!(sc.from_int(0).unwrap(), "A");
assert_eq!(sc.from_str("AA").unwrap(), 26);
```

In one-based mode, `from_int(0)` is an error (the smallest column is `1`); negative numbers
and non-letter strings are errors in both modes.

## Contributors ✨

This project follows the [all-contributors](https://github.com/all-contributors/all-contributors) specification. Contributions of any kind are welcome — code, docs, bug reports, ideas, reviews! See the [emoji key](https://allcontributors.org/docs/en/emoji-key) for how each contribution is recognized, and open a PR or issue to get involved.

Thanks goes to these wonderful people:

<!-- ALL-CONTRIBUTORS-LIST:START - Do not remove or modify this section -->
<!-- prettier-ignore-start -->
<!-- markdownlint-disable -->
<table>
  <tbody>
    <tr>
      <td align="center" valign="top" width="14.28%"><a href="https://github.com/trananhtung"><img src="https://avatars.githubusercontent.com/u/30992229?v=4?s=100" width="100px;" alt="Tung Tran"/><br /><sub><b>Tung Tran</b></sub></a><br /><a href="https://github.com/trananhtung/./commits?author=trananhtung" title="Code">💻</a> <a href="#maintenance-trananhtung" title="Maintenance">🚧</a></td>
    </tr>
  </tbody>
</table>

<!-- markdownlint-restore -->
<!-- prettier-ignore-end -->

<!-- ALL-CONTRIBUTORS-LIST:END -->

## License

Licensed under either of [MIT](LICENSE-MIT) or [Apache-2.0](LICENSE-APACHE) at your option.