如下所示：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
from openpyxl import workbook
from openpyxl import load_workbook
from openpyxl import worksheet
def find_false_in_sheet(sheet):
for column in sheet.iter_cols():
for cell2 in column:
if cell2.value is not None:
# print cell2.value
# print type(cell2.value)
info2 = cell2.value.find('false')
if info2 == 0:
print cell2
print cell2.value
def find_false_in_xlsx(file_name):
print file_name
wb = load_workbook(file_name)
all_sheets = wb.get_sheet_names()
print(all_sheets)
for i in range(len(all_sheets)):
sheet = wb.get_sheet_by_name(all_sheets[i])
print (sheet.title + ': max_row: ' + str(sheet.max_row) + ' max_column: ' + str(sheet.max_column))
find_false_in_sheet(sheet)
# start
find_false_in_xlsx("test.xlsx")
# for row in sheet.iter_rows():
# for cell in row:
# if cell.value is not None:
# info = cell.value.find('BB')
# if info == 0:
# print cell.value
|
以上这篇Python openpyxl 遍历所有sheet 查找特定字符串就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持服务器之家。
原文链接：https://blog.csdn.net/lysaausb1/article/details/79101859