View Source

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.