Bootstrapping with incomplete rows

I've got an Excel file to import. Not all the data is complete. Some cells are empty - no default value.

Rather than messing with the file, I want to improve my Bootstrap code.


So in the assign I want to do something like:

If(
    ConvertFromExcel.Current.Excel_Sheet.Latitude = <empty>,
    0,
    ConvertFromExcel.Current.Excel_Sheet.Latitude
)

How can I check if the cell is empty?

Cheers,

Roy

You cannot. Unfortunately, all empty values are parsed and the parsed value is put into the Structure. There's no way to check for an empty value other than checking against "", 0 etc.