save a structur to xlsx or txt

3 views (last 30 days)
roux terence
roux terence on 25 May 2016
Commented: Todd Leonhardt on 25 May 2016
Hello everybody,
I have a structure with lots of datas and I would like to to save all this datas in a xlsx or a txt.
I have Joint(2).FE Joint(2).AA Joint(2).IER
Joint 2 3 4 5 And all this Joint has 3663 raws.
Is it posible to tranfer all this data into a txt or a xlsx.
Thank you

Answers (1)

Todd Leonhardt
Todd Leonhardt on 25 May 2016
Edited: Todd Leonhardt on 25 May 2016
There are many ways to solve this problem. My recommendation is as follows:
% Convert struct to Table, where your struct is saved in variable S
T = struct2table(S);
% Save data as a CSV file with name of file stored in variable filename
writetable(T, filename);
For more info, see:
A CSV (comma-separated variable) file has many advantages, including:
  • Directly readable by Excel
  • Easy to read/parse in any programming language
  • Human readable
Todd Leonhardt
Todd Leonhardt on 25 May 2016
The solution I gave you is intended to write a CSV file, not an Excel file. If you really want to write an Excel file, use xlswrite():

Sign in to comment.


Community Treasure Hunt

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

Start Hunting!