EXTRACT DATA FROM EXCEL

6 Apr 2016
0 Answers
Updated 6 Apr 2016
4 Views (30 days)

0 votes

i have an excel file in the form
Name Result
a 2
b 5
a 7
c 5
a 6
b 8
How do I load the data for the rows named 'a' into matlab?? ie create an array in MATLAB as follows
a 2
a 7
a 6

2 Comments
Show None Hide None

Kuifeng
Kuifeng on 6 Apr 2016
consider import all data first, and then extract all rows with 'a'.
MBD4FUN
MBD4FUN on 6 Apr 2016
Edited: MBD4FUN on 6 Apr 2016
Type "help xlsread" at your Matlab command window and hit enter. Matlab has a very rich built-in help system. Sometimes it's worthy to take a look at ;)
Have a nice day!
MBD4FUN

Sign in to comment.

Sign in to answer this question.

Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Tags

Asked:

NAsap
NAsap
on 6 Apr 2016

Edited:

MBD4FUN
MBD4FUN
on 6 Apr 2016

Community Treasure Hunt

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

Start Hunting!