Hi, How to copy data from Excel to Micorosoft Project and from MS Project to Excel. Does Uipath has any built in activities? Thanks for sharing.
Kindly check the below if that will help you…
Thank you, NithinKrishna.
I checked that. It seems to only have the activity that copies the tasks from Project into a datatable which can be copied to Excel. I do not find any activities for copying from Excel into MS Project. How do I do filtering on a column in MS Project? Thanks for looking into this.
I found this one pretty useful
Have a view on this
Thank you. It looks like I need to download ODBC driver which is not a possibility, it might need licensing.
Any other suggestions would be appreciated. Thanks a lot for your time.
Thank you @Palaniyappan. Does it need ODBC driver installation with a license? Is CDATA ODBC driver a third party? Thanks a lot,
Okay you may need to create the project from an Excel input source (Hope my understanding is correct)
Then I feel you may need to call API for the same, since there is no pre-defined custom activities
The above doc ref will help you to connect MS Project from UiPath & Create a project one by one reading from the Excel input source.
Hope this helps.
Thank you. One more question, is it possible to do from UI automation using clicks and send hot key activities to do copy, paste tasks and Filtering in Project? Thanks so much
Of course yes. But since the API method is completely background and less prone to errors that is the first recommended way.
UI Automation of course is possible on any web app. You can just build the steps in UiPath workflow which you do manually.
Hope this helps
Sorry @Nithinkrishna . MS Project I am using is a Desktop application. Thanks
Sorry for using the word web
Any type of application you can simply perform the UI Automation if there are some rule based manual steps which can be automated.
Hello hello @A_Learner
I just want to ask you how did you solve the issue please because i m facing the same problem and i probably tried every existing solution
I did UI clicks. In project select all, copy.
In Excel write cell A1 “” to keep the sheet open and paste in excel. Once in Excel, it is easier,
And how do you select all data in Ms project because ctrl+a doesn t work in project
otherwise even if i copy a big amount of data from ms to excel the button paste is shaded because excel does support a specific data size
CTRL c from Project
Excel write cell A1 (write blank) to set Focus on first cell.
click Paste button.