+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: working with more excel files (/thread-16749.html)
working with more excel files - Krszt - Mar-13-2019
Hello,
I would like to modify my existing code that extracts the value of some cells. How can I modify it to do it not only one but for more xls, that are in the same directory.
I tried something like this:
import xlrd
import glob
for filename in glob.glob('*.xls'):
book = xlrd.open_workbook("*.xls", formatting_info=True)
sheets = book.sheet_names()
for index, sh in enumerate(sheets):
sheet = book.sheet_by_index(index)
#print "Sheet:", sheet.name
rows, cols = sheet.nrows, sheet.ncols
#print "Number of rows: %s Number of cols: %s" % (rows, cols)
for row in range(rows):
for col in range(cols): ....the error is Quote:IOError: [Errno 22] invalid mode ('rb') or filename: '*.xls'
RE: working with more excel files - perfringo - Mar-13-2019
Shouldn't on row #5 be filename, not "*.xls"?