column_name_to_number

Function column_name_to_number 

Source
pub fn column_name_to_number(name: &str) -> Result<u32, Error>
Expand description

Convert a column name (e.g. "A", "Z", "AA", "XFD") to a 1-based column number.

ยงExamples

use sheetkit_core::utils::cell_ref::column_name_to_number;

assert_eq!(column_name_to_number("A").unwrap(), 1);
assert_eq!(column_name_to_number("Z").unwrap(), 26);
assert_eq!(column_name_to_number("AA").unwrap(), 27);
assert_eq!(column_name_to_number("XFD").unwrap(), 16384);