Write data in the first empty row

Help Studio
1

Hi,

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

2

@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
3

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

Regards

Nived N

Happy Automation

4

@Muthulakshmi_Thangamuthu

excel_null
excel_null577×621 32.3 KB

Main.xaml (9.7 KB)