Append array to row of the excel sheet without overwriting.

3 次查看（过去 30 天）

Yashvardhan Bhati 2022-10-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1824408-append-array-to-row-of-the-excel-sheet-without-overwriting

评论： Yashvardhan Bhati 2022-10-13

I am trying to apped one of the array (lets say xx) which stores certain data entries(All of same type) to excel row.

I will be running the same code multiple times and data that is stored in array (xx) is renewed every iterations and i would like to store data to excel sheet before i give command for running new iteration.

xlswrite(['File_Address\Filename.xlsx'], xx,';append' )

the above command overwrites the exisiting data instead of writing data below it. (Array size remain constant.)

2 个评论
显示无隐藏无

Simon Chan 2022-10-13

If your MATLAB version is R2019a or later, it is better to use function writematrix, writecell or writetable with append option.

Yashvardhan Bhati 2022-10-13

在 MATLAB Online 中打开

Thanks this works. @Simon Chan

writematrix( xx,['FileAddress\Filename.xlsx'],'WriteMode','append')

请先登录，再进行评论。

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

回答（0 个）

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

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

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

产品

MATLAB

版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by