Excel Activities Empty Column , Go Next Cell

Help Activities
, ,
5

Hii, in UiPath there are no such activities available for these but there are some vb expression to get this .

  • Next Empty Column: Use Find First/Last Data Row and determine the last column with data, then use Write Cell in the next column.
  • Next Cell: Use CurrentCell.Offset(1,0).Value in VB.NET to move down.
  • Right Cell: Use CurrentCell.Offset(0,1).Value.
  • Left Cell: Use CurrentCell.Offset(0,-1).Value.
  • Next Empty Cell: Loop through the column using IsEmpty(CurrentCell.Value)

i hope this will be useful