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
3 ビュー (過去 30 日間)
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 2018 年 7 月 3 日
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)
Hope that helps!
その他の回答 (0 件)
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!