Save variable data without overwrite in excel

Question

muhamad idris 2015-7-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/229003-save-variable-data-without-overwrite-in-excel

评论： muhamad idris 2015-7-18

Hi there,i'm newbie here.I have problem to save my variables data in excel where the new data overwrite the existing data.The new data should be added to existing data and not overwrite.Here is my code:

 T = table(k,l,m,n,o);%k,l,m,n,n,o is the variables
 filename = 'filename.xlsx';
 writetable(T,filename,'Sheet',1,'Range','A1');

Thanks guys.

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

请先登录，再进行评论。

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

Answer 1

Abhishek Pandey 2015-7-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/229003-save-variable-data-without-overwrite-in-excel#answer_186354

Hello Muhamad,

You can check out this link. I believe a similar question has been answered here.

overwriting-a-vector-to-a-specific-location-into-csv-file

Thanks,

Abhishek

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

muhamad idris 2015-7-18

Hi Abhishek, thanks for your help.I have tried the code but it still replaced the existing data.The program should keep record all variables value without overwrite it.Someone told me to use append function but I'm not sure how to use that.Thanks

请先登录，再进行评论。