Assign activity

[Pandiyan_D]

Hi, I tried to pull the data from 7th row - cell 1 value from excel, using below assign activity. but this is not getting worked out. can you assist to provide some valuable assign expression?

[PrankurJoshi]

Just write datatable.rows(rowindex)(columnindex).tostring

[Pandiyan_D]

@PrankurJoshi

datatable.rows(rowindex)(columnindex).tostring

Hi, thanks. its working now

[Pandiyan_D]

Hi @PrankurJoshi,
What is the activity need to use to grab specific data from web page to paste in excel sheet?

[nadim.warsi]

use DataScraping and the result will be a DataTable which you can write into Excel.

[Pandiyan_D]

Hi,
What activity need to use to delete some rows based filter option in data table? Thanks.

[nadim.warsi]

Use this

Delete data row from data table

I am having a excel in format [image] Now I want to delete all the row where Status=“PV”. Please suggest a solution. I want to perform this action using one database table only.

or

Remove data row example

Hi, I am trying to learn ‘Remove data row’ activity of Uipath. Can anyone please provide a simple workflow that can be understood easily.Thank you.

2 solutions to your requirement

[NavneetPanpaliya]

Hey @Pandiyan_D, you can also use Filter Data Table activity to delete row’s based on conditions. Refer below print screen but ignore errors as I edited my working code to give you an example so I hope it will help you to resolve your issue…

e.g ColumnName (i.e. Column1) Cotains ColumnValue (“John”) —> This will delete Row2

Thank You,
Navneet
Happy Automation!

[Pandiyan_D]

Hi @NavneetPanpaliya,

I couldn’t pull Filter Wizard activity from activity panel. Could you pl help me to share some XAML file?

[PrankurJoshi]

Does this mean you could not find the Filter Datatable activity?

[NavneetPanpaliya]

Hello @Pandiyan_D,

Attached sample XAML file for your reference. Hope this will help you to resolve your issue.

Filter Data Table.xaml (8.2 KB)

This is how csv file looks like which UiPath could not allowed to attached.

Thank You,
Navneet
Happy Automation!

[Pandiyan_D]

Hi @NavneetPanpaliya,

I have used for each row activity in excel data table to do the same activity for each rows.
It’s running whereas data’s are being picked from 1st row only not going to next rows. Can you pl suggest that what would be the reason? thanks.

[NavneetPanpaliya]

Hello @Pandiyan_D,
I guess issue should be with excel file. You can also try using csv file instead of excel and check whether you are still facing the same issue.

Also it would be very helpful if you can provide screen print of your workflow or attach excel and XMAL file so that I can check what causing issue?

Thank You,
Navneet
Happy Automation!

[Pandiyan_D]

Open web browser.xaml (111.3 KB)
Bailment RFS.xlsx (38.4 KB)

Hello @NavneetPanpaliya,
Attached the both the files. Pl check and support. thanks.

[Pandiyan_D]

Hi @NavneetPanpaliya, Can you pl check and help for above request?