Import excel to matlab

1 次查看（过去 30 天）
Ryan Freeman
Ryan Freeman 2011-7-18
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?

请先登录，再回答此问题。

回答（1 个）

Chirag Gupta
Chirag Gupta 2011-7-18
[~, 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
  3 个评论
显示 1更早的评论
Ryan Freeman
Ryan Freeman 2011-7-18
Thank you. I am getting an error at the line vername = genvarname ('data_' sheets {i}).
Chirag Gupta
Chirag Gupta 2011-7-19
My bad! it should be:
varname = genvarname( ['data_' sheets{i} ] );

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by