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)?
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?