how to do this

1 次查看（过去 30 天）
Nasir Qazi
Nasir Qazi 2012-3-8
if I have i = 1:12 , j= 1:12 and I want to get a table with A(i,j) , how I will do it
  2 个评论
Igor de Britto
Igor de Britto 2012-3-8
I don't get your question. Wich values do you want to populate this square matrix? Or do you want a lot of matrices with all the size combinations?
Nasir Qazi
Nasir Qazi 2012-3-8
I want to access each entry on excel sheet using Matlab , in Matlab I want to just enter A(i,j) and it should acess excel sheet for the values of i , j and return it back to Matlab , How can I do that

请先登录，再进行评论。

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

回答（3 个）

Walter Roberson
Walter Roberson 2012-3-8
What do you mean by a "table" in this context? Something displayed to the command window? A uitable() ? An array with 3 columns, the first for i, the second for j, and the third for A(i,j) ?
When you speak of A(i,j) do you mean A(1:12,1:12), or do you mean A(i(1),j(1)) A(i(2),j(2)), A(i(3),i(3)) and so on? If you do then
A(subs2ind(size(A), i, j))
  5 个评论
显示 3更早的评论
Nasir Qazi
Nasir Qazi 2012-3-8
syms A
>> for i = 1 : 12
for j = 1 : 12
disp(A(i,j)); %the sample action taken on A(i,j)
end
end
A
??? Error using ==> mupadmex
Error in MuPAD command: Index exceeds matrix dimensions.
Error in ==> sym.sym>sym.subsref at 1366
B = mupadmex('mllib::subsref',A.s,inds{:});
Nasir Qazi
Nasir Qazi 2012-3-8
without syms A
??? Undefined function or method 'A' for input arguments of type 'double'.

请先登录，再进行评论。

Nasir Qazi
Nasir Qazi 2012-3-8
check this excel diagram http://imageshack.us/photo/my-images/141/newpicturezp.jpg/ I want to access every data set on the excel sheet .
Nasir Qazi
Nasir Qazi 2012-3-8
I want to access each entry on excel sheet using Matlab , in Matlab I want to just enter A(i,j) and it should acess excel sheet for the values of i , j and return it back to Matlab , How can I do that
  2 个评论
Aldin
Aldin 2012-3-8
You want to display excel data in uitable, right?
Nasir Qazi
Nasir Qazi 2012-3-8
yes

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by