openpyxl常规使用

本节介绍简单的openpyxl使用方法：

1. 写入文件

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)