1、Python操作Excel读取
1.1、Excel基本内容
- 工作簿(workbook)
- 表单 (worksheet)
- 行、列、单元格(row,column,cell)
1.2、安装openpyxl
- 下载解压pip后,CMD运行 python setup.py install 安装pip
- 然后在cmd中运行 pip install openpyxl 安装openpyxl模块
1.3、VS Code中安装Python插件
1.4、表单基本操作
import openpyxl
wb = openpyxl.load_workbook("xuesheng.xlsx")
print(wb.sheetnames)
import openpyxl
wb = openpyxl.load_workbook("xuesheng.xlsx")
for sheet in wb:
print(sheet.title)
sheet2 = wb.create_sheet("sheet2")
xuesheng1 = wb.get_sheet_by_name("sheet2")
xuesheng2 = wb["sheet2"]
2、还没写完,有空继续写