Convert date time excel to string

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

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

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

1 Like


Read Cell Activity will give output as String only.

unless that is marked:


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

Cheers @UiUser

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