Excel Activities Empty Column , Go Next Cell

Help Activities
, ,
1

In UiPath Excel Activities How to work on the following task
Go to the next empty Column
Go to the next cell
Go to the right cell
Go to the left cell
Go to the next empty cell

All these things are frequently needed. Blue Prism and Automation Anywhere are already having all of these.

2

@Sushma_Ganapatisa

we dont have such activities here…generally what we do is use a counter and increment it and sue

or read whole data into datatable and then work on datatable and then write back

let me know your usecase if there are any specific ones we can help you model them

cheers

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

7

resultArray = System.Text.RegularExpressions.Regex.Matches(“01 abc02 cde”, “\d+[a-zA-Z]+”).
Cast(Of System.Text.RegularExpressions.Match)().
Select(Function(m) m.Value).
ToArray()

Toibdufng

8

Use the "Read Range activity to read the first row.
Iterate through columns using a For Each loop to find the first empty column.
1.Use "Write Cell"to write data in that column.
Alternatively we can use Vb.net
Go to the Next Cell

  1. Read data using “Read Cell”
    Identify the next row (CurrentRow + 1)
    Use “Write Cell” to move to the next cell.

  2. Go to the Right Cell
    Move right using “Column Index + 1” and write data using “Write Cell”.

  3. Go to the Left Cell
    Move left using "Column Index - 1"and write data using “Write Cell”.

  4. Go to the Next Empty Cell
    Use “Read Range”, loop through the cells to find the first empty one, and use “Write Cell” to insert data.
    It would be great if UiPath could introduce built-in navigation activities for these common Excel operations.

9

resultArray = System.Text.RegularExpressions.Regex.Matches(inputString, “(\d{2}[a-zA-Z]+)”).Cast(Of System.Text.RegularExpressions.Match).Select(Function(m) m.Value).ToArray()