Copying data from 1 excel file into another

[sneakyben]

Hi,
I am quite new to MATLAB and wish to do the following:
(I have searched for previous posts on this topic, but could find nothing that answers my questions)

I wish to write a script that will do the following, please could someone tell me how?

I have a directory that contains ten .xls files...

I want to copy the info from cells A100 to A110 from the 1st .xls file and put them in a new .xls file in cells A1 to A10...

Then I want to copy cells A100 to A110 from the 2nd .xls file into the .xls file described above in cells B1 to B10...

and so on... until all .xls files have had data copied from them into the new .xls file

Thanks
Ben

 

[sneakyben]

also, i'd like to do the same thing, but put the 2nd file's data into A11-A20 etc

 

[IRstuff]

Wouldn't it be way easier to do this directly in Excel using VBA?

TTFN

FAQ731-376

 

[sneakyben]

Possibly, but I would like to learn how to do it in MATLAB.

 

[GregLocock]

look at the help for xlsread

Cheers

Greg Locock


New here? Try reading these, they might help FAQ731-376

http://eng-tips.com/market.cfm?