Python编程：读写excel文件

import xlsxwriter  # pip install XlsxWriter
# 新建工作薄
workbook = xlsxwriter.Workbook('hello.xlsx') 
# 新建工作表
worksheet = workbook.add_worksheet()
# 写入
worksheet.write('A1', 'Hello world')
# 关闭工作薄
workbook.close()

#新建excel并写入
#而xlwt生成excel文件
#是不能在已有的excel文件基础上进行修改的
#保存格式只能是xls
import xlwt
workbook=xlwt.Workbook()
sheet1=workbook.add_sheet('sheet1',cell_overwrite_ok=True)
sheet2=workbook.add_sheet('sheet2',cell_overwrite_ok=True)
sheet1.write(0,0,'this should overwrite')
sheet1.write(0,1,'aaaaaaaaaaaaaaaaaaaaaaa')
sheet2.write(0,0,'this should overwrite')
sheet2.write(1,2,'bbbbbbbbbbbbbbbbb')
#--------------设置样式------------------
style=xlwt.XFStyle()
font=xlwt.Font()
font.name="微软雅黑"
font.size=14
style.font=font
#使用样式
sheet1.write(1,1,'use style',style)
workbook.save('test2.xls')#同名会覆盖
print('创建excel完成')

pip install xlrd

import xlrd
path="test.xlsx"
excel=xlrd.open_workbook(path)
table=excel.sheets()[0]
#按照行取
for i in range(table.nrows):
  print(table.row_values(i))
#按照列取
for j in range(table.ncols):
  print(table.col_values(j))
#遍历所有单元格
for i in range(table.nrows):
  for j in range(table.ncols):
  print(table.cell_value(i,j))