Extracting data from table

1 次查看（过去 30 天）

Doina Gumeniuc 2017-11-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/366428-extracting-data-from-table

评论： Guillaume 2017-11-12

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!

3 个评论
显示 1更早的评论隐藏 1更早的评论

Doina Gumeniuc 2017-11-11

table_example.xls

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 2017-11-12

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.

请先登录，再进行评论。

请先登录，再回答此问题。