Printing particular cell

How can we print/write the specfic cell value.
I tried but it gives me null value.
I printed - row(“A9”).tostring

but gives me null

@Palaniyappan
image

How you are trying to print it?

1 Like
  1. using the excel scope
  2. read range
  3. used write activity - row(“A9”).ToString

But gives me the null value

Hi,

Where are you trying to print it to? Have you stored the selected data from the cell into variable in your project?

No directly I am printing it. I want to used this value and writing somewhere.

1 Like

Could you give a screenshot of your workflow? Are you trying to input this value into a textfield of a browser/app?

yes exactly bro

1 Like

well we need to mention like this buddy @balkishan
use read range activity and get the output of the variable named OutDatatable
OutDatatable.Rows(9)(0).ToString

or we can use Get Row Items activity

Cheers @balkishan

3 Likes

what to do if I have like 4 columns and I want to print the D11?

1 Like

Use get row items activity and mention the column index as input n the property here
and mention the datatable as @balkishan
here i mentioned as rows(0), where 0 is the first row
you can mention as 3 for the fourth row

1 Like

any issues still buddy @balkishan

1 Like

were you able to get the values now
Cheers @balkishan

1 Like

Bro let say I want to print the B19 then what to do. ?

OutputDatatable.Rows(18)(1).ToString
where OutputDatatable is the varaible obtained from read range activity
18 is the row index as we have first one as header and row index starts from 0
1 is the column index of B column and it starts from 0
Cheers @balkishan

Test is my where I stored the Read Range activity. what is this error bro?

1 Like

buddy i said the above expression can be used in a assign activity

here when we use a get row item we need to mention like this alone
Test.Rows(8)
and in columnindex property we need to mention as 2 in the get row item activity property
Cheers @balkishan

1 Like

did that work buddy @balkishan

1 Like

what is the OutputDatatable how did you get this bro?

As I get Test bro Read Range Activity like this ?

Well its just a variable that i named for the one we get from read range activity buddy
Cheers @balkishan

1 Like

Okay Okay got it

But same way I did why showing error?

1 Like