|
|
马上注册,结交更多好友,享用更多功能^_^
您需要 登录 才可以下载或查看,没有账号?立即注册
x
import openpyxl
wb = openpyxl.load_workbook(r"C:\Users\Administrator\Desktop\小甲鱼\demo.xlsx")
#获取excel文件中表单名sheet
#print(wb.get_sheet_names())
print(wb.sheetnames())
运行结果:
========= RESTART: C:/Users/Administrator/Desktop/小甲鱼/fish_openpyxl2.py ========
Traceback (most recent call last):
File "C:/Users/Administrator/Desktop/小甲鱼/fish_openpyxl2.py", line 19, in <module>
print(wb.sheetnames())
TypeError: 'list' object is not callable
>>>
======
import openpyxl
wb = openpyxl.load_workbook(r"C:\Users\Administrator\Desktop\小甲鱼\demo.xlsx")
#获取excel文件中表单名sheet
print(wb.get_sheet_names())
#print(wb.sheetnames())
运行结果:
========= RESTART: C:/Users/Administrator/Desktop/小甲鱼/fish_openpyxl2.py ========
Warning (from warnings module):
File "C:/Users/Administrator/Desktop/小甲鱼/fish_openpyxl2.py", line 18
print(wb.get_sheet_names())
DeprecationWarning: Call to deprecated function get_sheet_names (Use wb.sheetnames).
['Sheet']
>>> |
|