用openpyxl批量修改excel指定列demo

最近沉迷工作，好久没记了，水一篇，一个demo：

# author jinyunlong
# createtime 2022/10/19 23:38
# 职业   ICBC锅炉房保安
import json
import time
import requests
from openpyxl import load_workbook


def SchoolBatchDemo():
    try:
        #记录批次数
        j = 1

        wb = load_workbook('demo.xlsx')
        sheet = wb[wb.sheetnames[0]]
        #获取总行数
        max_row = sheet.max_row

        for i in range(2,max_row+1):
            name = sheet.cell(row=i, column=1).value
            idno = sheet.cell(row=i, column=2).value
            cardno = sheet.cell(row=i, column=5).value
            tag = '0'

            # 存入jsonobject
            jsonItem = {'name': name,
                        'idno': idno,
                        'cardno': cardno,
                        'tag': tag,
                        }
            req = requests.post('http://127.0.0.1:8989/jsonDemo', json=jsonItem)
            jsonstr = json.loads(req.text)
            sheet.cell(row=i, column=10).value = jsonstr["return_code"]
            sheet.cell(row=i, column=11).value = jsonstr["return_msg"]
            print('第{}条完成'.format(i))
            if i % 2000 == 0:
                time.sleep(5)
                print('第{}批次的两千个数已完成'.format(j))
                j += 1

        print('一共{}批次,{}条已完成,单批次接口调用间隔为5s,在finally中统一保存数据不用开启多线程'.format(j,max_row))
    except Exception as e:
        print(e.args)
    finally:
        #最后统一存挺快的,省的开线程
        wb.save('demo.xlsx')


if __name__ == '__main__':
    SchoolBatchDemo()

调接口，接收返回值后在指定列添加内容，一次2000条间隔5s

用springboot模拟个接口返回：

    @RequestMapping(value = "/jsonDemo",method = RequestMethod.POST)
    public String jsonDemo(@RequestBody JSONObject jsonObject) {
        return "{\"return_msg\":\"success\",\"return_code\":\"0\"}";
    }

server.port=8989

沉迷完工作后，要去沉迷一阵switch了，下次水是在下次😳