Project

a1ify

0.0
The project is in a healthy, maintained state
A1ify is a Ruby gem that converts Excel's R1C1 cell references into the standard A1 format. It supports single or multiple references, handles boundary cases up to Excel's maximum supported row and column, and returns sorted references for convenience. Whether you need to generate or display cell references, A1ify provides a simple, efficient, and reliable solution.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
 Dependencies
 Project Readme

A1ify

日本語版 READMEはこちら

A1ify is a Ruby gem that converts Excel R1C1 cell references to the standard A1 format. It supports conversion for both single values and arrays of rows and columns, handling all possible combinations.

Features

  • Simple Conversion: Easily convert Excel R1C1 references to A1 format with a straightforward API.
  • Flexible Input: Accepts both single values and arrays, converting every combination when arrays are provided.

Installation

Using RubyGems

gem install a1ify

Usage

A1ify provides conversion functionality through the A1ify::Converter class.

Single Value Conversion

require 'a1ify'

# Convert a single cell reference (e.g., row 3, column 3 converts to "C3")
result = A1ify::Converter.rc_to_a(3, 3)
puts result  # => "C3"

Array Conversion

require 'a1ify'

# Convert multiple cell references by specifying arrays of rows and columns
results = A1ify::Converter.rc_to_a([1, 2], [1, 2])
puts results.inspect  # => ["A1", "A2", "B1", "B2"] (sorted alphabetically by column)

License

A1ify is released under the MIT License.