how to replace readcell by xlsread?
显示 更早的评论
Hello,
I am use to use readcell which seems to be very efficient for specific reading. for example var=readcell(xlx,'Sheet','MAIN','Range',[6,2,6,3]);
Is there a way to use xlsread in a simular way? like var=xlsread(xlx,'Sheet','MAIN','Range',[6,2,6,3]);
I tried and it did not work.
I really need the range to be represented by numbers not letters
Thank you
采纳的回答
You apparently also did not read the documentation for xlsread -- besides being deprecated, it does NOT use the 'Range' named parameter as argument but the simple argument list form. But, that aside also, it only accepts the Excel range syntax in 'A1:C3' format; it can't interpret the four-vector form of [r1,r2,c1,c2] that the various readXXXX routines can.
To return numeric data, use readmatrix.
If the data are irregular and not all numeric as might be inferred from using readcell, then readtable may be a better choice. Would need to know the content of the spreadsheet and what is intended to be read from it to have precise and accurate answer to the specific case.
Either way, avoid going backwards to xlsread...
2 个评论
Image Analyst
2022-8-23
@Pierre this is good advice. I suggest you follow it. +1 vote.
Pierre
2022-8-23
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Translated by 
