Need to copy value and need to paste in column till the rows ends

  1. Read the sheet and name as dtdata.
  2. Now use assign activity and assign strIndex (string type) = (dtdata.rowcount+1).ToString
  3. Next use Fill range - where to write - Excel.Sheet(“Sheet Name”).Range(“J2:J”+ strIndex)
    what to write - “23/12/2024”.