使用openpyxl处理xlsx文件

#coding=utf-8

from openpyxl import Workbook
from openpyxl import load_workbook

inwb = load_workbook("E:\Letter9.xlsx")

# outwb = Workbook()

for sheetName in inwb.get_sheet_names():
    # if not sheetName.isdigit():  #如果表名不是数字，不处理
    #     continue
    sheet = inwb[sheetName]
    sheet.cell(coordinate=None, row=6, column=7).value = None

inwb.save("E:\Letter9.xlsx")



参考：https://www.cnblogs.com/sun-haiyu/p/7096423.html
https://www.cnblogs.com/joyeecheung/p/3842002.html
　　　http://blog.youkuaiyun.com/jollypigclub/article/details/46696315

转载于:https://www.cnblogs.com/carlvine/articles/8259074.html