How to access a table inside a table on Excel ?

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

Answer 1

[Sujit Muduli]

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