How to convert a large set of variables in the MATLAB workspace into an Excel file?

I want to take my Workspace variables and download them as an Excel file. Here's how I am doing it

% Clean your workspace
clear
close
clc

% Create variables
a = "Hello World";
b = "Today is Friday";
c = "I am happy";

% Define to filenames
varsFile = "workspace.csv";

% Convert variables to tables
dataTable = table(a, b, c);

% Write the tables to their respective files
writetable(dataTable, varsFile);

But suppose that have many many variables. How can I do this without calling each single variable. Is there a loop that can do this for me given a large set of variables? Thanks!

[Mathieu NOE]

hello

why not using a structure to store easily all your varaibles ?

Save workspace variables to file - MATLAB save - MathWorks France

Save Structure Fields as Individual Variables

Open in MATLAB Online

View MATLAB Command

Create a structure, s1, that contains three fields, a, b, and c.

s1.a = 12.7;

s1.b = {'abc',[4 5; 6 7]};

s1.c = 'Hello!';

Save the fields of structure s1 as individual variables in a file called newstruct.mat.

save('newstruct.mat','-struct','s1');

Check the contents of the file using the whos function.

disp('Contents of newstruct.mat:')

Contents of newstruct.mat:

whos('-file','newstruct.mat')

Name Size Bytes Class Attributes

a 1x1 8 double

b 1x2 246 cell

c 1x6 12 char

[Missael Hernandez]

I'll have hundreds of variables. i don't know if it's practical to call them all out.

[Stephen23]

Storing all of your hundreds of arrays in one structure would make your task easy and efficient.

Unfortunately you have lots of separate variables, which makes this task complex and inefficient.

Answer 1

[Image Analyst]

Try this and adapt as needed:

% Create variables
a = "Hello World";
b = "Today is Friday";
c = "I am happy";

% Define workbook filename.
varsFile = "workspace.csv";

s = whos;
variableNames = {s.name}
for k = 1 : length(variableNames)
	% Write the variable to Excel.
	% How you do it depends on what the data type is
	% and where you want them to go.
end

[Missael Hernandez]

and I just insert

% Convert variables to tables
dataTable = table(variableNames);
% Write the tables to their respective files
writetable(dataTable, varsFile);

in the loop?

[Image Analyst]

Well it really depends on what the data types are. Are they all strings? Or are some cell arrays or double arrays or structures? They all get written out differently.

[Missael Hernandez]

yes, they will all be strings

[Image Analyst]

Then just call writecell() inside the loop. I believe each time you call it, it will just blast over the existing workbook, and retain existing values, so make sure you change the sheet or cell location when you do the write so you don't clobber old data with new data.