Write data in the first empty row


i want to find the first empty row and write the data in it (i dont want to use append range activity) please helpwriteInEmptyRow

@Muthulakshmi_Thangamuthu -

  1. Read Range - call the datable as Dt Say.
  2. Assign IntRowcount = Dt.rows.count.tostring. This will give 3…
  3. So inorder to write in the first empty row…you have to “A” + (Introwcount+2).tostring or “B” + (Introwcount+2).tostring

Hi @Muthulakshmi_Thangamuthu

Try this

1 . Read the excel and store in dt1

  1. then loop through each row using for each row
    inisde it use , the assign activity as below

row(ColumnName)= value

. outside the loop , use write range to write the updated datatable


Nived N

Happy Automation


Main.xaml (9.7 KB)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.