pd.read_excel ignores last empty column

38 Views Asked by At

I want to read a xlsx file with pd.read_excel: screenshot

When I use pd.read_excel the last column (with number 15) isn't read (I suspect because there's no data in it) although it has grid formatting.

I could simply list all columns I want to read in the usecols parameter but in general I won't know their names so I would like to find a robust way to get all columns which have any formatting (proving that they have to be read too) even though they might be empty.

0

There are 0 best solutions below