读写操作Excel表格
1、Excel表格内容为:
2、用Python读写操作Excel表格
import xlrd
import xlwt
def read_excel():
# 打开文件
workbook = xlrd.open_workbook(r'C:\\Users\\liangguiming\\Desktop\\1.xlsx')
# 根据sheet索引或者名称获取sheet内容
sheet = workbook.sheet_by_index(0) # sheet索引从0开始
# sheet1 = workbook.sheet_by_name('均值、方差')
rows = sheet.nrows # 获取有多少行
cols = sheet.ncols # 获取有多少列
print("共有", rows, "行")
print("共有", cols, "列")
# 获取整行和整列的值(数组)
rows = sheet.row_values(1) # 获取第二行内容
cols = sheet.col_values(2) # 获取第三列内容
print(rows)
print(cols)
def write_excel():
# 创建一个工作薄
workbook = xlwt.Workbook(encoding='utf-8')
sheet1 = workbook.add_sheet(u'sheet1', cell_overwrite_ok=True)
# 初始化样式
style = xlwt.XFStyle()
# 为样式创建字体
font = xlwt.Font()
font.name = '宋体'
font.bold = True
font.height = 260
# 设置样式的字体
style.font = font
alignment = xlwt.Alignment() # 设置字体在单元格的位置
alignment.horz = xlwt.Alignment.HORZ_CENTER # 水平方向
alignment.vert = xlwt.Alignment.VERT_CENTER # 竖直方向
style.alignment = alignment
# 设置表格宽度
sheet1.col(5).width = 260 * 30
sheet1.write(3, 5, "HelloWorld", style)
workbook.save(r'C:\\Users\\liangguiming\\Desktop\\2.xls')
if __name__ == '__main__':
read_excel()
write_excel()
3、运行结果如下图所示: