# Matlab 2013a and Excel

2 views (last 30 days)
Marcos Tawadros on 2 Apr 2015
Commented: Marcos Tawadros on 28 Apr 2015
I am using Matlab 2013 a and I have an excel sheet that has 2D numerical values. For e.g:
-3 -2 -1 0 1 2 3
0 2.1 5 4 2.5 3 8 9
-1 11 12 13 9 4 2 1
and so on, I would like to know how I can get a certain cell value such as '13' as an e.g. from the values (-1,-1), what function i can use and how. thanks in advance.
Marcos Tawadros on 28 Apr 2015
how can I plot these data plot(z,x,Bt) ????

per isakson on 2 Apr 2015
Assumption:
• the values in the top row are unique integers
• the values in the leftest column are unique integers
Hint:
data = [ 2.1 5 4 2.5 3 8 9
11 12 13 9 4 2 1 ];
row_points = [ 0; -1 ];
col_points = [ -3 -2 -1 0 1 2 3 ];
data( row_points==-1, col_points==-1 )
returns
ans =
13
Marcos Tawadros on 28 Apr 2015
how can I plot(data(row_points,column_points) with row_points and column_points?

LUI PAUL on 3 Apr 2015
if this is your excel data(say)
-3 -2 -1 0 1 2 3
0 2.1 5 4 2.5 3 8
-1 11 12 13 9 4 2
value=num(2,2); %for value Of B2 in excel
the value will be 2.1
##### 2 CommentsShowHide 1 older comment
LUI PAUL on 5 Apr 2015

### Categories

Find more on Data Import from MATLAB 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!

Translated by