Matlab 2013a and Excel

1 次查看（过去 30 天）
Marcos Tawadros
Marcos Tawadros 2015-4-2
评论： Marcos Tawadros 2015-4-28
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.
  5 个评论
显示 3更早的评论
per isakson
per isakson 2015-4-3
Never write "not working" without telling in what way and providing an error message.
data seems to be a row vector. What does
whos data
show?
Marcos Tawadros
Marcos Tawadros 2015-4-28
how can I plot these data plot(z,x,Bt) ????

请先登录，再进行评论。

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

回答（2 个）

per isakson
per isakson 2015-4-2
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
  8 个评论
显示 6更早的评论
Marcos Tawadros
Marcos Tawadros 2015-4-3
I know the output is gonna be a scalar integer 1*1.
Marcos Tawadros
Marcos Tawadros 2015-4-28
how can I plot(data(row_points,column_points) with row_points and column_points?

请先登录，再进行评论。

LUI PAUL
LUI PAUL 2015-4-3
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
num = xlsread('cloudy.xlsx');
value=num(2,2); %for value Of B2 in excel
the value will be 2.1
  2 个评论
Marcos Tawadros
Marcos Tawadros 2015-4-3
Subscripting into an mxArray is not supported.
LUI PAUL
LUI PAUL 2015-4-5
please clarify your comment

请先登录，再进行评论。

类别

在 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