
提取F列和H列,指定的某人的積分,求代碼!
uj5u.com熱心網友回復:


from openpyxl import load_workbook
check_name = ['老李', '趙子龍']
xls_file = 'x1.xlsx'
wb = load_workbook(xls_file)
print(wb.sheetnames)
ws = wb['Sheet2']
for i in range(1, ws.max_row+1):
# print(ws['F{}'.format(i)].value)
if ws['F{}'.format(i)].value in check_name:
print(i, ws['F{}'.format(i)].value, ws['H{}'.format(i)].value)
uj5u.com熱心網友回復:
如果只是一次作業, 簡單用 openpyxl 遍歷一次即可。 如果是重復性作業,而且資料量大, 可以考慮用 pandas轉載請註明出處,本文鏈接:https://www.uj5u.com/qita/44949.html
