Unable to read strings (I get NaN) in the excel file imported into Matlab
3 次查看(过去 30 天)
显示 更早的评论
I am importing an Excel file that has both strings and numeric values. Eventhough I can see the springs value during the importation (using the import data tool), I m unable to see those strings after I run my code an extract the rows I want. I see NaN instead of the string values. Please, what should I do? Thank you!!
0 个评论
回答(2 个)
Lucademicus
2020-1-2
I have made an Excel file with a column containing numbers and strings.
The result of importing depends on what data you tell MATLAB to expect, and how to treat other data types.
In this preview, I have highlighted how MATLAB's tells me a value will be treated as NaN:
If you want to have mixed numbers and strings, you should choice Cell Array as Output Type (whereas it is Table, in my example).
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!