0 个投票

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.

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

 采纳的回答

dpb
dpb 2016-6-20

0 个投票

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 个）

类别

在 帮助中心 和 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!

Translated by