I need to create one excel with two columns(Sequence Id, Status) for generating the report of invoice process.
Step1: I used Build Data Table activity to add the Column headers as Sequence Id and Status
Step2: Used Add data row activity and mentioned two ArrayRow(Seq_Id and Status)
Step3: Used write range activity to write the data table into an Excel.
While using write range activity by default Range set as A1, If the BOT start processing next seq_Id its not appending a new row.
Its owerriting the existing row. How can I append row in excel?
Can anyone help me on this?