Sets or returns whether NULL values in the imported dataset be ignored or converted to blank cells.
If this is set to true, then existing values and formulas will preserved in cells, if this set to {{false}}existing data in cells will be replaced with blank cells which will clear existing formulas or cell values.
public boolean IgnoreNulls{ get; set; }
Public Property IgnoreNulls() As Boolean
//--- Get IgnoreNulls
bool ignoreNulls = importProps.IgnoreNulls;
//--- Set IgnoreNull
importProps.IgnoreNulls = true;
'--- Get IgnoreNulls
Dim ignoreNulls As Boolean = importProps.IgnoreNulls
'--- Set IgnoreNulls
importProps.IgnoreNulls = True
When IgnoreNulls is set to true it will also affect column names when UseColumnNames is also set to true.