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.
