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
  2 Comments
roux terence
roux terence on 25 May 2016
Error using writetable (line 116) Error writing table variable 'AA' to 'Angles_Articulaires.xlsx':
The specified data range is invalid or too large to write to the specified file format. Try writing to an XLSX file and use Excel A1 notation for the range argument, for example, ‘A1:D4’.
Error in Data_Processing_MoCap (line 496) writetable(T,filename);
This the error message that Matlab gives me.
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.

Products

Community Treasure Hunt

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

Start Hunting!