系统:Windows 7 语言版本:Anaconda3-4.3.0.1-Windows-x86_64 编辑器:pycharm-community-2016.3.2
结果
from openpyxl import load_workbook
excel_address = r"E:\Coding\E_PythonWriting\Excel\openpyxl示例.xlsx"
wb = load_workbook(excel_address)
sht = wb.get_sheet_by_name("示例")
# 赋值
sht["A1"] = "测试1"
sht["A2"].value = "测试2"
sht["A3"] = "测试3"
sht.cell(row=4, column=1, value="测试4") # 函数
# 删除
sht["A1"] = ""
wb.save(excel_address)
代码截图
wb = load_workbook(excel_address)
,打开一个工作簿文件sht = wb.get_sheet_by_name("示例")
,获取工作表对象sht["A1"] = "测试1"
给单元格赋值sht.cell(row=4, column=1, value="测试4")
给单元格赋值wb.save(excel_address)
保存Excel文件,该Excel文件也已被关闭(至少测试看起来是这样)