How to read out the strings from this Excel file?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Attached is the Excel file.
Here is the code I use to read values out of the Excel file:
T1 = readtable ('test.xlsx');
Unfortunately, the strings are now stored as NaN in the variable T1.
I have many such files. Sometimes, this column could be all numerical, sometimes, all strings, and sometimes a mix.
Thanks.
1 commentaire
KSSV
le 3 Déc 2020
Read the documentation, there are options to keep the data as it is unchanged while reading.
Réponses (1)
Swetha Polemoni
le 5 Déc 2020
Hi Leon,
You can try using the following line of code.
[~,~,T] = xlsread ('test.xlsx');
0 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!