Wiki Markup |
---|
{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} |
Page History
Overview
Content Tools