Spreadsheet Link™ EX

MLMissingDataAsNaN - Set empty cells to `NaN` or `0`

Syntax

`Worksheet:`	`MLMissingDataAsNaN("yes")` `MLMissingDataAsNaN("no")` (Default)
`Macro:`	`MLMissingDataAsNaN "yes"` `MLMissingDataAsNaN "no"` (Default)
`"yes"`	Sets empty cells to use `NaNs`.
`"no"`	Sets empty cells to use `0`s. (Default)

Description

Sets empty cells to NaN or 0. When the Spreadsheet Link™ EX software is installed, the default is "no", so empty cells are handled as 0s. If you change the value of MLUseCellArray to "yes", the change remains in effect the next time a Microsoft^® Excel^® software session starts.

Note A string in an Excel^® range always forces cell array output and empty cells as NaNs.

Examples

Cancel the use of NaNs for empty cells:

MLMissingDataAsNaN('no")

MLMissingDataAsNaN - Set empty cells to NaN or 0

Syntax

Description

Examples

See Also

MLMissingDataAsNaN - Set empty cells to `NaN` or `0`