How can I write data to excel without overwrite data that already in the excel ?
6 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Najwa Samlan
el 3 de Oct. de 2019
Comentada: Najwa Samlan
el 3 de Oct. de 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 comentarios
Respuesta aceptada
Shubham Gupta
el 3 de Oct. de 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 !
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!