How to read Excel file with changing the range automatically

2 次查看（过去 30 天）

Manimaran Kanesan 2013-5-14

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

Yao Li 2013-5-14

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)

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

Find the treasures in MATLAB Central and discover how the community can help you!

Translated by