How to read Excel file with changing the range automatically

Question

0 个投票

HI All,

I am having problem to change the excel range automatically, and need to do it manually everytime

example

columnD = xlsread(filename,'D1:D1000');

The D1:D1000, I need to change it manually. Is there a way to change it automatically. Well I have tried few things below, but does not work

D(x):D(y) - does not work
D%d:D%d - does not work
D{x}:D{y} - does not work

Please help to show me how to control this.

Thank you Manimara

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

Answer 1

Yao Li 2013-5-14

0 个投票

i=1;
j=1000;
range_array=strcat('D',num2str(i),':D',num2str(j));

Jan 2013-5-14

Perhaps this is nicer:

range_array = sprintf('%d:%d', i, j)

Yao Li 2013-5-14

yes, it's much better. Thanks, Jan. But maybe D is missing

range_array = sprintf('D%d:D%d', i, j)