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.

2 Likes
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

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

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
13

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

14

Hi @lina_Sahli
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,

Thanks,

15

Hi @A_Learner
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

16

CTRL c from Project

Excel write cell A1 (write blank) to set Focus on first cell.

click Paste button.

1 Like