Problem reading double array from excel

Question

Daniel 2022-11-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1843348-problem-reading-double-array-from-excel

评论： Daniel 2022-11-4

Hi, Im reading data from a excel file and I have a few strings that I need to read it as double and I cant, I tried converting the cell to string and then to double and more options but the result are NaN or not a double. Here is what I need to do:

Here I have the excel value

This is how I read all this value and the others (the other values are just normal numbers, so I dont have problems)

This is what I want to do

Thank you for the help

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Stephen23 2022-11-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1843348-problem-reading-double-array-from-excel#answer_1091203

编辑：Stephen23 2022-11-4

在 MATLAB Online 中打开

READCELL et al import text as text, not as double. You could use STR2NUM on the text:

C = readcell(..)
N = str2num(C{1})

2 个评论
显示无隐藏无

Stephen23 2022-11-4

在 MATLAB Online 中打开

str2num('[0:100:100000]')
ans = 1×1001
           0         100         200         300         400         500         600         700         800         900        1000        1100        1200        1300        1400        1500        1600        1700        1800        1900        2000        2100        2200        2300        2400        2500        2600        2700        2800        2900