exporting table to specific excel sheet

Hi

I want to save several tables into the same xlsx file, but in different sheets

that I can also name (name with meaning instead of sheet1...).

If anyone knows how to do it, that would be great!

Thank you (:

Tali

Answer 1

[Azzi Abdelmalek]

for k=1:3
  A=randi(4,4);
  xlswrite('file.xlsx',A,sprintf('name%d',k))
end

[Tali Leibovich]

Thanks! will it work for Tables?

[Walter Roberson]

writetable('file.xlsx', A, 'Sheet', sprintf('name%d',k));

[Azzi Abdelmalek]

Convert a table to a cell array

for k=1:3
  A=cell2table(num2cell(randi(4,4)));
  B=table2cell(A)
 xlswrite('file.xlsx',B,sprintf('name%d',k))
end