How to get OpenPyXL column letter by index
If you want to access OpenPyXL columns using indices instead of letters, use
openpyxl_get_column_letter.py
import openpyxl.utils.cell
openpyxl.utils.cell.get_column_letter(idx)Note that idx is 1-based: index 0 is not a valid argument & index 1 yields column name A
For example:
openpyxl_example_usage.py
openpyxl.utils.cell.get_column_letter(3) # returns "C"
If this post helped you, please consider buying me a coffee or donating via PayPal to support research & publishing of new posts on TechOverflow