Deletion of first element from excel while writing that in to txt file
Info
This question is closed. Reopen it to edit or answer.
Show older comments
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 Comments
Image Analyst
on 21 Aug 2018
You forgot to attach the input file 'mistry'xls'.
raghavendra kandukuri
on 21 Aug 2018
Answers (1)
Yuvaraj Venkataswamy
on 21 Aug 2018
This will be the your answer.
if true
misvar = xlsread('mistry.xls');
misvar(1,1)=""; % empty string
end
4 Comments
raghavendra kandukuri
on 21 Aug 2018
Yuvaraj Venkataswamy
on 21 Aug 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
on 21 Aug 2018
Yuvaraj Venkataswamy
on 21 Aug 2018
For that only I attached reason in the above link.
This question is closed.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!