select row in excel

1 次查看（过去 30 天）
mira
mira 2014-8-5
评论： mira 2014-8-5
Hi, I have this data in excel
B B C A B B A B A A B B A B B A A C B B A A B B A B B A B A A B
and I have problem in extracting the rows. This is because the char (A, B, C) are in random rows. So how do I pick char (A), (B) and (C) in random rows?
Thank you.

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

回答（1 个）

Hikaru
Hikaru 2014-8-5
I would use the code below to read the data into MATLAB.
[~,~, raw] = xlsread('filename.xlsx')
raw will be a cell array containing 'A', 'B', 'C' and [NaN]
I can't help more than this without the specifics. Are the letters stored in the same number of columns? If so, you could convert the letters into char string by
char(raw(i,:)) % i is the rows containing the letters
Note, char() won't work if the element contains NaN.
  1 个评论
mira
mira 2014-8-5
Actually I'm using Psychtoolbox and what I'm doing is when spacebar is pressed, it will recognized the char above. however, I do not manage to recognize the char.

请先登录，再进行评论。

类别

在 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