Column multiplication

[lakshmi3 (lakshmi)]

hi
i’ve extected the data from web and saved in the excel …
now i need to multiply the column from (A1:A23)with this NUMBER 2.151
how can we give this in the uipath

[Sagar_Gupta1 (sagar Gupta)]

Excel Input is
:

use Read Range activity to get all Value from Excel

Use For Each Row

then assign value with multiply value

then
use Write cell to get an output

Excel Output:

[lakshmi3 (lakshmi)]

getting this error

[tdhaene (tom Dhaene)]

Change the type of value to system.double

[lakshmi3 (lakshmi)]

changed it now the error in the write cell activity…as indexvalue in the assign is not declared

[Sagar_Gupta1 (sagar Gupta)]

Change value variable type to System.double

[lakshmi3 (lakshmi)]

changed it and getting the error in the writecell activity as indexvalue is not declared

[Sagar_Gupta1 (sagar Gupta)]

Declare Indexvalue in property of For Each Row Activity

[Sagar_Gupta1 (sagar Gupta)]

let me know if any doubt

[lakshmi3 (lakshmi)]

[Sagar_Gupta1 (sagar Gupta)]

make indexvariable type to integer not double

[lakshmi3 (lakshmi)]

now it is object reference not set to an instance of the object

[Sagar_Gupta1 (sagar Gupta)]

sfgdfgh.xaml (6.3 KB)
use this workflow
Hope it work fine

[lakshmi3 (lakshmi)]

IT’S THE SAME Main.xaml (6.7 KB)
STILL GETTING THE ERROR

[Sagar_Gupta1 (sagar Gupta)]

Remove “B” it will be empty like this

[Sagar_Gupta1 (sagar Gupta)]

remove 3 from C3

Like this

[lakshmi3 (lakshmi)]

IT ACTUALLY HAS TWO ROW AND I NEED TO MULTIPLY THE SECOND ROW AND NEED TO ADD THAT DATA INTO ANOTHER XCEL FROM THAT ROW THAT’S REASON

[Sagar_Gupta1 (sagar Gupta)]

are you trying this?

[Sagar_Gupta1 (sagar Gupta)]

let me know if not clear and still having problem

[lakshmi3 (lakshmi)]

yes tried now still this error is occuring