获取列表字典的值
for b in borrow_num:
ws.write(data_row, 0, b["id"])
ws.write(data_row, 1, b["name"])
ws.write(data_row, 2, b["bor_num"])
ws.write(data_row, 3, b["book_num"])
即可在excel里写入正确数据

获取列表字典的值
for b in borrow_num:
ws.write(data_row, 0, b["id"])
ws.write(data_row, 1, b["name"])
ws.write(data_row, 2, b["bor_num"])
ws.write(data_row, 3, b["book_num"])
即可在excel里写入正确数据