Using a variable range with xlsread??

Hello, I am trying to use xlsread, but I need the range to be variables. for example:

str1 = 'A1'; str2 = 'B5'; Input = xlsread(filename,'str1:str2');

However, this is giving me the following error: "Data range is invalid." Is there a way to do this? Thanks!

-Matt

Answer 1

[Jan]

'str1:str2' is the string 'str1:str2' - not surprising. But you want to concatenate two (three!) string variables:

str1 = 'A1'; 
str2 = 'B5';
Input = xlsread(filename,[str1, ':', str2]);

Such methods are explained in the Getting Started chapters of the documentation.