Excel Range

Help Robot
,
1

Hi team want to add two no like

image
image1360×768 57.1 KB

LikeM6:M12 I want output

2

@Kuldeep_Pandey,

To read a cell value from Excel and add it to another cell value using UiPath, you can follow these steps:

  1. Use the “Excel Application Scope” activity to open the Excel file.
  2. Use the “Read Cell” activity to read the value from the first cell. Set the “Cell” property to the cell you want to read, and the “Output” property to a variable that will hold the value.
  3. Use the “Read Cell” activity again to read the value from the second cell. Set the “Cell” property to the cell you want to read, and the “Output” property to a variable that will hold the value.
  4. Use the “Assign” activity to add the two cell values together. Set the value of a new variable to the sum of the two cell values, like this:sum = cell1 + cell2Where “cell1” and “cell2” are the variables that hold the values from the two cells you read.
  5. Use the “Write Cell” activity to write the sum to a new cell in the Excel file. Set the “Cell” property to the cell where you want to write the sum, and the “Value” property to the variable that holds the sum.
3

Can You simply help me to add two value in assign activity ? Like "m6+“6”=M12

4

HI @Kuldeep_Pandey

Try like this

In Assign give just range without +6

While giving range in excel activities give like

System.Text.RegularExpressions.Regex.Match(AT,".*(?=\d+$)").Tostring+(Cint(System.Text.RegularExpressions.Regex.Match(AT,"\d+$").Tostring)+6)

Regards
Sudharsan