append (a row) to the end of an excel sheet

58 ビュー (過去 30 日間)
Moh. Saadat
Moh. Saadat 2020 年 4 月 5 日
編集済み: Marcel 2022 年 11 月 30 日
I would like to know if there is any way to simply append to the next available row in an existing excel sheet. I know I can do the append with the writematrix function by specifying the 'Range' property.
writematrix(matrix_to_add, filename, 'Range', 'A1:D20'); %% this adds the matrix_to_add variable in the specified block
However, I do not wish to explicitly specify the range. The rows being added are quite long: 1000 elements. Hence, specifying range will be inconvenient. Thus, the solution I am looking for will simply add the row to the 51st row in the excel sheet if there are already 50 rows in the sheet.
  3 件のコメント
Brian Bean
Brian Bean 2021 年 11 月 20 日
Is there a way to do the same thing, without altering the column width or any previous rows. When I have merged cells in row 1, use writemateix, row 1 cells becomes unmerged. Thanks!
Walter Roberson
Walter Roberson 2021 年 11 月 21 日
If I recall correctly, with new enough versions of MATLAB, if you use writecell() then it will not change the format of existing cells.


回答 (2 件)

Sulaymon Eshkabilov
Sulaymon Eshkabilov 2021 年 11 月 21 日
This is how you can get it:
FName = 'DATA.xlsx';
for ii=1:5
writematrix(magic(3), FN, 'WriteMode','append')

Marcel 2022 年 11 月 18 日
編集済み: Marcel 2022 年 11 月 30 日
This is how im appending text to a xls file. cellstr("Test") would be your data
writecell(cellstr("Test"), "file.xls", 'WriteMode','append');


Help Center および File ExchangeSpreadsheets についてさらに検索


Community Treasure Hunt

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

Start Hunting!

Translated by