1.openpyxl 的使用小结
https://geek-docs.com/python/python-tutorial/python-openpyxl.html
https://openpyxl.readthedocs.io/en/stable/tutorial.html#create-a-workbook
book = Workbook()
sheet = book.active
row = 1
col = 1
sheet.cell(row, col, flow_name)
book.save(f"{type}_becall_data.xlsx")
表格处理一般是遍历,自己控制游标 row col
按照顺序,从左至右,从上至下逐个格填写,如果需要修改,不如整个表重做
单元格合并
sheet.merge_cells(start_row=merge_i, end_row=row - 1, start_column=1, end_column=1)