Use xlsread to draw a string which refers to another matrix

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

Answer 1

[Mahdiyar]

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,

[yvlu]

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...