xlrd读取excel的一个奇怪错误

[阿凯99]

今天试用python3.5读取excel，发生一件奇怪的事情，简单的2个语句，竟然报错：
import xlrd
data = xlrd.open_workbook(filename = 'aaa.xls' )

Traceback (most recent call last):
File "F:\xlrd.py", line 1, in <module>
import xlrd
File "F:\xlrd.py", line 3, in <module>
data = xlrd.open_workbook(filename = 'aaa.xls' )
AttributeError: module 'xlrd' has no attribute 'open_workbook'

奇怪的是，把上述2个语句放在shell中一句一句地执行，是正常的。

我的环境为：windows10，python3.5.1，excel2016

本人用python2、3年了，第一次遇见如此怪事。

[panghuhu250]

引用 楼主 kite99 的回复:

import xlrd data = xlrd.open_workbook(filename = 'aaa.xls' ) Traceback (most recent call last): File "F:\xlrd.py", line 1, in <module> import xlrd File "F:\xlrd.py", line 3, in <module> data = xlrd.open_workbook(filename = 'aaa.xls' ) AttributeError: module 'xlrd' has no att

你的xlrd屏蔽了真正的xlrd.

[阿凯99]

果真如此，看来文件名不能乱取。一不小心，犯了这么低级的错误。谢谢panghuhu250君。

[「已注销」]

你好，请问你遇到过这个种问题吗？ 代码： import openpyxl #from openpyxl.reader.excel import load_workbook bookname = 'Book1.xlsx' wb = openpyxl.load_workbook(bookname) ws = wb.get_sheet_by_name("sheet1") link = "#sheet2!A5" ws.cell(row=1, column=1).hyperlink = (link) 执行报错： D:\python\workspace>C:/Users/Administrator/AppData/Local/Programs/Python/Python37/python.exe d:/python/openpyxl.py Traceback (most recent call last): File "d:/python/openpyxl.py", line 1, in <module> import openpyxl File "d:\python\openpyxl.py", line 4, in <module> wb = openpyxl.load_workbook(bookname) AttributeError: module 'openpyxl' has no attribute 'load_workbook'

[almu2]

引用 1 楼 panghuhu250 的回复:

[quote=引用 楼主 kite99 的回复:]
import xlrd
data = xlrd.open_workbook(filename = 'aaa.xls' )

Traceback (most recent call last):
File "F:\xlrd.py", line 1, in <module>
import xlrd
File "F:\xlrd.py", line 3, in <module>
data = xlrd.open_workbook(filename = 'aaa.xls' )
AttributeError: module 'xlrd' has no att

你的xlrd屏蔽了真正的xlrd.[/quote]


果然大家犯错可能是一样的， 我竟然用了一样的错误。。。。。哈哈。