Use of TreatAsEmpty to replace table values
Afficher commentaires plus anciens
Hello, im trying to import a .xsl doc to matlab using the next code:
data=readtable('C:\Users\Alfred\OneDrive\Libro1.XLSX','TreatAsEmpty',{''})
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?
thanks.
2 commentaires
Cris LaPierre
le 23 Août 2021
Share you xls file. You can attach it using the paperclip icon.
Dionisio Mendoza
le 29 Août 2021
Réponse acceptée
Plus de réponses (0)
Catégories
En savoir plus sur Characters and Strings dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!