需要通过python脚本从具有多张工作表的xlsx文件中删除完整的空白行和列

pip install openpyxl

from openpyxl import load_workbook

workbook = load_workbook(filename='example.xlsx')

sheet_names = workbook.sheetnames

from openpyxl import load_workbook

def remove_empty_rows_columns(filename):
    workbook = load_workbook(filename=filename)

    # 针对每个工作表
    for sheet in workbook.sheetnames:
        ws = workbook[sheet]
        
        # 删除空白行
        for row in ws.iter_rows(min_row=ws.min_row, max_row=ws.max_row):
            if all([cell.value is None for cell in row]):
                ws.delete_rows(row[0].row, 1)
        
        # 删除空白列
        for col in ws.iter_cols(min_col=ws.min_column, max_col=ws.max_column):
            if all([cell.value is None for cell in col]):
                ws.delete_cols(col[0].col_idx, 1)

    # 保存更改
    workbook.save(filename)

remove_empty_rows_columns('example.xlsx')