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.

...

Signature

	C#
	C#

 public boolean IgnoreNulls{ get; set; }
{signature}{signature:

}

Signature

	vb.net


	vb.net

Public Property IgnoreNulls() As Boolean
{signature}
{example}{code:csharp|title=C#}

Example

Code Block

	csharp
	csharp
title	C#



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

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

{code} {code:

Code Block

	vb.net

|title=


	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}

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

Space Shortcuts

Page tree

Versions Compared

Old Version 10

New Version Current

Key