Extracting data from table

Hi all,

I have a table with different variables. For example, Freq - columns A:K and rows 10:20, then Ampl - columns A:K and rows 21:30. I have an equation, y = Ampl*sin(2*pi*Freq*t+phase). How can I make in matlab so for every "y" calculated value, the variables Ampl and Freq are taken from that table, first value, then next value and so on for every calculation ?

Thank you very much!

[KL]

Freq - columns A:K and rows 10:20

What do you mean by this?

Attach a sample table, it's much simpler to understand.

[Doina Gumeniuc]

HI! By 10:20 I mean from row 10 until row 20. Please see attached an example I made fast. Basically, in the equation I need to take first value of Frequency and next value of amplitude. Then first value of frequency again, second value of amplitude. They are all stored in an external value. SO I want in matlab to make it automatically to take value by value from certain row and certain column. Thank you!

[Guillaume]

I get this warning when trying to open your file: The file format and extension of "table_example.xls" don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it."

Needless to say I haven't tried to open it.

I doesn't sound that your table is a matlab table. Is your table actually an excel file? It's confusing if you use the wrong term. Tables in matlab have variables: the columns of the table. Variables of a table never have anything to do with rows.

It would be much easier if you provided a valid example of input constructed using valid matlab syntax.