Create multiple excel sheet using loop and rename them using loop

Hi All,

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

Answer 1

[Mathieu NOE]

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