python 使用openpyxl实现读写xlsx文件

 3 import openpyxl
 4 
 5 def write_xlsx(value, path, sheet_name=‘Sheet1‘):
 6 
 7     index = len(value)
 8     workbook = openpyxl.Workbook()
 9     sheet = workbook.active
10     sheet.title = sheet_name
11     for i in range(index):
12         for j in range(len(value[i])):
13             sheet.cell(row=i+1, column=j+1, value=str(value[i][j]))
14     workbook.save(path)
15     print(‘xlsx表格写入数据成功！‘)
16 
17 def read_xlsx(path, sheet_name=‘Sheet1‘):
18     workbook = openpyxl.load_workbook(path)
19     sheet = workbook[sheet_name]
20     for row in sheet.rows:
21         for cell in row:
22             print(cell.value, "\t", end="")
23         print(‘\n‘)
24     # print(‘xlsx表格数据读取成功！‘)
25 
26 write_xlsx(detail, data_path, ‘Sheet1‘)
27 read_xlsx(data_path, ‘Sheet1‘)