View Source

Sets or returns whether NULL values in the imported dataset be ignored or converted to blank cells. Blank cells will override 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