Saving all variables in a single file (ideally an excel file)

Question

AluminiumMan 2024-2-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2085488-saving-all-variables-in-a-single-file-ideally-an-excel-file

评论： Walter Roberson 2024-2-22

Hi, I was just wondering if there was a way to save all variables in a workspace to a single Excel file? Ideally each variable would be saved as a single tab, but could also simply be added to the next column in a single worksheet tab.

If they can't be saved as an Excel sheet, then what are the other options? Is there another way to save an entire workspace full of variables to a single file?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Dyuman Joshi 2024-2-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2085488-saving-all-variables-in-a-single-file-ideally-an-excel-file#answer_1414578

One option is to save all the variables in a workspace to a .mat file.

On the Home tab, in the Variable section, click Save Workspace.

Load the data back into the workspace using load.

Reference - https://in.mathworks.com/help/matlab/matlab_env/save-load-and-delete-workspace-variables.html

Saving the full workspace to an excel file would be a tedious task (especially if you have a lot of variables), as you will have to manually put all the variables in a cell array/table (if they are heterogenous or non-uniform), or concatenate them into a numerical array (if they are compatible for concatenation), and then use any of writecell, writetable or writematrix accordingly.