865852_en-US

liliconcom

Missing Value Codes Don't Export To Excel

I need to export some JMP files to excel and cells that were marked as missing are empty in the resulting Excel file.  Anyone figure out a way to keep it present?

Automation and ScriptingRe: Missing Value Codes Don't Export To Excel

To clarify, missing as a result of being a missing value code.

Re: Missing Value Codes Don't Export To Excel

If you have marked them as missing, why would you wish to display them? You could create a subset, remove the column property and save after that.

Re: Missing Value Codes Don't Export To Excel

Jarmo

 

I mark them as missing because they are error codes and should be excluded from the analyses.  Numeric error codes are used to preserve the column Data Type as numeric, however, the actual number has no relevance.  If I lose the cell value on import, I also lose information about the nature of the error.

Re: Missing Value Codes Don't Export To Excel

Have you tried saving the data table out to the CSV format instead of the Excel format?  Excel is good at working with both Excel files and CSV files.

 

When I save a data table as CSV, it retains the Missing Values (missing value codes) and when I save it as an Excel file, the missing value code values are missing, just as you described. Perhaps this difference in behaviors for the different formats has the solution to your problem.