class AI_lims_file(object):
print(lims_AI().AI_lims())
def __init__(self):
self.wb = openpyxl.load_workbook("./表格名称.xlsx")
self.ws = self.wb.active
# 获取最大行
self.row = self.ws.max_row
# 获取最大列
self.column = self.ws.max_column
def delete_space(self):
# 从大到小迭代
for x in range(self.row, 1, -1):
s = self.ws.cell(x, self.column).value
if s is None:
self.ws.delete_rows(x)
else:
pass
self.wb.save("./表格名称.xlsx")
删除行和清空行数据不同,删除行后下面的行会往上移,所以这里行号排序倒着删就不会出现顺序删除时,部分行没有被删掉,仅做记录