CODEWITHSUNDEEP
pythonpython-3.xexcelpycharmruntime-error
itwabi
itwabi

Reputation: 124

Reading excel file with pylightxl

My organization needs me to use pylightxl library to read some bulky excel xlsx files. I have never used this library before and I'm getting a strange error in pycharm. I simply do not understand what it is. a screenshot of my pycharm

I've tried googling but there isn't much support for pylightxl on the web. Does anyone know how to help?

Upvotes: 0

Views: 1432

Answers (2)

PydPiper
PydPiper

Reputation: 498

for completeness of this post it looks like there was a bug in early days of pylightxl for files that were converted from xls to xlsx, however this issue has been resolved with #31 with version 1.52+

Upvotes: 1

itwabi
itwabi

Reputation: 124

For those who might meet the same issue in the future, here's how i solved my issue, or rather a work around of it.

The excel files i had been given were initially in xls format, which pylightxl does not support.

I converted them to xlsx by just clicking "save as" in excel and then tried to read them in pylightxl, of which i was getting the strange error above. Must be something to do with the format

So I ended up saving it in csv instead, of which reading them was successful.

So if anyone meets this error, try different formats for the document you're trying to read

Upvotes: 0

Related Questions