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

8 次查看（过去 30 天）
AluminiumMan
AluminiumMan 2024-2-22
评论： 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?

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

回答（1 个）

Dyuman Joshi
Dyuman Joshi 2024-2-22
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.
  3 个评论
显示 1更早的评论
AluminiumMan
AluminiumMan 2024-2-22
Is there a way to programatically save the entire workspace as a .MAT file rather than do it manually? And are .MAT files compatable with Tableau?

请先登录，再进行评论。

类别

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

标签

产品


版本

R2023b

Community Treasure Hunt

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

Start Hunting!

Translated by