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

[hongy...@gmail.com]

On Wednesday, September 29, 2021 at 5:40:58 PM UTC+8, J.O. Aho wrote:
> On 29/09/2021 10.22, 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 
> > 
> > Any hints for fixing this problem?
> You need to delete the 13 first lines in the file 

Yes. After deleting the top 3 lines, the problem has been fixed. 

> or you see to that your code does first trim the data before start xml parse it. 

Yes. I really want to do this trick programmatically, but how do I do it without manually editing the file?

HZ