/ 
Number-Base-SpreadsheetColumn-0.001
/ Number::Base::SpreadsheetColumn

NAME

Number::Base::SpreadsheetColumn - Convert spreadsheet column name (e.g. "A", "Z", "AA") to number (e.g. 0, 25, 26) and vice versa

VERSION

This document describes version 0.001 of Number::Base::SpreadsheetColumn (from Perl distribution Number-Base-SpreadsheetColumn), released on 2026-02-02.

SYNOPSIS

use Number::Base::SpreadsheetColumn qw(from_scbase to_scbase);

say from_scbase("A");  # => 0
say from_scbase("Z");  # => 25
say from_scbase("AA"); # => 26
say from_scbase("AZ"); # => 51
say from_scbase("BA"); # => 52

say to_scbase(0);  # => "A"
say to_scbase(25); # => "Z"
say to_scbase(26); # => "AA"
say to_scbase(51); # => "AZ"
say to_scbase(52); # => "BA"

DESCRIPTION

Spreadsheet column is basically 26-base number with 1-based index.

FUNCTIONS

from_scbase

to_scbase

HOMEPAGE

Please visit the project's homepage at https://metacpan.org/release/Number-Base-SpreadsheetColumn.

SOURCE

Source repository is at https://github.com/perlancar/perl-Number-Base-SpreadsheetColumn.

SEE ALSO

Number::AnyBase

AUTHOR

perlancar <perlancar@cpan.org>

CONTRIBUTING

To contribute, you can send patches by email/via RT, or send pull requests on GitHub.

Most of the time, you don't need to build the distribution yourself. You can simply modify the code, then test via:

% prove -l

If you want to build the distribution (e.g. to try to install it locally on your system), you can install Dist::Zilla, Dist::Zilla::PluginBundle::Author::PERLANCAR, Pod::Weaver::PluginBundle::Author::PERLANCAR, and sometimes one or two other Dist::Zilla- and/or Pod::Weaver plugins. Any additional steps required beyond that are considered a bug and can be reported to me.

COPYRIGHT AND LICENSE

This software is copyright (c) 2026 by perlancar <perlancar@cpan.org>.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.

BUGS

Please report any bugs or feature requests on the bugtracker website https://rt.cpan.org/Public/Dist/Display.html?Name=Number-Base-SpreadsheetColumn

When submitting a bug or request, please include a test-file or a patch to an existing test-file that illustrates the bug or desired feature.