Save variable data without overwrite in excel

1 view (last 30 days)
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.

Answers (1)

Abhishek Pandey
Abhishek Pandey on 17 Jul 2015
Hello Muhamad,
You can check out this link. I believe a similar question has been answered here.
Thanks,
Abhishek
  1 Comment
muhamad idris
muhamad idris on 18 Jul 2015
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

Sign in to comment.

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!