Matlab: Reading in data from an excel spreadsheet as a single integer

6 次查看（过去 30 天）
Louis
Louis 2011-12-22
I am reading in data from an excel spreadsheet, but I am unable to use a comparison on what I read in. How can I read in a cell from an excel spreadsheet and compare what I get to a number? I'm pretty sure anything read from a spreadsheet is made into an array Here is the relevant code (edit: I'll give the whole code of what I have; edit2: Minor fixes, but being so new to MatLab, I think I'm not familiar with how to declare a variable):
>> for k = 2:4997
colF = 'F';
colE = 'E';
row = int2str(k);
entryF = strcat(colF, row);
entryE = strcat(colE,row);
millisecond = xlsread('someFile.xlsx', 1, entryE);
[~,message] = xlsread('someFile.xlsx', 1, entryF);
if millisecond == 1
soundMoment = 0;
elseif strcmp(message, 'probe_sound')
soundMoment = millisecond;
end
if soundMoment == 0
xlswrite('someFile.xlsx', 'preprobe', 1, entryF);
elseif millisecond > soundMoment
xlswrite('someFile.xlsx', 'postprobe', 1, entryF);
end
end
  25 个评论
显示 23更早的评论
Aldin
Aldin 2011-12-23
In MATLAB there is no declaration such as in JAVA we have int, float, double, string...

请先登录，再进行评论。

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

回答（2 个）

Aldin
Aldin 2011-12-22
Here is the right code for getting data from excel doc.
[~,name] = xlsread('test.xlsx',1,'A1')
Aldin
Aldin 2011-12-22
Edit your code with this:
[~,message] = xlsread('someFile.xlsx', 1, entryF);
your code seems to be OK

类别

在 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