Internal : Unable to convert supplied value to a Number : Unable to cast value '' to a number data item

tehreemasghar

New Member
I have a process that retrieves data (Student marks) from an excel file and sends it to an object that calculates the total, percentage and grade and sends data back to the process to write in the excel file. But I get the above stated error when flow reaches the action stage where data is sent from the process to the object
 

sivagelli

Well-Known Member
Check if you have blank values in excel file. One of the reasons for the exception is when there is an attempt to convert text which is blank to number.
"Unable to convert supplied value to a Number : Unable to cast value ' ' to a number data item"
 

SERBEM

Member
Could this error message come, because there is a blank cell in your Excel file somewhere, it you replace it with a 0 it should work. Or if you start with a data item thats blank and define as a number from start, it needs to be 0.
 
Top