Excel 读取
- import openpyxl
- import xlwt
- 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 写
- 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,3)] # 行列
- [[2,3,4]]
来源: http://www.bubuko.com/infodetail-2888737.html