Info

此问题已关闭。 请重新打开它进行编辑或回答。

Use xlsread to draw a string which refers to another matrix

1 次查看（过去 30 天）
yvlu
yvlu 2015-4-6
关闭： MATLAB Answer Bot 2021-8-20
Dear All
I've got an Excel spreadsheet with a matrix which I'd like to read into Matlab. This works well. Now, one of the Values from this matrix in Excel is for example d(2) and I've already got a matrix d in Matlab. How do I have to draw this data out that I can further use it to get the value which is stored in d(2)? Important is that I need the whole matrix from Excel, which means normal numbers and the references to other matrixes.
I tried it with raw and then to convert it with str2num but that doesn't work...
if true
d=[3,12,10];
[~,~,A] = xlsread('Daten_jrpd_opt.xlsm','A');
k=A(1,1)
str2num(k)
end
Thanks a lot for your help!
Cheers
Yves

此问题已关闭。

回答（1 个）

Mahdiyar
Mahdiyar 2015-4-6
Hi
can you send the execl file and tell me what do you want to see from the excel because I did not understand the question.
Regards,
  1 个评论
yvlu
yvlu 2015-4-6
Hi Mahdiyar, thanks a lot for your fast reply!
In the cell A1 is written d(2), after I read the whole matrix into Matlab I like that when I call A(1,1) to get the result 12, so k should be 12...

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by