Excel单元格非空计数

pip install openpyxl

import openpyxl

# 加载Excel文件
workbook = openpyxl.load_workbook('example.xlsx')

# 选择工作表
sheet = workbook.active

# 定义需要统计非空单元格的区域
start_row = 1
end_row = 10
start_column = 'A'
end_column = 'C'

# 统计非空单元格的数量
non_empty_count = 0
for row in sheet[start_column + str(start_row):end_column + str(end_row)]:
    for cell in row:
        if cell.value is not None:
            non_empty_count += 1

print(f'非空单元格的数量为：{non_empty_count}')

|  A  |  B  |  C  |
|-----|-----|-----|
|  1  |     |  3  |
|     |     |     |
|  4  |  5  |  6  |
|     |     |  8  |

非空单元格的数量为：6