I don't think there is something wrong with the codes. Can you help me? I need help. Thank you!
from xlrd import open_workbook
wb = open_workbook('/pdf-ex/exc.xlsx','rb')
for s in wb.sheets():
print 'Sheet:',s.name
for row in range(s.nrows):
values=[]
for col in range(s.ncols):
values.append(s.cell(row,col).value)
print ",".join(values)
print
The BOF record specifies the beginning of the individual substreams as specified by the workbook section.
The error "Either BoF or EoF is True, or the current record has been deleted" indicates a problem either with the MLS database on the computer or with access to the database. The program cannot find the Beginning of File (BoF) or End of File (EoF) for some data records.
I had the same problem and resolved it by upgrading to version 0.8.0.
Prior to that version, xlsx/xlsm were not supported.
Release announcement: http://mail.python.org/pipermail/python-list/2012-August/627757.html
Latest version: https://pypi.python.org/pypi/xlrd/
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With