How to export .mat file to excel different sheets

Hello Everyone

I have a matlab file to be saved to excel but in 100 different sheets.

The example file i create here:

MAT = rand(10,100); 
xlswrite('sampleData.xlsx', MAT) % this one saves all 100 column values to sampleData file
% but my idea is to save individual column values in the same excel file
% but in 100 different sheet.

Then how can i apply a loop to do so?,

Thank you.

Answer 1

[Mathieu NOE]

hello

yes , like this :

MAT = rand(10,100); 
[m,n] = size(MAT);

for ci = 1:n
    xlswrite('sampleData.xlsx', MAT(:,ci),ci) % xlswrite(file,data,sheet,range)
end

Answer 2

[Net Fre]

In the function xlswrite you can specify the sheet you want to write into:

xlswrite(filename,A,sheet)

Then you can loop over the columns and write each one to a different sheet:

for i = 1:size(MAT,2) % i goes from 1 to number of columns
    xlswrite('sampleData.xlsx', MAT(:,i),i) % write column i to the i'th sheet
end