MS Project to Excel

Help Studio
, ,
#1

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.

1 Like
#2

Hey @A_Learner

Kindly check the below if that will help you…

Thanks
#nK

1 Like
#3

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.

1 Like
#4

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

#5

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.

#6

Thank you @Palaniyappan. Does it need ODBC driver installation with a license? Is CDATA ODBC driver a third party? Thanks a lot,

#7

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

#8

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

1 Like
#9

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

#10

Sorry @Nithinkrishna . MS Project I am using is a Desktop application. Thanks

1 Like
#11

Hey @A_Learner

Sorry for using the word web :sweat_smile:

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

#12

Thank you.

1 Like