I’m currently automating a process with the REFramework, where I have an Excel database with the IDs of some people, and I must look their IDs in the local governement’s webpage in order to see if they owe any traffick tickets. Basically, after the search, some data needs to be scraped from the website and put back into the Excel.
I’m using DataRow as TransactionItem and DataTable as TransactionData.
The process is working fine, but I had some trouble deciding where to put the WriteRange activity for updating the Excel file. If I put it in the “ProcessTransaction” then the Excel would be opened at every transaction, what seems to me not to be very efficient. However, if I put it on “End Process” it is like that there is no place designed for that kind of activity there, so I’m not sure which would be the best practices within the REFramework for writing into the output files.
I appreciate any suggestions you may have!