python的openpyxl库如何读取特定列,Openpyxl-如何在Python中从Excel文件中仅读取一列？...

I want to pull only column A from my spreadsheet. I have the below code, but it pulls from all columns.

from openpyxl import Workbook, load_workbook

wb=load_workbook("/home/ilissa/Documents/AnacondaFiles/AZ_Palmetto_MUSC_searchterms.xlsx", use_iterators=True)

sheet_ranges=wb['PrivAlert Terms']

for row in sheet_ranges.iter_rows(row_offset=1):

for cell in row:

print(cell.value)

解决方案

this is an alternative to previous answers in case you whish read one or more columns using openpyxl

import openpyxl

wb = openpyxl.load_workbook('origin.xlsx')

first_sheet = wb.get_sheet_names()[0]

worksheet = wb.get_sheet_by_name(first_sheet)

#here you iterate over the rows in the specific column

for row in range(2,worksheet.max_row+1):

for column in "ADEF": #Here you can add or reduce the columns

cell_name = "{}{}".format(column, row)

worksheet[cell_name].value # the value of the specific cell

... your tasks...

I hope that this be useful.