openpyxl对excel实现字母与数字之间的转换

 1 >>>from  openpyxl.utils   import   get_column_letter,column_index_from string
 2 
 3 >>>get_column_letter(2)
 4 
 5 B
 6 
 7 >>>column_index_from_string('B')
 8 
 9 2
10 
11  
原文地址:https://www.cnblogs.com/energetic/p/13038806.html