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.
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.
Hi
I found this one pretty useful
Have a view on this
https://www.cdata.com/kb/tech/msproject-odbc-uipath.rst
Cheers @A_Learner
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,
Hey @A_Learner
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
https://docs.microsoft.com/en-us/connectors/projectonline/#creates-new-project
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.
Thanks
#nK
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
Hey @A_Learner
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
Thanks
#nK
Hey @A_Learner
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.
Thanks
#nK
Thank you.