1.字母列号和数字列号的转换
from openpyxl.utils import get_column_letter, column_index_from_string
print(get_column_letter(1)) #A
print(column_index_from_string(‘B’)) #2
openpyxl用法总结
最新推荐文章于 2022-06-10 23:17:53 发布
1.字母列号和数字列号的转换
from openpyxl.utils import get_column_letter, column_index_from_string
print(get_column_letter(1)) #A
print(column_index_from_string(‘B’)) #2