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

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?

Answer 1

[Dyuman Joshi]

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.

[Stephen23]

"Saving the full workspace to an excel file would be a tedious task..."

... unless you do something like this:

save(..)
S = load(..);
T = struct2table(S);
writetable(T,..)

If the variables are not compatible for storing in one table then you might need to use a FOR-loop or something similar.

[AluminiumMan]

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?

[Walter Roberson]

save(FILENAME)

saves the entire current workspace as a .MAT file.