本节介绍简单的openpyxl使用方法:
- 写入文件
import openpyxl as pyxl
file_name = "abc.xlsx"
wb = pyxl.Workbook()
ws = wb.active
ws.title = "Sheet1"
for row in range(1,10):
ws.append(range(5))
ws2 = wb.create_sheet("data")
ws2["B2"]=3.14
wb.save(file_name)
本节介绍简单的openpyxl使用方法:
import openpyxl as pyxl
file_name = "abc.xlsx"
wb = pyxl.Workbook()
ws = wb.active
ws.title = "Sheet1"
for row in range(1,10):
ws.append(range(5))
ws2 = wb.create_sheet("data")
ws2["B2"]=3.14
wb.save(file_name)