Search for cell details and copy corresponding row in Excel

[John_Dara (Oluwadara John)]

Hi,
I have been able to automate the use of find and replace in an workbook but i also want to copy the corresponding row to use some of the details from the row in another workbook, how can i achieve this?

[Ragu9060 (Raguvarthan)]

@John_Dara, follow below steps to achieve your requirement.

1. Read the excel using read range activity.
2. Build a another data table with required columns.
3. Use For each row activity to get the row data one by one.
4. Maybe if you have any condition use if activity to filter rows based on the condition.
5. Then use add data row activity to populate the built data table.
6. Use write range activity along with passing the built data table, which will create a excel with built data table.

[John_Dara (Oluwadara John)]

Thank you @Ragu9060 would try this

[balupad14 (Balamurugan (BalaReva))]

Hi @John_Dara,

The BalaReva.EasyExcel package has 2 activities called “Find” and “Find and replace”. The find activity returns the RowIndex and CellInfo. The Find and replace will do the normal process.

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

ToCopy Past you can use these.

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed the new activity in the package of BalaReva EasyExcel.Activities .It is called “Copy ToClipboard” .It copies the excel data to the clipboard. (The BalaReva.Excel.Activities have the same activity called “CopyData”) [image] Sample : ExcelCopyPaste.zip (26.4 KB) Thank you Balamurugan.S

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed the new activity in the package of BalaReva EasyExcel Activities. It is called “Paste Clipboard” . It paste data from the clipboard . That means you can copy the data anywhere(SAP,text editors and etc…) [image] Thank you Balamurugan.S

Regards
Balamurugan.S

[John_Dara (Oluwadara John)]

Hi @balupad14
The activity refuses to install, and i’m using a 2019.10 version, what can i do?

[John_Dara (Oluwadara John)]

@Ragu9060 I want to select just one row after searching for a particular cell value from the sheet and use some of the details and the cell value is subject to change.

[balupad14 (Balamurugan (BalaReva))]

Can you share me the screen of the error please ?

Thank you
Balamurugan.S

[John_Dara (Oluwadara John)]

[balupad14 (Balamurugan (BalaReva))]

Hi @John_Dara,

Go to this one.,

Second…

Important thing is . You must have installed the Ms Office Excel in your system.

Regards
Balamurugan.s

[John_Dara (Oluwadara John)]

HI @balupad14
I’m still getting the same result with the new one

[John_Dara (Oluwadara John)]

@balupad14
Please check out the error messages

[balupad14 (Balamurugan (BalaReva))]

Hi @John_Dara,

I have to check it. I have a lot messages and request changes. Definitely I will take a look and ping you soon. It would n’t be a big thing. It should be a small changes…

Thank you
Balamurugan.S

[balupad14 (Balamurugan (BalaReva))]

Hi,

• Use the Find activity from BalaReva.EasyExcel Package.
• You can get the row indexes from it as array.
• Do a loop and use the copy paste from UiPath Excel package.

Thank you
Balamurugan.S

[John_Dara (Oluwadara John)]

Hi @Ragu9060
what i want to achieve is to search for a variable cell value then copy the cells row items in the same workbook and then insert some of the details copied into another workbook