I have data in an Excel spreadsheet such that some cells contain text and other cells contain numeric data. If I put this data into MATLAB, it should appear as a cell array whose cells all contain strings. Even the numeric data should be exported as strings. This is documented at the following URL:
However, in Excel Link 2.1(R13SP1), the exported cell array contains mixed data. That is, the numeric data and empty cells are exported as class double.
Also, if I try to import that cell array back into Excel using MLGetMatrix, I receive the following error:
MATLAB variable is not of a supported type.
This used to work in Excel Link 2.0 (R13).
Best Answer