How to save each iteration of a loop into the same sheet of an Excel spreadsheet using a mac and the function Mac OSX friendly function xlwrite

1 次查看（过去 30 天）
Charles
Charles 2018-7-3
评论： Walter Roberson 2019-4-21
How I am trying to write the outputs of each iteration of each loop to the same spreadsheet but in different sheets.
Thus if i have 5 iterations, I want the output of the same iteration to be saved to sheet1, the output o the second iteration . be saved to sheet2.....etc..etc
Note I am using a macbook, and this a custom function called xlwrite which works on a mac osx system.

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

采纳的回答

Madeline Gardner
Madeline Gardner 2018-7-3
Hello!
Assuming that xlwrite supports the same syntax as xlswrite, which I believe it does, then you can include a third parameter in your function call to identify which sheet in the spreadsheet you would like to write to. This parameter can be a string, but it can also be an integer representing the index of the sheet, which is very convenient when writing to a spreadsheet in a for loop.
Your code will likely follow this general form, though with your own file and variable names:
for i = 1:5
xlwrite('excelTest', M(:, i), i)
end
Hope that helps!

更多回答（0 个）

类别

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

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by