openpyxl鏄竴涓敤浜庢搷浣淓xcel鏂囦欢鐨凱ython搴撱€備笅闈㈡槸涓€浜沷penpyxl搴撶殑甯歌鐢ㄦ硶锛?/p>

1. 瀵煎叆openpyxl搴擄細

import openpyxl

2. 鎵撳紑Excel鏂囦欢锛?/li>

workbook = openpyxl.load_workbook('filename.xlsx')

3. 閫夋嫨宸ヤ綔琛細

sheet = workbook.active  # 閫夋嫨娲诲姩宸ヤ綔琛?/span>
sheet = workbook['Sheet1']  # 閫夋嫨鎸囧畾鍚嶇О鐨勫伐浣滆〃

4. 璇诲彇鍗曞厓鏍肩殑鍊硷細

value = sheet['A1'].value  # 璇诲彇A1鍗曞厓鏍肩殑鍊?/span>

5. 鍐欏叆鍗曞厓鏍肩殑鍊硷細

sheet['A1'] = 'Hello, World!'  # 灏嗗瓧绗︿覆鍐欏叆A1鍗曞厓鏍?/span>

6. 淇濆瓨Excel鏂囦欢锛?/li>

workbook.save('filename.xlsx')

杩欎簺鍙槸openpyxl搴撶殑鍩烘湰鐢ㄦ硶锛岃繕鏈夊緢澶氬叾浠栫殑鍔熻兘锛屽璇诲彇鏁翠釜宸ヤ綔琛ㄣ€佽鍐欏涓崟鍏冩牸銆佸垱寤烘柊鐨勫伐浣滆〃绛夈€備綘鍙互鍙傝€僶penpyxl鐨勫畼鏂规枃妗ｏ紙https://openpyxl.readthedocs.io/锛変簡瑙ｆ洿澶氳缁嗙殑鐢ㄦ硶鍜岀ず渚嬨€?/p>