From: Uven Chong on
Is there a way to automate xlsread in MatLab?

For example, I have data from 100 spreadsheets titled data1, data2, data3, ..., data100. Instead of typing xlsread('data1') 100 times, is there a way to automate this, i.e. xlsread('data'x) in a while loop that counts from x=1 to x=100?

Thank you.
From: Steven Lord on

"Uven Chong" <uven_chong(a)hotmail.com> wrote in message
news:hm8km0$a3d$1(a)fred.mathworks.com...
> Is there a way to automate xlsread in MatLab?
>
> For example, I have data from 100 spreadsheets titled data1, data2, data3,
> ..., data100. Instead of typing xlsread('data1') 100 times, is there a way
> to automate this, i.e. xlsread('data'x) in a while loop that counts from
> x=1 to x=100?

Yes; this is question 4.12 in the newsgroup FAQ (linked in my signature.)

--
Steve Lord
slord(a)mathworks.com
comp.soft-sys.matlab (CSSM) FAQ: http://matlabwiki.mathworks.com/MATLAB_FAQ


From: us on
"Uven Chong" <uven_chong(a)hotmail.com> wrote in message <hm8km0$a3d$1(a)fred.mathworks.com>...
> Is there a way to automate xlsread in MatLab?
>
> For example, I have data from 100 spreadsheets titled data1, data2, data3, ..., data100. Instead of typing xlsread('data1') 100 times, is there a way to automate this, i.e. xlsread('data'x) in a while loop that counts from x=1 to x=100?
>
> Thank you.

a hint:

http://matlabwiki.mathworks.com/MATLAB_FAQ#How_can_I_process_a_sequence_of_files.3F

us