I Want to read the value of cell

Help Activities
, ,
1

hello everyone i want to read the value of cell where formula is applied on back end . while using read cell activity i am not getting value.

2

Hi @Dheerendra_vishwakarma

Can you try the below

The image shows an Excel automation process in a software tool, reading a cell value from an Excel file and displaying it in a message box with the value "400". (Captioned by AI)
The image shows an Excel automation process in a software tool, reading a cell value from an Excel file and displaying it in a message box with the value "400". (Captioned by AI)949Ă—717 26.8 KB

Input:

The image shows a spreadsheet with columns "Amount1," "Amount2," and "Final," where the "Final" column contains the sums of the corresponding values in "Amount1" and "Amount2." (Captioned by AI)

Regards,

3

@lrtetala ,

Thank u for your reply.

how can i do with classic activities?

4

@Dheerendra_vishwakarma

The image displays a UiPath automation workflow that reads the value from cell C2 of an Excel sheet "Sheet1" and shows it in a message box, with a visible message box showing the value 400. (Captioned by AI)
The image displays a UiPath automation workflow that reads the value from cell C2 of an Excel sheet "Sheet1" and shows it in a message box, with a visible message box showing the value 400. (Captioned by AI)786Ă—432 14.5 KB

Regards,

5

@lrtetala ,

i want to use LINQ in Place of “C2” is it because at everyday new cell will be fatched from same column is it work ?

6

@Dheerendra_vishwakarma

Yes it would work…If the input is like C2,C8,C20…like that

Regards,

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.