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.

采纳的回答

dpb
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 CenterFile 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