Updating Excel rows

Hi Experts,

I have a requirement were i need to i need to read values from one Excel and upon some condition in SAP, i need to write the result into another excel.
In the result Excel i need to write the values row by row, consider result Excel have 3 columns and i had filled the values in first row of excel and in next iteration i need to fill the data in second row and soon, all this should be done dynamically.

Please help me to achive this.

Thanks in Advance

Hy @vikram.g,

You could try the following:

  • Use the ‘Excel Application Scope’ activity combined with the ‘read range’ activity to get data from your excel
  • Create a data table with all the fields you need
  • depending on your condition add new rows to this data table, using the ‘add data row’
  • At the end of your processing, append this data to your second excel, using the ‘append range’ activity, inside another excel application scope

Is it clear to you?
Please let me know if you have any questions