how to write xlswrite command in a loop such that after every loop, the row increments.

2 次查看（过去 30 天）
usama amjid
usama amjid 2015-7-10
评论： Walter Roberson 2024-12-29
the program currently stores the values in a ".out" extension. need to store the output to an excel file also. how to add loop such that each calculated value of A gets stored in the next row.
filename = 'testdata.xlsx';
A = [tsince ro(1) ro(2) ro(3) vo(1) vo(2) vo(3)];
sheet = 1;
xlRange = 'A1';
xlswrite(filename,A,sheet,xlRange);
  1 个评论
usama amjid
usama amjid 2015-7-10
编辑：usama amjid 2015-7-10
i tried using
xlRange = 'A1:H10';
but it resulted in the last calculated value to be repeating in all rows from top to bottom.

请先登录，再进行评论。

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

回答（1 个）

ag
ag 2024-12-29
Hi Usama,
To write the output to an Excel file, appending it to the next available row, you can utilize the "writematrix" function in MATLAB. Below is a code snippet demonstrating this approach:
% this will append the data below the existing data in the spreadsheet file.
writematrix(mat,'fileName.xls','WriteMode','append')
Please note, "xlswrite" is no longer recommended, kindly refer to the following MathWorks documentation for more details: https://www.mathworks.com/help/matlab/ref/xlswrite.html#mw_88a93783-cc81-4dbc-8146-46289887a551:~:text=is%20not%20recommended-,xlswrite%20is%20not%20recommended,-.%20Use%20writetable%2C
Hope this helps!

类别

在 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