openpyxl+xlrd去掉excel中的空单元格的None方法

21fanqie

openpyxl+xlrd去掉excel中的空单元格的None方法

import requests,time,openpyxl,xlrd
from openpyxl import load_workbook

A = load_workbook('.文件路径/文件名.xlsx')
biao=A.active
zong=biao.max_row+1

B = xlrd.open_workbook('.文件路径/文件名.xlsx')
sheet = B.sheets()[0]
maxrow=sheet.nrows

zong2=biao.max_row
while maxrow!=zong2:
    for i in range(maxrow+1,zong):
        biao.delete_rows(i)
        zong2=biao.max_row

print(maxrow)
print(biao.max_row)
A.save(path)