How to export .mat file to excel different sheets

7 次查看（过去 30 天）
TESFALEM ALDADA
TESFALEM ALDADA 2021-12-8
编辑： Mathieu NOE 2021-12-8
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.

请先登录，再回答此问题。

采纳的回答

Mathieu NOE
Mathieu NOE 2021-12-8
编辑：Mathieu NOE 2021-12-8
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

更多回答（1 个）

Net Fre
Net Fre 2021-12-8
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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by