一、代码
# pip install openpyxl
def open():
# 导入模块 load_workbook
from openpyxl import load_workbook
# 打开excel
wb = load_workbook('./base_data/data01.xlsx')
# 获取工作薄的几种方式
sh1 = wb.active
sh2 = wb['Sheet1']
sh3 = wb.get_sheet_by_name('Sheet1')
print(sh1 is sh2 is sh3)
if __name__ == "__main__":
open()
二、问题:为什么代码和老师教学视频里一样,但是却出现错误呢?
PS E:\Class\办公自动化> & "C:/Program Files/Python39/python.exe" e:/Class/办公自动化/07_openpyxl读取数据.py
Traceback (most recent call last):
File "e:\Class\办公自动化\07_openpyxl读取数据.py", line 16, in <module>
open()
File "e:\Class\办公自动化\07_openpyxl读取数据.py", line 7, in open
wb = load_workbook('./base_data/data01.xlsx')
File "C:\Users\皮蛋丸子\AppData\Roaming\Python\Python39\site-packages\openpyxl\reader\excel.py", line 315, in load_workbook
reader = ExcelReader(filename, read_only, keep_vba,
File "C:\Users\皮蛋丸子\AppData\Roaming\Python\Python39\site-packages\openpyxl\reader\excel.py", line 124, in __init__
self.archive = _validate_archive(fn)
File "C:\Users\皮蛋丸子\AppData\Roaming\Python\Python39\site-packages\openpyxl\reader\excel.py", line 96, in _validate_archive
archive = ZipFile(filename, 'r')
File "C:\Program Files\Python39\lib\zipfile.py", line 1257, in __init__
self._RealGetContents()
File "C:\Program Files\Python39\lib\zipfile.py", line 1324, in _RealGetContents
raise BadZipFile("File is not a zip file")
zipfile.BadZipFile: File is not a zip file