Info

Cette question est clôturée. Rouvrir pour modifier ou répondre.

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

1 vue (au cours des 30 derniers jours)
raghavendra kandukuri
raghavendra kandukuri le 21 Août 2018
Clôturé : MATLAB Answer Bot le 20 Août 2021
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 commentaires
Image Analyst
Image Analyst le 21 Août 2018
You forgot to attach the input file 'mistry'xls'.

Réponses (1)

Yuvaraj Venkataswamy
Yuvaraj Venkataswamy le 21 Août 2018
This will be the your answer.
if true
misvar = xlsread('mistry.xls');
misvar(1,1)=""; % empty string
end
  4 commentaires
raghavendra kandukuri
raghavendra kandukuri le 21 Août 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)= [];
Yuvaraj Venkataswamy
Yuvaraj Venkataswamy le 21 Août 2018
For that only I attached reason in the above link.

Cette question est clôturée.

Community Treasure Hunt

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

Start Hunting!

Translated by