How to access a table inside a table on Excel ?

3 次查看（过去 30 天）
Antoine Cimino
Antoine Cimino 2018-2-23
回答： Sujit Muduli 2018-3-9
Hello,
I would like to access a table located in another table and display it on excel. I have the excel addin and I can normally visualize easily the variables of my workspace. If I do mlgetmatrix("PartitionTable.PartitionTable{1,1}","D4"), I get an error as only the PartitionTable exists. I have also tried to create subtables from this table but I would need to create variables out of the rows of my PartitionTable object (in a for loop, which is not possible on Matlab and bad practice as I have read already). I have managed to create .csv files but once again, I would need to load it after saving it as new variable coming back to the previous issue...
What would be the most efficient way of displaying this data ?
Thank you, Antoine

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

回答（1 个）

Sujit Muduli
Sujit Muduli 2018-3-9
Hi Antoine, There are few other functions you may use to get the table data from the spreadsheet such as readtable, this will return a table from which you can extract the necessary fields. Please try this and see if that works for you.
Here is the documentation link which you may find useful, https://in.mathworks.com/help/matlab/spreadsheets.html
Thanks,
Sujit

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by