excel data to matlab

1 次查看（过去 30 天）
zamri
zamri 2013-1-7
Hi all,
Can i ask how to make matlab read data one by one from excel file for each loop.
Say
for num2 = 1:10
A=1+b;
end
for every num2, i want to take data from excel (A1:A10) for example.

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

采纳的回答

Walter Roberson
Walter Roberson 2013-1-7
for num2 = 1 : 10
thiscell = sprintf('A%d:A%d', num2, num2);
A = xlsread('TheFile.xls', thiscell);
.... do something with A
end
Warning: this will be very inefficient!
  3 个评论
显示 1更早的评论
zamri
zamri 2013-1-7
编辑：Image Analyst 2013-1-7
great, thanks guys. I try the method from 'Image analyst'.
Image Analyst
Image Analyst 2013-1-7
Be aware that num, texts, and raw do not all necessarily start at the same cell in Excel. They can start at different upper left corners. So num(3,3) could be cell D5, not C3, and texts(3,3) could be E6 and raw(3,3) could come from cell D5 (raw will be the upper left of the combined num and texts).

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by