擅长:python、mysql、java
<p>openpyxl有一个名为<strong>get_column_letter</strong>的函数,它将数字转换为列字母。</p>
<pre><code>from openpyxl.utils import get_column_letter
print(get_column_letter(1))
</code></pre>
<p>1--gt;一</p>
<p>50-->;最大</p>
<p>1234——奥尔</p>
<p>我一直在用它,就像:</p>
<pre><code>from openpyxl import Workbook
from openpyxl.utils import get_column_letter
#create excel type item
wb = Workbook()
# select the active worksheet
ws = wb.active
counter = 0
for column in range(1,6):
column_letter = get_column_letter(column)
for row in range(1,11):
counter = counter +1
ws[column_letter + str(row)] = counter
wb.save("sample.xlsx")
</code></pre>
<p><a href="https://i.stack.imgur.com/YzYku.png" rel="noreferrer"><img src="https://i.stack.imgur.com/YzYku.png" alt="enter image description here"/></a></p>