Issue with blank cells in data import

[brendanmeyer]

Hey

There is an issue where blank cells are not handled.
The instance I had was there the field was an integer, and the import tool expected an integer, but the cell was empty.

I modified the following line to handle blank integer cells
Line 1057
from
if (cellValue == null || xlRange[1, iCol].value == "")
to
if (cellValue == null || (cellValue is string && String.Compare(cellValue, "") == 0) || xlRange[1, iCol].value == "")

[jionnyMagiah]

I'm facing this issue also with lookup fields. I get this error message

Something went wrong while fetching record for lookup: [field_name].  Record will not be imported. 
EXCEPTION MESSAGE: The ConditonOperator.Equal requires 1 value/s, not 0. Parameter Name: [parameter__name]