Error using columns(input1.Columns.IndexOf(col)) + (input1.Rows.IndexOf(row)+2).ToString

Help
1

I have a workflow that takes information from the web and a file in excel and pass it to another file, however the initial excel file already contains data, I made it a condition for it to recognize the cell that is empty and impute the data, however error in write cell.
can anybody help me?

cap1
cap11600×900 83.7 KB

2

@Beatriz what columns variable contains.

can u post range section value here?

3

@Beatriz Instead of identifying the cell empty you can use Append Range Activity
all you have to do is,

Step 0: By using activity Build DataTable create one DT.
Step 1: Take the data into variable [ The data you want to write it in excel ]
Step 2: By using Add Row Activity assign that data to a DT.
Step 3: Outside the loop use Append Range and pass that DT.