MATLAB: Create multiple excel sheet using loop and rename them using loop

excelMATLAB

Hi All,
Kindly help me to create the multiple excel sheets in single workbook and rename them using the loop.

Best Answer

hello
this is my suggestion :
VariableNames = {'Customer','x','y','d'};
SheetNames = {'A','B','C','D'};
filename_out = 'test.xlsx';
for hh = 1:numel(SheetNames)
% export to excel
data = rand(100,numel(VariableNames));
writecell(VariableNames,filename_out,"Sheet" ,char(SheetNames(hh)),"Range",'A1'); % save column headers in first line
writematrix(data,filename_out,"Sheet" ,char(SheetNames(hh)),"Range",'A2'); % save data (cell) to excel file
end