Page History

{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.{excerpt}
{signature:C#}
 public boolean IgnoreNulls{ get; set; }
{signature}{signature:vb.net}
Public Property IgnoreNulls() As Boolean
{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
        {code}

{example}

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