Copy data from Structure to Excel

2 views (last 30 days)
Madalena João
Madalena João on 20 Jun 2022
Answered: Jai Khurana on 29 Jun 2022
I have some structure that is:
In each entry there is another structure:
How can i copy these items into excel? When i try to copy it does does copy the elements in the vectors, but "1x11 double" (for the example of line 15).
I cannot use the writestruct because of the Matlab version (which i cannot update), do you have any other ideas?
Thank you! Kind regards

Answers (2)

Abhijeet on 26 Jun 2022
Hi Madalena João ,
Please refer to this similar question that is already answered and let me know if you have further doubts.

Jai Khurana
Jai Khurana on 29 Jun 2022
I understand that you want to copy your structure in MATLAB to an Excel file.
To convert the array of structure to a table use can use the struct2table function.
To move the table contents to an Excel file you can use the writable function.
An example of how these functions can be used together is as follows:-
writetable(struct2table(yourstructure), 'someexcelfile.xlsx

Community Treasure Hunt

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

Start Hunting!

Translated by