Collection of utilities used within the package and also available for client code
openpyxl.utils.cell.
absolute_coordinate
(
coord_string
)
[source]
¶
Convert a coordinate to an absolute coordinate string (B12 -> $B$12)
openpyxl.utils.cell.
cols_from_range
(
range_string
)
[source]
¶
Get individual addresses for every cell in a range. Yields one row at a time.
openpyxl.utils.cell.
column_index_from_string
(
str_col
)
[source]
¶
Convert a column name into a numerical index (‘A’ -> 1)
openpyxl.utils.cell.
coordinate_from_string
(
coord_string
)
[source]
¶
Convert a coordinate string like ‘B12’ to a tuple (‘B’, 12)
openpyxl.utils.cell.
coordinate_to_tuple
(
coordinate
)
[source]
¶
Convert an Excel style coordinate to (row, colum) tuple
openpyxl.utils.cell.
get_column_interval
(
start
,
end
)
[source]
¶
Given the start and end columns, return all the columns in the series.
The start and end columns can be either column letters or 1-based indexes.
openpyxl.utils.cell.
get_column_letter
(
idx
)
[source]
¶
Convert a column index into a column letter (3 -> ‘C’)
openpyxl.utils.cell.
quote_sheetname
(
sheetname
)
[source]
¶
Add quotes around sheetnames if they contain spaces.
openpyxl.utils.cell.
range_boundaries
(
range_string
)
[source]
¶
Convert a range string into a tuple of boundaries: (min_col, min_row, max_col, max_row) Cell coordinates will be converted into a range with the cell at both end