python 读、写excel文件

写excel文件

from openpyxl import Workbook

# 创建新execl
wb = Workbook()
ws1 = wb.create_sheet("Mysheet")
# 激活sheet
ws1 = wb.active
list = [1, 2, 3]
# 插入数据
ws1.append(table.row_values(index))
# 保存
wb.save(filename="ruijin_n.xlsx")

读excel文件

import xlrd

# 打开文件
data = xlrd.open_workbook('ruijin_t.xlsx')
# 选取sheet
table = data.sheets()[0]
# 选取列
col_10 = table.col_values(10)