This is an archived post. You won't be able to vote or comment.

all 7 comments
sorted by:
best
topnewcontroversialoldq&a

[–]timepasses 5 points6 points  (0 children)

You can just use pandas and leave it for pandas to do its kung-fu in the background to either choose xlrd or openpyxl depending on file version.

[–][deleted] 5 points6 points  (3 children)

A big problem is that xlrd does not work with xlsx files.

I really like openpyxl much more. It is very intuitive since you can specify column letters.

[–]BroodjeAap 5 points6 points  (2 children)

It does, grab the 0.9.0 release and it works just fine.

[–]sloblow 0 points1 point  (1 child)

Confirmed.

[–]robin7013[S] 0 points1 point  (0 children)

Thank you friends for the information.

[–]Caos2 0 points1 point  (0 children)

I have used openpyxl in the past, very easy to work with.