convert cell to double
7 views (last 30 days)
Show older comments
Hello,
When i imported data from my excel sheet to Matlab by using the 'import data' button, some colums were identified as cell and others as double (all the colums in excel consists of numbers). The data in the colums that are 'double' are NaN (once imported), and I can't convert the cell type to double in order that i can plot these.
Can anyone help me with this?
Thanks!
0 Comments
Answers (1)
Sean de Wolski
on 10 Mar 2014
In the import tool, change the selection to double, then reimport.
This is the best part of the import tool, you can rapidly change your settings until you're happy.
2 Comments
Sean de Wolski
on 10 Mar 2014
Could you attach a small representative example of your excel file (zipped)?
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!