MATLAB: How to read dynamic range with xlsread function

xlsread

Hi,
I want to read an excel file through xlsread function of MATLAB, but I want to keep my range dynamic. it will depend on the value of a variable.
Kindly help me out.
Any suggestion is appreciated.
Thank you.

Best Answer

Just compute the range based on your variables,
startrow = 5; endrow = 100;
startcol = 11; endcol = 35;
data = xlsread('somefile', GetExcelRange(startrow, endrow, startcol, endcol);
With:
function xlsrange = GetExcelRange(startrow, endrow, startcol, endcol)
   xlsrange = sprintf('%s%d:%s%d', GetExcelColumn(startcol), startrow, GetExcelColumn(endcol), endrow);
end
function colstring = GetExcelColumn(colindex)
   colstring = dec2base(colindex-1, 26);
   digit = colstring < 'A';
   colstring(digit) = colstring(digit) + 'A' - '1';
   colstring(~digit) = colstring(~digit) + 9;
   colstring(end) = colstring(end) + 1;
end
Related Question