How to export the workspace variable INFORMATION, such as Name, Value, Bytes, Class.

4 次查看（过去 30 天）
Lionel Trébuchon
Lionel Trébuchon 2017-10-17
评论： Lionel Trébuchon 2017-10-17
I would like to find a way to export the description of my workspace. In the MATLAB IDE Workspace description, I find the "Bytes" field particularly informative.
I obtain something close to what I want when I type into the command line:
whos
However, I cannot properly store the output by copy-pasting it into a spreadsheet. If I could save the data listed by whos, it would be useful to search by Class, Size or Name. And doesn't need the disk space that is involved with a
save
in case of big files.

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

采纳的回答

Sean de Wolski
Sean de Wolski 2017-10-17
S = whos;
T = cell2table(struct2cell(S)','VariableNames', matlab.lang.makeValidName(fieldnames(S)));
writetable(T,'whatever.xlsx')

更多回答（1 个）

KSSV
KSSV 2017-10-17
S = whos ;
S = struct2cell(S)
xlswrite('myfile.xlsx',S)
  3 个评论
显示 1更早的评论
Lionel Trébuchon
Lionel Trébuchon 2017-10-17
I believe that it might be because I have structs and cells in the cell itself.
One of those is not behaving well. I'll try to report on a solution if I find one.
Lionel Trébuchon
Lionel Trébuchon 2017-10-17
If you only use the first 4 lines of the whos, at least you don't get any FALSE in your .xlsx.
S = whos ;
S = struct2cell(S)
S = S(1:4,:);
xlswrite('myfile.xlsx',S)
However, the " Value" information is still lost. No information is conserved about the dimensions of matrices or cells, for example.
The reason why this is disappointing is that "Value", for all its "heteroclicity", gets parsed rather well by struct2cell (which manages to extract the dimension in the form of [a,b]). It might be a feature request to xlswrite to be able to handle constructs such as "[26,3]" better.

请先登录，再进行评论。

类别

在 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