Excel remove activities

[siva_sankar]

In excel data I need to remove the last two row
So what can do now in filterdata tar or filtered table
Please give me the scenario also.

[ImPratham45 (Prathamesh Patil)]

Use filter datatable
and use condition as
uploadquatation = “Upload to AX”

and use remove row option

[siva_sankar]

Right
Where I drop remove row option

[ImPratham45 (Prathamesh Patil)]

U already did it in screen shot

[siva_sankar]

But still not remove that

[ImPratham45 (Prathamesh Patil)]

Now u can write that datatable in new sheet u will get data without that rows which contains “Upload to AX”

[siva_sankar]

I done it but it’s not worked still

[siva_sankar]

[balupad14 (Balamurugan (BalaReva))]

HI @siva_sankar,

You have 2 options to delete the last 2 rows.

First one.
- Use find last row index activity

UiPath Go ! BalaReva EasyExcel Activities

Hi , I have developed 2 new activities. Find LastColumn that to find the last column Index and Column Name of the sheet . Find LastRow that to find the last row of the sheet and it returns the row index. [image] [image] Find LastColumn’s Properties : [image] Find LastRow Properties : [image] Note : If the sheet name is empty , It will take the first sheet name . Here is the video demonstration. [UiPath excel Extract Graph as Image | find last column Index| find last Row No…

UiPath excel Extract Graph as Image | find last column Index| find last Row No (BalaReva)

• Use the delete activity from here.

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

Second option :

• Use find activity with the word “Upload to AX” . It will return the row indexes.

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

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

• Use the delete activity from here.

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

Thank you
Balamurugan.S

[ImPratham45 (Prathamesh Patil)]

If you are write it on that sheet only then it will show as previous as last two rows of previous data is still there
write it in another sheet using write range
Or u can use as @balupad14 suggested.

[siva_sankar]

I did that also but still not changed in other sheet also

[ImPratham45 (Prathamesh Patil)]

share your workflow.

[siva_sankar]

demo.zip (32.1 KB)

here it is the workflow zip file

[siva_sankar]

Did you solved that issue???

[ImPratham45 (Prathamesh Patil)]

sorry i just saw

[siva_sankar]

ok please make it for me i am struggling with this

[ImPratham45 (Prathamesh Patil)]

demo.zip (32.9 KB)
try this

[Pratik_Wavhal]

Hi @siva_sankar

Actually der is one blank space infront of the word in excel
Like this " Upload to AX"

I have updated the workflow now and it is giving output also that you want.
Updated demo.zip (38.4 KB)

Output :-

Mark as solution and like it

Happy Automation

Best Regards
Er Pratik Wavhal

[siva_sankar]

Thank you so much

[siva_sankar]

Thank yoy