28 excel表格读写

* coding: UTF-8 *

#@time: 2022/2/14 14:22
#@Author: Bao

import xlwt
import xlrd

#设置表格样式
def set_style(name,height,bold=False):
style = xlwt.XFStyle()
font = xlwt.Font()
font.name = name
font.bold = bold
font.color_index = 4
font.height = height
style.font = font
return style

f=xlwt.Workbook()
sheet1 = f.add_sheet(‘列表’,cell_overwrite_ok=True)
row0 = [“编号”,“姓名”,“出生日期”,“发展方向”]
for i in range(0,len(row0)):
sheet1.write(0,i,row0[i],set_style(‘Times New Roman’,220,True))
sheet1.write(1,0,‘1001’)
sheet1.write(1,1,‘张三’)
sheet1.write(1,2,‘2015.01.12’)
sheet1.write(1,3,‘管理’)
sheet1.write(2,0,‘1002’)
sheet1.write(3,0,‘1003’)
f.save(‘test.xls’)

f=xlrd.open_workbook(‘test.xls’)
sheetsName=f.sheet_names() #获取所有表格名字
print(sheetsName)
sheet1=f.sheet_by_index(0) #通过索引获取表格
print(sheet1)
sheet1=f.sheet_by_name(‘列表’) #通过名字获取表格
print(sheet1)
rows = sheet1.row_values(0)#获取行内容
cols = sheet1.col_values(0)#获取列内容
cellVal=sheet1.cell_value(1,2)
print(rows)
print(cols)
print(cellVal)