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

1 次查看（过去 30 天）

显示更早的评论

raghavendra kandukuri 2018-8-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/415679-deletion-of-first-element-from-excel-while-writing-that-in-to-txt-file

关闭： MATLAB Answer Bot 2021-8-20

PRM.txt

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 个评论
显示无隐藏无

Image Analyst 2018-8-21

You forgot to attach the input file 'mistry'xls'.

and format your code

raghavendra kandukuri 2018-8-21

mistry.xls

this is that file

此问题已关闭。

回答（1 个）

Yuvaraj Venkataswamy 2018-8-21

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/415679-deletion-of-first-element-from-excel-while-writing-that-in-to-txt-file#answer_333598

在 MATLAB Online 中打开

This will be the your answer.

if true
  misvar = xlsread('mistry.xls'); 
  misvar(1,1)=""; % empty string
end

4 个评论
显示 2更早的评论隐藏 2更早的评论

raghavendra kandukuri 2018-8-21

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 2018-8-21

For that only I attached reason in the above link.

此问题已关闭。

Community Treasure Hunt

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

Start Hunting!

Translated by