Calling Excel and Matching Data in Matlab
7 views (last 30 days)
Show older comments
I would like to call an excel data like in the picture. I have to call only a few data but need to followed by the next data in the next right column. Just like this if I called AAI, I wish the next data like 3 41.22654 will automatically followed.
0 Comments
Answers (1)
dpb
on 27 Jan 2018
Consider using readtable to bring the data in; making the ID column categorical data type will have advantages in writing lookup tests. Then there are any number of ways to find the given row(s) depending on just what it is you need, specifically. Look at the examples for table on how to address data therein for pointers...
2 Comments
dpb
on 27 Jan 2018
Edited: dpb
on 27 Jan 2018
Access table data https://www.mathworks.com/help/releases/R2016b/matlab/matlab_prog/access-data-in-a-table.html
Working with categorical data https://www.mathworks.com/help/releases/R2016b/matlab/categorical-arrays.html
Just dive in at the keyboard in command window and 'spearmint...fastest way there is to learn.
If'en then get stuck show us what you've gotten done and tried and folks'll be happy to show pointers.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!