Import excel to matlab

2011 7 18
1 个回答
10 次查看（30 天）

0 个投票

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

0 个投票

[~, 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更早的评论 隐藏 1更早的评论

Walter Roberson
Walter Roberson 2011-7-18
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
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} ] );

请先登录，再进行评论。

类别

在 帮助中心 和 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