how to do this

2012 3 8
3 个回答
1 次查看（30 天）

0 个投票

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

0 个投票

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更早的评论 隐藏 3更早的评论

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 .
Walter Roberson
Walter Roberson 2012-3-8
I only see one data set in that diagram. Do you mean you want to access each entry? As a group that would be A(1:12,1:12).
Do you want to use a loop?
for i = 1 : 12
for j = 1 : 12
disp(A(i,j)); %the sample action taken on A(i,j)
end
end
Or is the question how to take an existing matrix and write it to an Excel spreadsheet?
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
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

0 个投票

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

0 个投票

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?

请先登录，再进行评论。

类别

在 帮助中心 和 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