I have tried to build a basic POC. THe process should read from an excel, do some web actions, write results to excel, and finally send an email with the results.
The web automation was easy.
Reading the excel requires me to download 1.1.5 RPA version.
The logic implementation is simple.
However when i tried to write the results to an excel it was nearly impossible. I have tried all options without any results. I attach an image with my write results example.
The list is now pre-defined in order to simplify the problem.
The 2 set cells are both failing. The first one writes a fixed value in a variable and the second one the value of the list.
I have tried to write to the excel without the loop and it works perfectly.
However. It seems that it’s not going inside the loop i suppose it could be the filter option but i tried with empty value, 1-100 and other examples any of them works.