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):
        sheet_index_list = []
        while True:
            sheet = Feishu.get_values_batch(log_type, crawler, sheetid)
            print(len(sheet))
            if sheet is None:
                continue
            for i in range(1, len(sheet)):
                print(f"正在判断{i}行")
                get_time = sheet[i][5]
                title = sheet[i][6]
                if get_time is None or title is None:
                    sheet_index_list.append(i)
                    print(f"第{i}行已加入待删除列表")
            break
        print(sheet_index_list)
        # for index in sheet_index_list:
        #     Feishu.dimension_range(log_type, crawler, sheetid, "ROWS", index, index)
        #     print(f"第{index}行：空行，已删除")


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