How to access a table inside a table on Excel ?

1 view (last 30 days)
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

Answers (1)

Sujit Muduli
Sujit Muduli on 9 Mar 2018
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

Community Treasure Hunt

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

Start Hunting!