Python 讀寫xlsx

標籤：軟體   pip   filename   pen   work   rom   class   body   from   

# pip install openpyxl

# openpyxl只能用於處理xlsx,不能用於處理xls
from openpyxl import load_workbook

# 開啟檔案
ExcelFullName = ‘c://平台軟體開發部工資報表（2017-6）.xlsx‘
wb = load_workbook(ExcelFullName)

# 遍曆表格
for table in wb:
    for row in range(1, table.max_row + 1):
        for col in range(1, table.max_column + 1):
            Data = table.cell(row=row, column=col).value
            print(Data)

    table.cell(row=1, column=1).value = ‘黃海的修改測試‘
    wb.save(filename=ExcelFullName)

Python 讀寫xlsx