How can I write data to excel without overwrite data that already in the excel ?
9 次查看(过去 30 天)
显示 更早的评论
Hi, please help me .
Here is my code:-
filename = 'F:\FYP\Training.xls';
A = {person,A,B,EuclideanDistance,r};
sheet = 1;
xlRange = 'A2';
xlswrite(filename,A,sheet,xlRange)
I want my new data to be insert to the last row(empty row) in that training file.
0 个评论
采纳的回答
Shubham Gupta
2019-10-3
To write in the empty rows, you have to specify that to xlswrite. So, either you know the row number beforehand and use that 'xlRange' to write the variable 'A'. Example:
filename = 'F:\FYP\Training.xls';
A = {person,A,B,EuclideanDistance,r};
sheet = 1;
empty_row = 10
xlRange = ['A',num2str(empty_row)];
xlswrite(filename,A,sheet,xlRange)
Or if you don't know the row number beforehand you can count the filled rows inside the file using xlsread. Example:
filename = 'F:\FYP\Training.xls';
A = {person,A,B,EuclideanDistance,r};
sheet = 1;
[~,~,ev] = xlsread(filename,sheet); % ev is cell array containing every filled row and column
empty_row = size(ev,1) + 1;
xlRange = ['A',num2str(empty_row)];
xlswrite(filename,A,sheet,xlRange)
I hope it helps !
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!