Creating a Cell Array from multiple excel sheets

Hi, So I have a excel file with 100 sheets. Is that a way for me to combine all the A1 elements from each excel sheet into one matrix, all A2 elements from each excel sheet into one matrix etc. and then store all matrices into a cell array? Any help will be appreciated. Cheers Jim

Answer 1

[KSSV]

You can read the data in a specific sheet of excel using:

[num,txt,raw] = xlsread(filename,sheet,xlRange)

num gives only numbers of the data, txt gives the test data, raw gives all the excel info in cell matrix. You can pick what ever column/ row you want from raw and merge.

Answer 2

[Andrei Bobrov]

out = cell(100,1);
for jj = 1:100
    out{jj} = xlsread('path_to_your_xls_file.xlsx',jj);
end