Page History

...

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 existing formulas or cell values.

Signature

	C#
	C#

 public boolean IgnoreNulls{ get; set; }

...

Example

Code Block

	csharp
	csharp
title	C#


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

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

Code Block

	vb.net
	vb.net
title	vb.net


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

          '--- Set IgnoreNulls
          importProps.IgnoreNulls = True

Remarks
When `IgnoreNulls` is set to `true` it will also affect column names when `UseColumnNames` is set to true.

Space Shortcuts

Page tree

Versions Compared

Old Version 2

New Version 3

Key