[Python知识库]Python操作Excel文件

最近有向Excel写数据的需求，发现openpyxl这个模块十分好用：

tabnum = 1
workbook = openpyxl.open('./test.xlsx')
worksheet = workbook.active
worksheet['H'+str(tabnum)] = 'hello'
worksheet['I'+str(tabnum)] = 'world'
workbook.save('test.xlsx')

别处创建的Excel不一定能顺利open，可以如下新建：

workbook = openpyxl.Workbook()
workbook.save('test.xlsx')
workbook.close()

重复写入数据时可以先清空所需范围数据表：

for row in worksheet['H1:I5']: 
    for cell in row: 
        cell.value = '' 

最后附上openpyxl操作手册：https://openpyxl.readthedocs.io/en/stable/