How to use this activity? I am familiar with the old versions and it was easy. I am trying to achieve the very basic thing. Iterate a 2 column excel and write the values in the output panel. I am not able to achieve it with this new packages.
I used the below:
Excel process scope
Use excel file - here I gave the file path
Then I was thinking to give read range, but I cannot find how to read the whole excel range! Previously leaving just “” under range will do the work. Now it is not working.
Since it is not working, I directly jumped to For each excel row.
I tried to give the sheet name as Excel.Sheet(“Input”) and I tried to write line each row items.
I am getting error like cannot convert integer to string…