擅长:python、mysql、java
<p>仅适用于.xlsx文件</p>
<pre><code>from openpyxl import load_workbook
path = "test.xlsx"
book = load_workbook(path)
sheet = book.worksheets[0] # get first Excel sheet of test.xlsx
for cells in range(1, 201): # check first 200 cells
cell = sheet.cell(cells, 1) # iterate over cells in Column 1 = A -> A1, A2, A3, ...
if cell.value != None and cell.font.b == 1: # ignore empty cells and get bold cells
... "do stuff with cell" ...
</code></pre>