folders containing excel spreadsheets

I have 4 folders each consisting of several (>10) excel spreadsheets. How is it possible to extract the last worksheet of each spreadsheet into matlab. So that in matlab, the data will be such that a cell would represent a folder and within that cell you would have the contents of each folder i.e. the data from the last worksheet of each spreadsheet?

cheers

Answer 1

[Robert Cumming]

doc dir
doc xlsread
doc cell

should give you somewhere to start...

[ricco]

Well I've done this so far:

files = dir('*.xls');

%read data from excel into matlab

for i=1:length(files);

File_Name{i}=files(i,1).name;%Removes the file names from 'files'

[num{i},txt,raw] = xlsread1(File_Name{i},'Bass min sond');

end

But I don't know how to obtain data from different folders and then placing them in different cells.

[ricco]

'Bass min sind' refers to the name of the last worksheet in the worksheet.

[ricco]

**sond**

[Robert Cumming]

your on the right track with what you have. Is your directory names fixed? Or do you want it clever/dynamic?

[ricco]

the folders are all in the same directory.

[Robert Cumming]

fixed?

clever?

dynamic?

concentrate on loading the data from one file - then expandm rather than trying to solve the problem in one go.