Info

This question is closed. Reopen it to edit or answer.

Deletion of first element from excel while writing that in to txt file

1 view (last 30 days)
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

Answers (1)

Yuvaraj Venkataswamy
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
raghavendra kandukuri on 21 Aug 2018
It does not work either, it is throwing the following error:
A null assignment can have only one non-colon index.
Error in untitled>pushbutton3_Callback (line 225) misvar(1,1)= [];

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!