Learn more about 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 0s. (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 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")

See Also

MLPutMatrix

MLGetVar

MLOpen

© 1984-2009- The MathWorks, Inc.    -   Site Help   -   Patents   -   Trademarks   -   Privacy Policy   -   Preventing Piracy   -   RSS