Xlsread input arguments?
12 次查看(过去 30 天)
显示 更早的评论
I have a script which generates different range values for different runs, so I stored this data in variables,
startdata= x;
enddata= y;
xlsread(FileName,'startdata:enddata');
Obviously, I get this error:
Error using xlsread (line 247)
Data range 'startdata:enddata' is invalid.
Is there anyway I can assign my variable value to xlsread?
Thank you.
0 个评论
采纳的回答
dpb
2016-6-20
Sure, write the translation from whatever x,y are to the character form...it's not clear what they represent, however, but if they're character strings then all you're missing is the concatenation...
x='A';
y='B';
rnge=[x ':' y];
data=xlsread(FileName,rnge);
If they're numeric you'll have to use num2str or sprintf or similar to build an appropriate string but it can be anything that results in a valid range expression as a character string (a cellstr won't work).
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!