python向表格xls读写数据

 写入数据：

# -*- coding:utf-8 -*-
import xlwt
workbook = xlwt.Workbook()  # 新建一个工作簿
sheet = workbook.add_sheet("tab")  # 在工作簿中新建一个表格
title=["title1","title2","title3","title4"]
content=["111","222","333","444"]
for i in range(0, 3):  # 行数
    for j in range(0, len(title)):  # 列数
        if i == 0:#第0行为标题行
            sheet.write(0, j, title[j])
        else:
            sheet.write(i , j, content[j])  # 向表格中写入数据
workbook.save("test.xls")  # 保存工作簿

 

读出数据：

# -*- coding:utf-8 -*-
import xlrd

path = u"C:\\读取表格\\表格.xls"#
workbook = xlrd.open_workbook(path)
sheet = workbook.sheet_by_index(0)
for row in range(sheet.nrows):
    for col in range(sheet.ncols):
        print(sheet.row(row)[col].value)#按行读取excel

 

转载于:https://www.cnblogs.com/taoyuanming/p/10757949.html