Cannot find the "Open Workbook" activity in UiPath Community Edition

[harsha8687 (harsha vardhan)]

Hi Team,

My aim is to open the excel workbook and work on the excel which is opens and perform some operations such as finding a specific item by using Ctrl+F and i want to replace a specific field. Is this possible in the version 2018.2.3 version. I have also added “UiPath.V7.Activites” package as per some of the threads. I have also tried with Excel Application Scope by checking the Visible option but could not open the excel.

Any suggestions will helpful.

Thanks & Regards
K Harsha Vardhan

[balupad14 (Balamurugan)]

Hi @harsha8687,

Currently UiPath has been release the new version 18.3. Give a try.

I have created the custom activity for you situation. You can use this to find and replace text inside the worksheet.

BalaReva.Excel.Activities Continue

https://forum.uipath.com/t/balareva-excel-activities/38367?u=balupad14 I continue the above thread here due the length of the thread. Hi Friends, I have included a new activity called “Find Replace”. Using this activity can find and replace the text into the excel. It has the find option like below Part Match against any part of the search text Whole Match against the whole of the search text Namespace [image] Properties [image] Samples :FindReplace.zip (7.8 KB) Note : T…

Regards
Balamurugan.S

[SimonLenz (Simon)]

@balupad14

Currently UiPath has been release the new version 18.3. Give a try.

Seriously? I couldn’t find the “open workbook” activity and just updated my versio to the latest version of UiPath’s versions. Any advice?

[Anandhu (Anandhukrishnan V)]

Hi I couldn’t find Open Workbook activity in Uipath. However i was able to copy the activity from a workflow i downloaded from net and paste it into my workflow and it was working.