2

I love to use Python, but I also found C# and VBA as options.

I want to read one Excel file, then search another Excel file (with multiple sheets), and use this information to modify the initial Excel file.

I did some searching but couldn't find anything that works with Python 3.7.2, or Excel 365. I need Python 3.7.2 for school, so I can't downgrade to Python 3.5 (which works with openpyxl), however I am willing to downgrade my Excel version.

Is there any library I could use (preferably Python)?

  • Welcome to Software Recommendations! I've just modified your question a bit to make it on-topic. Asking for howtos, manuals/tutorials and languages is off-topic on this site. – Izzy Feb 6 at 21:45
  • 1
    Pretty much any Python library that works with 3.5 will should with 3.7.2. – Eric Shain Feb 7 at 0:12
  • "so I can't downgrade to Python 3.5 (which works with openpyxl)" - could you not use a Virtual Machine? Or simply have two paths to Python, one of which (the first installed) you would have to specify the complete path to the interpreter when invoking it? – Mawg Feb 7 at 14:32
  • There is no need to downgrade Python or Excel. If you like OpenPyXL, just use it. Note that pandas uses a combination of xlrd, XlsxWriter, and OpenPyXL for handling Excel files. – John Y Jun 28 at 15:32
1

Pandas will work in 3.7.2.

https://pandas.pydata.org/

This is a great tool for what you're looking to do.

  • Thanks! I'll be sure to try it, and see if it works. – Luke Feb 6 at 21:42
  • It's a great library, but it has lots of dependencies, chief among them being NumPy, which has compiled binary components, which makes it extremely Python version-sensitive. It also depends on other Python libraries to work with Excel files. – John Y Jun 28 at 15:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.