第12章 Excel集成
12.1 基本电子表格交互
12.1.1 生成工作簿(.xls)
import numpy as np
import pandas as pd
import xlrd, xlwt
import xlsxwriter
path = 'E:/Projects/DEMO/Py/MyPyTest/MyPyTest/python_for_finance/data/'
wb = xlwt.Workbook()
wb.add_sheet('first_sheet', cell_overwrite_ok=True)
wb.get_active_sheet()
ws_1 = wb.get_sheet(0)
ws_2 = wb.add_sheet('second_sheet', cell_overwrite_ok=True)
data = np.arange(1, 65).reshape((8, 8))
# 使用 write 方法提供行/列信息(使用零基索引)
ws_1.write(1, 0, 100) # wirte 100 in cell "A1"
ws_2.write(0, 0, 100)
for c in range(data.shape[0]):
for r in range(data.shape[1]):
ws_1.write(r, c, int(data[c, r]))
ws_2.write(r, c, int(data[r, c]))
wb.save(path + 'workbook.xls')
![xls](https://i-blog.csdnimg.cn/blog_migrate/b15dbcb17570b737d677d38f5640574e.jpeg)
12.1.2 生成工作簿(.xslx)
# 创建一个工作簿
wb = xlsxwriter.