Finding Max values from different excel sheets?

Hi, I have 100 excel spreadsheets, each with 300x600 values of surface elevation. I need to write a matlab script to compare all 100 excel sheets to find the Max value for each cell (eg. Max value in cell A1,A2,A3 etc.) and the compile into a new matrix. Also I need it to tell me from which excel files those maxs came from. Any help will be really appreciated. Cheers, Jim

Answer 1

[KSSV]

If you have 100 sheets in an excel file...run a loop for each sheet, get the max and store in an array...

pseudo code:

iwant = zeros(100,1) ;
for i = 1:100
    data = xlsread(filename,i)   % i corresponds to sheet number
    iwant(i) = max(data(:)) ;
end

The indices of iwant correspond to the number of sheet number.