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

2017 10 17
2 个回答
回答已采纳
更新时间：2017 10 17
7 次查看（30 天）

0 个投票

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

1 个投票

S = whos;
T = cell2table(struct2cell(S)','VariableNames', matlab.lang.makeValidName(fieldnames(S)));
writetable(T,'whatever.xlsx')

更多回答（1 个）

KSSV
KSSV 2017-10-17

1 个投票

S = whos ;
S = struct2cell(S)
xlswrite('myfile.xlsx',S)

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Lionel Trébuchon
Lionel Trébuchon 2017-10-17
Hello KSSV,
I see that I did not try enough! Thanks for the simple and nice idea.
I am however forced to observe that in MATLAB 2015a , the export of this cell with xlswrite is very buggy. Most of the "features" end up as "FALSE" in the Excel sheet. They cannot be retrieved by some Excel manipulation, it is not an error of the Excel visualization.
I was thinking about using add-ons like Roland Pfister's dlmcell to write to a .csv file.
Any better ideas?
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.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by