How to search for data in Excel

[balupad14 (Balamurugan)]

Hi @nick.v,

To search the data inside excel, you can use the “Find” activity which is in the below. It returns the cellinfo and rowindex.

UiPath Go ! BalaReva EasyExcel Activities

Hi, A situation to find and replace the text inside the Excel. For that purpose, I have developed some activities below. Find - Find the text inside the sheet. It will return the cell info as an array string and row indexes. FindReplace - Find and replace the text inside the Excel sheet. [image] [image] Regards Balamurugan.S

Video explanation :

Uipath Excel Find | Search | Find and Replace (BalaReva)

Delete the row.

UiPath Go ! BalaReva EasyExcel Activities

Hi , I have developed a new activity to delete the contiguous rows in side excel sheet in the package version 6.0.0. You can get the package Here. Important Property : Row Range : { “1”,“3:5”,“11”,“20:35” } Namespace : [image] Activity and Properties : [image] Regards Balamurugan.S

Uipath | excel delete rows | excel delete columns | excel copy as picture (BalaReva)

Regards
Balamurugan.S