Hi,
I have an excel file and I am trying to use Read Range activity to copy data from worksheet of that file to another excel file. I cannot figure out what needs to be in the “DataTable” field of the Read Range properties. There isn’t any or near zero info about this on the web or in openRPA documentation (by design?). Can someone please share a snapshot of what the properties fields are filled out so that the Read Range works? All I need is an example please.
Guys, really really could appreciate some more proactivity here
There is no direct example of what you are asking.
But i remember a video being made a few years ago showing comparing excel sheets, that will show both reading and writing.
The important part is to keep in mind, that datatable is a database in it self, so if you just want to move data, you can read using read range and just use the same datatable with write range to move the data. But I assume you want to add/remove or transform some of that data, and in that case you either create a dataview ( to filter/select or remove rows ) or copy data from on table to another using loop
the video is really old, and has horrible sounds, so if you just want examples, there a few here that also works with excel
Hi @Allan_Zimmermann ,
Thank you for this. It solved all of the issues I had.
The only question I have left is about the Read range what is te example syntax for “lastUsedRow”. If you have an example please kindly share with me.
lastUsedRow just returns the last row that contains data for the range you selected ( if no range was defined, then the entire worksheet)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.