Read Value From Excel File Step

0
0

Hi

I am encountering the following problem. I read a date value from an Excel file using the step “Read Value From Excel File Step”. This value is passed into a string variable within the step itself. However, when I try to extract only the date without the timestamp afterward, I get the following error:
“Unable to cast object of type ‘System.DateTime’ to type ‘System.String’”.

This happens when i try the “Get Subtext Step” or “Trim Text”.

This also happens if value is number in excel file, then i get the following error;

System.InvalidCastException: Unable to cast object of type ‘System.Double’ to type ‘System.String’.

  • You must to post comments
Showing 0 results
Your Answer

Please first to submit.