Add new data into existing excel file
27 views (last 30 days)
Show older comments
Hazel Sialongo
on 4 Oct 2016
Commented: Cádmo Dias
on 25 Mar 2019
I have an existing excel file and I want to add new data in a new column. How will I do that?
0 Comments
Accepted Answer
Gareth Thomas
on 4 Oct 2016
If you use xlswrite with this code it should work:
filename = 'testdata.xlsx';
A = {'Time','Temperature'; 12,98; 13,99; 14,97};
sheet = 2;
xlRange = 'E1';
xlswrite(filename,A,sheet,xlRange)
Notice how the xlRange shows the columns.
2 Comments
Cádmo Dias
on 25 Mar 2019
First of all, thanks for your help,Gareth!
Hazel, I suggest to you increase the range, in "xlRange" variable, to change the column.
More Answers (0)
See Also
Categories
Find more on Spreadsheets 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!