创建新excel

基本创建

from openpyxl import Workbook,load_workbook
path = r"C:\Users\asuka\Desktop"
os.chdir(path)  # 修改工作路径
workbook = Workbook()
sheet = workbook.active
sheet.title = '1号sheet'
workbook.save('1.xlsx')

添加数据

插入有效数据

读取excel数据

import os
import openpyxl
path = r"C:\Users\asuka\Desktop"
os.chdir(path)  # 修改工作路径
workbook = openpyxl.load_workbook('test.xlsx')    # 返回一个workbook数据类型的值
print(workbook.sheetnames)    # 打印Excel表中的所有表