About read cell

[herowhite (Bh)]

Why can’t I print any information? As shown in the figure, should there be no problem with the settings or inputings?

[Yoichi]

HI,

Did you set variable at Output-Result property as the following?

Regards,

[pravallikapaluri (Pravalli)]

Hi @herowhite
check the variable passage

Hope it helps!!

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @herowhite
You must set Output for Read Cell

Regards,

[herowhite (Bh)]

If u do that,something else happens ,like this.

[pravallikapaluri (Pravalli)]

May I know data type of the read cell activity of Output Variable.
Try Using A1_data.ToString in the log message

[Yoichi]

Hi,

Can you try to use GenericValue type?

If you need to string type, please use ToString method like A1_data.ToString()

Regards,

[Parvathy (PS Parvathy)]

Hi @herowhite

After you use Read Cell activity when you store the output in an variable it is of type String. You can change the variable type of A1_date to System.Object data type so it will accept any string or integer value.

Hope it helps!!

[mkankatala (Mahesh Kankatala)]

Hi @herowhite

Open the properties of read cell workbook activity and check the preserve format option.

In log message activity in message field give the Variable.toString then it will print the value in the output panel.

The output of read cell workbook is coming double just change to string by giving Variable.toString.

Hope it helps!!

[herowhite (Bh)]

You are right!
Why let the “A1_date” be “string” is a mistake?

[Parvathy (PS Parvathy)]

@herowhite
It’s not a mistake since you are storing an int value in that cell. It will throw you an error like string cannot be converted to Double. In case of Object Data type it will accept all datatypes like string,int,double etc

Hope you understand!!

[herowhite (Bh)]

Thank you very much!