Convert date time excel to string

[UiUser]

the program reads an excel sheet which may have either strings or date type text within the cells. Is there a way to consistently have it be converted to string type variables within UiPath no matter the data type in excel

[Palaniyappan (Palaniyappan P)]

Hi
Usually when the datatable from excel is read with EXCEL APPLICATION SCOPE and READ RANGE activity it will give us a datatable as output with all columns of type string only

Cheers @UiUser

[UiUser]

@Palaniyappan
Does the read cell activity do the same? because i am getting this error when using it:

[lakshman (Ganta lakshman)]

@UiUser

Read Cell Activity will give output as String only.

[bcorrea (Bruno Correa)]

unless that is marked:

[Palaniyappan (Palaniyappan P)]

Yah it does of course
Kindly change the type of that read cell output variable to UiPath.core.GenericValue

Cheers @UiUser

[RAKESH_KUMAR_BEHERA]

Any one who is still following this thread, this may help: UiPath VB.Net Complete Tutorial (System DateTime)