python excel 读写

 

excel 读取

?

1 2	import openpyxl import xlwt

 

?

1 2 3 4 5 6 7

data = xlrd.open_workbook("C:/Users/4YUJIAN/Desktop/优惠备案.xls") table = data.sheets()[0] nrows = table.nrows #行数 ncols = table.ncols #列数 for i in range(nrows):     r = table.row_values(i)  # 某一行数据     print(r)

excel 写 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

def write07Excel(path, value, fileName):     wb = openpyxl.Workbook()     sheet = wb.active     sheet.title = fileName     for i in range(len(value)):         for j in range(len(value[i])):             sheet.cell(row=i + 1, column=j + 1, value=str(value[i][j]))     wb.save(path)     print("写入数据成功！")     def write03Excel(path, value, fileName):     wb = xlwt.Workbook()     sheet = wb.add_sheet(fileName)     for i in range(len(value)):         for j in range(len(value[i])):             v = str(value[i][j])             sheet.write(i, j, v)     wb.save(path)     print("写入数据成功！")

　　数据传入格式 :

?

1 2	[(1,2,3)]  # 行列 [[2,3,4]]