Page History

...

Sets or returns whether NULL values in the imported dataset be ignored or converted to blank cells.

...

{description}
{excerpt}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.

...

{signature}
{example}{code:csharp|title=C#}

          //--- Get IgnoreNulls
          bool ignoreNulls = importProps.IgnoreNulls;

          //--- Set IgnoreNull
          importProps.IgnoreNulls = true;
        

{code}
{code:vb.net

|title=vb.net

}

          '--- Get IgnoreNulls
          Dim ignoreNulls As Boolean = importProps.IgnoreNulls

          '--- Set IgnoreNulls
          importProps.IgnoreNulls = True
        

{excerpt}
{signature:C#}
 public boolean IgnoreNulls{ get; set; }

{signature}{signature:vb.net

}
Public Property IgnoreNulls() As Boolean

{code}

{example}

{remarks}When {{IgnoreNulls}} is set to {{true}} it will also affect column names when {{UseColumnNames}} is also set to true.
{remarks}