Can xlswrite be used to append information

Question

Daelyn Greene 2019-1-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/440949-can-xlswrite-be-used-to-append-information

评论： Daelyn Greene 2019-1-22

Wanting to write data to excel into a file that will be used over multiple iterations of code. Is there a way to use append to get the data to go into the excel file automatically so that the row numbers in the matlab code don't have to be changed? I'm writing this for people who have no clue how to use matlab, so it needs to be automated somehow, I'm just not sure how.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Jan 2019-1-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/440949-can-xlswrite-be-used-to-append-information#answer_357538

编辑：Jan 2019-1-22

You can import the data from te existing Excel file, determine the size, and insert the new data at the required location. You find some tools in the File Exchange to convert the index to the Excel range like "A2".

See also: https://www.mathworks.com/matlabcentral/fileexchange/28600-xlsappend and https://www.mathworks.com/matlabcentral/answers/438762-i-want-to-write-daily-datum-into-xls-file-without-overwriting