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
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
@Palaniyappan
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:
2 Likes
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)