openpyxl.utils.cell module¶
-
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 colums, 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