save a structur to xlsx or txt

2 次查看（过去 30 天）
roux terence
roux terence 2016-5-25
评论： Todd Leonhardt 2016-5-25
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

请先登录，再回答此问题。

回答（1 个）

Todd Leonhardt
Todd Leonhardt 2016-5-25
编辑：Todd Leonhardt 2016-5-25
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:
http://www.mathworks.com/help/matlab/ref/struct2table.html
http://www.mathworks.com/help/matlab/ref/writetable.html
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 个评论
roux terence
roux terence 2016-5-25
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 2016-5-25
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():
http://www.mathworks.com/help/matlab/ref/xlswrite.html

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by