Cannot read vaule in excel

[Stef_99 (Mary)]

I use read cell workbook as below.

But output show empty

If change column to “A3” it show value.

Please guide me for solve it.
Thank you

[Anil_G (Anil Gorthi)]

@Stef_99

check the value of int_lastrowresult…it might be something other than 3

if headers is checked then the row count would be one less

cheers

[mkankatala (Mahesh Kankatala)]

Hi @Stef_99

You have given correctly, what is the error you are facing. check what int_lastRowResult variable contains.

[yedukondaluaregala]

@Stef_99
Before reading cell add one log message activity and pass your variable there. then you can easily track it.
Cross check whether variable holding correct index or not

[Stef_99 (Mary)]

My process as below.

I want to read row from int_lastRowResult

value int_lastRowResult = 3

Please guide me for solve
Thank you

[yedukondaluaregala]

Can you share your input file if possible

[Stef_99 (Mary)]

@yedukondaluaregala

1. I want to read data from start in row that column C = Blank
2. check something in web → stamp result in column C
   3.go to next row

input.xlsx (8.5 KB)

Please guide me about it.

Thank you

[yedukondaluaregala]

Then why you are using read cell activity,

you can use read range workbook use for each datatable.
in loop use if condition check non empty or blank values on C column.
if it is blank do your process.
after completing your process based on result you can update your result in C column by using write cell activity.