how to read a value in matlab from an xls file

Hey Dear All,

I would like to refer to the Values of an excel file in my code.

The value which I should read from the excel file is a function of two parametrs (PN and DN) which I include then on my matlab subroutine.

My code should be able to recive a DN and a PN and then give the revelant value.

I would appreciate to have your support.

Answer 1

[KSSV]

T = readtable('whatever.xls')

[Walter Roberson]

and possibly add a Range option

[R@SH]

Dear Walter,

Thanks for your promt support.

The problem is this code should be smart. which means that it should be given a DN and a PN and decides on which row and column of the excel file should look for the answer.

for example acoording to the above picture: if in matlab file you detrmin DN=0.3, and PN=4, it should decide that the answer would be 109000.

I would apprecite you if you can give me a solution

[KSSV]

Yes,,you will get it. Read about the function.

[R@SH]

Thanks again. I proceed this job based on your suggestion but it brought me the whole table not the one cell that I expect to be chosen smartly.

[KSSV]

Use indexing and get the desired.

[Walter Roberson]

Until you have read some of the file, you cannot know which row corresponds to which DN value.

And no, it is not possible to do something like

readmatrix(filename, 'column', 5, 'row', findrow('column', 1, 'eq', 0.3))

You need a database to make queries like that.

[R@SH]

Thank you so much dear Walter