select row in excel

8 views (last 30 days)
mira
mira on 5 Aug 2014
Commented: mira on 5 Aug 2014
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.

Answers (1)

Hikaru
Hikaru on 5 Aug 2014
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 Comment
mira
mira on 5 Aug 2014
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.

Sign in to comment.

Tags

Community Treasure Hunt

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

Start Hunting!