Read data from 1 excel and write output to another excel

Automation Studio
1

Hi Team,

We are working on a POC where we will have to read data from 1 excel and use these values for automating the UI functionality. This excel has header and many records and so we are using Excel loop. From the final page of the UI, we will have to read data and write it to a different excel. Is it possible to do this via Community edition ?

We tried to open another excel loop within the input data excel loop but it did not give us the expected result. Could you please help…

Thanks

2

Hi,

Yes the same is possible. But you cannot use Excel loop and write to excel to write in another excel.
You will have to think of some other approach

Regards,
Amit

3

I am also getting same issue. I tried using the same excel to fetch and write to. But the file gets corrupted each time. Please suggest some alternative approach.