How can I write data to excel without overwrite data that already in the excel ?
6 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Najwa Samlan
am 3 Okt. 2019
Kommentiert: Najwa Samlan
am 3 Okt. 2019
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 Kommentare
Akzeptierte Antwort
Shubham Gupta
am 3 Okt. 2019
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 !
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!