Check which excel field is empty for imputing data. (condition)

I have a workflow that takes some information from the web and passes it to the main excel, I also get information from another excel and step into the main excel, ie I impute information to the main excel 3x.
I would like to know how to make a condition to recognize if excel already has data, if it has it need to paste the new data into the next blank cell, can you do that? could you send me an example?

I’m going to send my workflow and the final excel filePasta1.xlsx (10.1 KB)
Mainflow.xaml (15.6 KB)

Hi Beatriz,

you can set up this conditional using an If activity. The example uses a Read Cell activity to get the data written to a given cell and saves it to a variable named cell. If cell is an empty string, then the cell read in the Read Cell activity was empty and the If activity will execute the Then block. Otherwise it will execute the Else block.

I’ve uploaded your workflow with the example above included :slight_smile:

Mainflow.xaml (17.8 KB)

also consider looking into the Append Range activity, it might be exactly what you’re looking for in this case