Hello, im trying to import a .xsl doc to matlab using the next code:
The file contains 3 columns with different values. The problem is that some random cells are empty so I been using 'TreatAsEmpty' to convert those empty spaces to NaN.
When I open the data, only column 3 shows with the NaN. Column 1 and 2 still have empty cells "". No matter what value or character I try to substitute, only the last column is always affected.
I'm missing something?