XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'\r\n\r\n\r\n\r\n'

hongy...@gmail.com hongyi.zhao at gmail.com
Wed Sep 29 21:20:23 EDT 2021


On Thursday, September 30, 2021 at 5:20:04 AM UTC+8, Peter J. Holzer wrote:
> On 2021-09-29 01:22:03 -0700, hongy... at gmail.com wrote: 
> > I tried to convert a xls file into csv with the following command, but failed: 
> > 
> > $ in2csv --sheet 'Sheet1' 2021-2022-1.xls 
> > XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'\r\n\r\n\r\n\r\n' 
> > 
> > The above testing file is located at here [1]. 
> > 
> > [1] https://github.com/hongyi-zhao/temp/blob/master/2021-2022-1.xls
> Why is that file name .xls when it's obviously an HTML file? 

Good catch! Thank you for pointing this out. This file is automatically exported from my university's teaching management system, and it was assigned the .xls extension by default.

HZ


More information about the Python-list mailing list