Python 3 and Excel, Finding complex module to use

Question

I've been looking for ages to find a suitable module to interact with excel, which needs to do the following:

Check a column of cells for an "incorrect" value and change it
Check for empty cells, and if so, replace it
Check a cell value is consistent with the contents of another cell(for example, if called Datasheet, the code in another cell = DS)and if not, change it.

I've looked at openpxyl but I am running Python 3 and I can only seem to find it working for 2.

I've seen a few others but they seem to be mainly focusing creating a new spreadsheet and simple writing/reading.

openpyxl definitely works with Python 3. But if your system has both versions of Python installed (which can easily happen without your realizing it) it is possible that openpyxl is only installed in your Python 2 environment. — BoarGules
– BoarGules, Commented May 16, 2019 at 12:10

vlemaistre · Accepted Answer · 2019-05-16 12:05:54Z

1

The Pandas library is amazing to work with excel files. It can read excel files easily and you then have access to a lot of tools. You can do all the operations you mentionned above. You can also save your result in the excel format

answered May 16, 2019 at 12:05

vlemaistre

3,34115 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python 3 and Excel, Finding complex module to use

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related