Populating Excel data in Microsoft Project using Python

This is sort of a general question, so I apologize if it's not appropriate for this site. But I'm a beginner and have a problem that I would like to solve using Python.

I have two files: a Microsoft Project file with a project schedule where half of the fields also exist in an Excel file. Each row in the Excel has a field that is a unique ID and each task in the Project file also has a unique ID that matches the Excel file. Each week there is a new Excel file with new data. What I need to do is 1) automatically populate the data from the new Excel file to the Project file where the fields are the same so that the data is current in the Project file, and 2) create a new task in the Project file if there is a new row in the Excel file. Which Python libraries should I use to accomplish this?

https://stackoverflow.com/questions/66682808/populating-excel-data-in-microsoft-project-using-python March 18, 2021 at 07:39AM