Doubts with excel management

Hello everyone. I have a question about OpenRpa. How can I delete an excel row that has specific text in one of its cells?.

Thank you.

There is no activity written by me, that does that.
You could probably do it by code, or maybe if you are lucky there is some excel activities on nuget that does it, but I don’t know of any. ( maybe one of these ? )
I left this un answered in hope someone else maybe had a better reply.

Generally, the idea is, we read all data using “read Range” or update/insert using “write range” … and then do all data manipulation on the datatable …
So removing a row would be easy there, and “send it back”
But i can definitely see many cases where working with data directly in excel would make sense

1 Like

Thanks Allan. I did it the way you explain and it works.
I have another question.
I try to run a robot from windows task schedule, but, when I run it from powershell script it brings the follow messege “object reference not set to an instance of an object”.
What does this error mean and how do I fix it?


Thank you very much for your help, Allan.
I’m working on it.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.