python运行不了、显示警告_Python xlrd:禁止显示警告消息

查看xlrd docs的相关部分。open_workbook函数的第二个参数是logfile，它应该是一个打开的文件对象或类似的操作。它只需要支持一个write方法。它默认为sys.stdout。

所以，像这样的东西（未经测试）应该可以完成这项工作：class MyFilter(object):

def __init__(self, mylogfile=sys.stdout):

self.f = mylogfile

def write(self, data):

if "WARNING *** OLE2 inconsistency" not in data:

self.f.write(data)

#start up

log = open("the_log_file.txt", "w")

log_filter = MyFilter(log)

book = xlrd.open_workbook("foo.xls", logfile=log_filter)

# shut down

log.close()

# or use a "with" statement

更新以回应@DaniloBargen的回答：

单独编写换行符的不是xlrd，而是Pythonprint语句/函数。此脚本：class FakeFile(object):

def write(self, data):

print repr(data)

ff = FakeFile()

for x in "foo bar baz".split():

print >> ff, x

为所有Python2.2到2.7（包括2.2和2.7）生成此输出：'foo'

'\n'

'bar'

'\n'

'baz'

'\n'

适当的现代化脚本（作为函数而不是语句打印）为2.6、2.7、3.1、3.2和3.3生成相同的输出。你可以用一个更复杂的过滤器类来解决这个问题。以下示例还允许检查短语序列：import sys, glob, xlrd

class MyFilter(object):

def __init__(self, mylogfile=sys.stdout, skip_list=()):

self.f = mylogfile

self.state = 0

self.skip_list = skip_list

def write(self, data):

if self.state == 0:

found = any(x in data for x in self.skip_list)

if not found:

self.f.write(data)

return

if data[-1] != '\n':

self.state = 1

else:

if data != '\n':

self.f.write(data)

self.state = 0

logf = open("the_log_file.txt", "w")

skip_these = (

"WARNING *** OLE2 inconsistency",

)

try:

log_filter = MyFilter(logf, skip_these)

for fname in glob.glob(sys.argv[1]):

logf.write("=== %s ===\n" % fname)

book = xlrd.open_workbook(fname, logfile=log_filter)

finally:

logf.close()