利用openpyxl模块操作excel表
写入功能
from openpyxl import Workbook
from openpyxl import load_workbook
wk = Workbook()
wk = load_workbook("最新公司招聘信息.xlsx")
wk.create_sheet("第二页")
wk.create_sheet("第一页",0)
wk.remove(wk['Sheet'])
wk.remove(wk[wk.sheetnames[0]])
del wk['选项卡']
wb = wk["第二页"]
wb.title='嘿嘿'
wb["A1"] = "嘿嘿"
wb.cell(row=5,column=5,value="Python实训")
wb1 = wk["第一页"]
wb1.append(["李白","蔡文姬","夏侯惇"])
wb1.append(["李小龙","王霸气","爱新觉罗龙"])
wk.save("test.xlsx")
读取功能
from openpyxl import load_workbook
wb = load_workbook("test.xlsx")
sheet2 = wb["第一页"]
print(sheet2["1"])
print(sheet2["1"])
print(sheet2["A1"].value)
print(sheet2.max_row)
print(sheet2.max_column)
for i in sheet2["1"]:
print(i.value,end=" ")
小技巧
- 如果excel表存在就加载,如果不存在就创建加载:
from openpyxl import Workbook
from openpyxl import load_workbook
import os
file = "嘿嘿.xlsx"
if os.path.exists(file):
wk = load_workbook(file)
print("文件已存在,加载使用")
else:
print("文件不存在,已自动创建 "+file)
wk = Workbook()
wk.save(file)
print(wk.sheetnames)