I can’t see this mentioned here, maybe I’ve been searching wrong or unlucky finding. I currently have a process which reads 35 cells from across an excel workbook, stores them as variables, and fills in a word memo. It was working fine until someone returned a file without having filled in a cell as required. If it was a string I’m sure it would have been fine, but it’s a double, so…if the cell is blank I get the following error:
System exception.DoubleConverter cannot convert from (null)
How do I tell UiPath to check the cell, if it’s blank say “BLANK” or something similar, otherwise give the value as a double. I assume an if statement, but not sure how I’d read a cell which might be blank ( which is mainly where I’m stuck). I feel I will have to apply this learning to all 35 cell reads, although with generic and string it doesn’t seem to be an issue.