使用python获取特定Excel单元格的数据计数

pip install openpyxl

import openpyxl

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

sheet = workbook['Sheet1']

cell_value = sheet['A1'].value

count = 0
for row in sheet.iter_rows():
    for cell in row:
        if cell.value == '特定数据':
            count += 1

import openpyxl

workbook = openpyxl.load_workbook('example.xlsx')
sheet = workbook['Sheet1']

cell_value = sheet['A1'].value

count = 0
for row in sheet.iter_rows():
    for cell in row:
        if cell.value == '特定数据':
            count += 1

print("特定数据出现的次数：", count)