How can I write data to excel without overwrite data that already in the excel ?

Question

Najwa Samlan 2019-10-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/483364-how-can-i-write-data-to-excel-without-overwrite-data-that-already-in-the-excel

评论： Najwa Samlan 2019-10-3

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Shubham Gupta 2019-10-3

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/483364-how-can-i-write-data-to-excel-without-overwrite-data-that-already-in-the-excel#answer_394581

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)