# 工作簿， 工作表，單元格 #workbook ,sheet ,cell # 靈活擦歐總各種對象，進行修改‘ # 編輯樣式 %cd D:\python全站\office D:\python??\office # pip install openpyxl import openpyxl wb = openpyxl.load_workbook(‘coop.xlsx‘) # 加載創建的表格coop.xlsx wb.get_active_sheet() c:\users\coop\miniconda3\envs\coop\lib\site-packages\ipykernel_launcher.py:1: DeprecationWarning: Call to deprecated function get_active_sheet (Use the .active property). """Entry point for launching an IPython kernel. sh1 = wb.active cell1 = sh1[‘A1‘] print(cell1) cell1.value ‘學生‘ sh1[‘A1‘].value ‘學生‘ sh1[‘A2‘].coordinate ‘A2‘ sh1[‘A2‘] = ‘zhao‘ # another sh1[‘A2‘].value = ‘zhao‘ sh1[‘A2‘].value ‘zhao‘ ########### sh1.title ‘Sheet2‘ sh1.title = ‘成績單‘ sh1.title ‘成績單‘ wb.save(‘coop-1.xlsx‘) # 另存為 ########## # 取sheet1的數據，放入sheet2，成績> 65 # 打開工作簿 %cd D:\python全站\office import openpyxl wb = openpyxl.load_workbook(‘coop.xlsx‘) # 打開sheet1，打開sheet2 #操作sheet1，存入sheet2 # 另存為新的文件 D:\python??\office # sh1 = wb.get_sheet_by_name(‘Sheet1‘) # 首寫大寫 sh1 = wb[‘Sheet1‘] #對Sheet1頁面操作 sh2 = wb[‘Sheet2‘] #對Sheet2頁面操作 for row in sh1.rows: # 循環每一行 sh1.row() print(row) print(row[0].value, row[1].value) # 打印的是元祖 (, ) 學生 成績 (, ) coop 60 (, ) murphy 61 (, ) lisi 62 (, ) zhangsan 63 (, ) lilei 64 (, ) ××× 65 (, ) hao 66 for rows in sh1.rows: if rows[0].coordinate != ‘A1‘: #元祖用法 #rows[0].coordinate去坐標，不等于A1 print(rows[0].value, rows[1].value) coop 60 murphy 61 lisi 62 zhangsan 63 lilei 64 ××× 65 hao 66 for rows in sh1.rows: if rows[0].coordinate != ‘A1‘ and rows[1].value >63: #rows[0].coordinate去坐標，不等于A1 print(rows[0].value, rows[1].value) lilei 64 ××× 65 hao 66 index = 2 for rows in sh1.rows: if rows[0].coordinate != ‘A1‘ and rows[1].value >63: #rows[0].coordinate去坐標，不等于A1 print(rows[0].value, rows[1].value) sh2[‘A‘ + str(index)] = rows[0].value sh2[‘B‘ + str(index)] = rows[1].value print(‘in sh2:‘, sh2[‘A‘+str(index)].value,sh2[‘B‘+ str(index)].value) index += 1 wb.save(‘coop-2.xlsx‘) lilei 64 in sh2: lilei 64 ××× 65 in sh2: ××× 65 hao 66 in sh2: hao 66 # 第二種寫法，根據范圍取值 #A2 B2 # A3, B3 # index = 2 sh1 = wb[‘Sheet1‘] sh2 = wb[‘Sheet3‘] for rows in range(2, sh1.max_row +1): grade = sh1.cell(row = rows, column = 2).value # print(grade) # print(type(grade)) if grade > 63: sh2[‘A‘ + str(rows)] = sh1.cell(row = rows, column = 1).value sh2[‘B‘ + str(rows)] = grade print(‘in sh2:‘, sh2[‘A‘+str(index)].value,sh2[‘B‘+ str(index)].value) wb.save(‘coop-3.xlsx‘) in sh2: None None in sh2: None None in sh2: None None print(sh1.max_row) 8 # 最后一行添加平均分數 sh1.cell(row=9, column=2).value = ‘=average(B2:B8)‘ sh1.cell(row=9, column=1).value = ‘平均分‘ print(sh1[‘B10‘].value) wb.save(‘coop-4.xlsx‘) None print(sh1[‘B9‘].value) =average(B2:B8) from openpyxl.styles import Font # Font? font = Font(bold =True, size = 20) # name, size, bold, italic... sh1[‘B9‘].font = font wb.save(‘coop-5.xlsx‘)

原文：http://blog.51cto.com/13118411/2148166

總結

以上是生活随笔為你收集整理的pythonexcel表格教程_python对excel表格的操作的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。