瑕佸湪PyCharm涓鍏xcel鏁版嵁锛岄渶瑕佸畨瑁卭penpyxl搴撱€?/p>

鍙互鎸夌収浠ヤ笅姝ラ杩涜瀵煎叆锛?/p>

1. 鎵撳紑PyCharm锛屽垱寤轰竴涓柊鐨凱ython椤圭洰銆?/li>
2. 鍦ㄩ」鐩枃浠跺す涓垱寤轰竴涓柊鐨凱ython鏂囦欢銆?/li>
3. 鍦≒ython鏂囦欢涓鍏penpyxl搴擄細

   import openpyxl
   

4. 浣跨敤openpyxl搴撶殑load_workbook()鍑芥暟鍔犺浇Excel鏂囦欢锛?pre class="hljs">wb = openpyxl.load_workbook('鏂囦欢璺緞/鏂囦欢鍚?xlsx') 璇峰皢鏂囦欢璺緞/鏂囦欢鍚?xlsx鏇挎崲涓轰綘鐨勫疄闄匛xcel鏂囦欢璺緞鍜屾枃浠跺悕銆?/li>
5. 閫夋嫨瑕佷粠涓鍙栨暟鎹殑宸ヤ綔琛細

   sheet = wb['宸ヤ綔琛ㄥ悕']
   

   璇峰皢宸ヤ綔琛ㄥ悕鏇挎崲涓轰綘鐨勫疄闄呭伐浣滆〃鍚嶃€?/li>
6. 浣跨敤sheet.iter_rows()鎴?code>sheet.iter_cols()鍑芥暟杩唬璇诲彇鏁版嵁琛屾垨鍒楋細

   for row in sheet.iter_rows():
       for cell in row:
           print(cell.value)
   

   鎴栬€?pre class="hljs">for col in sheet.iter_cols(): for cell in col: print(cell.value) 杩欏皢閫愯锛堟垨閫愬垪锛夋墦鍗癊xcel涓殑姣忎釜鍗曞厓鏍肩殑鍊笺€?/li>

杩欐牱锛屼綘灏卞彲浠ュ湪PyCharm涓鍏ュ苟璇诲彇Excel鏁版嵁浜嗐€?/p>