Import excel to matlab

I want to import data from excel into matlab. My data is separated into different sheets and I would like to save each sheet into its own variable (it is important that the sheets stay separated, I don't just want to import all the data into a single variable). Does anyone know how to do this?

Answer 1

[Chirag Gupta]

[~, sheets, ~] = xlsfinfo('myfile.xls'); gives a cell array of sheets
for i = 1:length(sheets)

     %create variable string
     varname = genvarname('data_' sheets{i});
     eval('varname = xlsread(''mytest.xls'',sheets{i})');
end

[Walter Roberson]

Note: if your MATLAB is not one of the newer ones, it may complain about unexpected operator at the ~ . If so then replace the two ~ with any unused variable names.

[junk, sheets, junk] = xlsinfo(....)

[Ryan Freeman]

Thank you. I am getting an error at the line vername = genvarname ('data_' sheets {i}).

[Chirag Gupta]

My bad! it should be:

varname = genvarname( ['data_' sheets{i} ] );