Doubts with excel management

[Migue_Falk]

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.

[Allan_Zimmermann]

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

[Migue_Falk]

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?

Thanks

[Allan_Zimmermann]

Scheduling Robot

This question comes up a lot. There is several ways you can run a robot at an interval. NodeRED The primary way you do that is using NodeRED. NodeRED has several modules for scheduling new messages, I normally go for node-red-contrib-cron and lookup the syntax at crontab.guru [Scheduling1] External application You can schedule jobs from an external application, or using Microsoft task scheduler and then execute a workflow using command line parameters to the robot. You have 2 options for in…

[Migue_Falk]

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