Deletion of first element from excel while writing that in to txt file
Información
La pregunta está cerrada. Vuélvala a abrir para editarla o responderla.
Mostrar comentarios más antiguos
Hi, I have an excel with 2 columns, I am reading this file from .m file and through dlmwrite, writing it to the note pad but I want to skip the first element when ever it writes to the note pad with empty string or blank but not with the second element.
misvar = xlsread('mistry.xls'); m1=misvar(:,1); m1=m1'; dlmwrite('PRM.txt',m1,'delimiter','\t','-append','newline','pc');
output file is also attached to the above question, I wan to skip value 300(first element in the output) and leave it blank
2 comentarios
Image Analyst
el 21 de Ag. de 2018
You forgot to attach the input file 'mistry'xls'.
raghavendra kandukuri
el 21 de Ag. de 2018
Respuestas (1)
Yuvaraj Venkataswamy
el 21 de Ag. de 2018
This will be the your answer.
if true
misvar = xlsread('mistry.xls');
misvar(1,1)=""; % empty string
end
4 comentarios
raghavendra kandukuri
el 21 de Ag. de 2018
Yuvaraj Venkataswamy
el 21 de Ag. de 2018
This is the command to leave it blank.
if true
misvar =xlsread('mistry.xls');
misvar(1,1)=[];
end
But, we can't do that. Reason is there in below link.
https://in.mathworks.com/matlabcentral/answers/287786-a-null-assignment-can-have-only-one-non-colon-index-when-i-eliminated-elements-of-matrix
raghavendra kandukuri
el 21 de Ag. de 2018
Yuvaraj Venkataswamy
el 21 de Ag. de 2018
For that only I attached reason in the above link.
La pregunta está cerrada.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!