piaoquan_crawler/weixinzhishu/weixinzhishu_main/weixinzhishu_del_null.py

# -*- coding: utf-8 -*-
# @Author: wangkun
# @Time: 2023/3/13
from common.feishu import Feishu


class Delete:
    @classmethod
    def del_null(cls, log_type, crawler, sheetid):
        while True:
            sheet = Feishu.get_values_batch(log_type, crawler, sheetid)
            if sheet is None:
                continue
            for i in range(1, len(sheet)):
                if i == len(sheet):
                    print("删除完毕")
                    return
                print(f"正在判断{i+1}行")
                get_time = sheet[i][5]
                title = sheet[i][6]
                if get_time is None or title is None:
                    Feishu.dimension_range(log_type, crawler, sheetid, "ROWS", i+1, i+1)
                    print(f"第{i+1}行：空行，已删除")
                    break


if __name__ == "__main__":
    Delete.del_null("del", "weixinzhishu", "UQCMHR")