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
Does the read cell activity do the same? because i am getting this error when using it:
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
Any one who is still following this thread, this may help: UiPath VB.Net Complete Tutorial (System DateTime)