How to read dynamic range with xlsread function?

Question

Suraj Srivastava 2015-2-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/179438-how-to-read-dynamic-range-with-xlsread-function

评论： Walter Roberson 2019-2-22

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Guillaume 2015-2-20

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/179438-how-to-read-dynamic-range-with-xlsread-function#answer_168704

在 MATLAB Online 中打开

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

2 个评论
显示无隐藏无

Russell Grm 2019-2-21

在 MATLAB Online 中打开

The simplest approach would be to concatenate your character array with the variable containing your range using a bracket. Here is an example:

YourVariable = 6; % The variable according to which the range of your data is determined
str_1 = 'A';
str_2 = num2str(YourVariable);
Str = strcat(str_1,str_2);
filename = 'filename';
sheet1 = 1; 
data = xlsread(filename,sheet1,['1:',Str]);