how to delete a rows with column zeros in excel file

1 次查看（过去 30 天）

Parthiban 2022-10-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1828083-how-to-delete-a-rows-with-column-zeros-in-excel-file

Please find the attached excel sheet. In that we have a column from "A to J". out of these i will focus only in column 'C' having zeros in start / end.

My doubt is How to delete all start and end rows with respect to zeros present in column 'C' . suppose column 'C' having zeros in starting and ending, so i need to delete all corresponding rows and saves a new excel file in another location path.

Kindly give a suggestion on this !

here i attached a file "output RPM' and i need like this.

Note:

refer "output RPM" file, In that column 'C', having one zero in start and end of the rows and the remaining rows will be deleted. like this i want . kindly help me

[file,filepath]=uigetfile({'*.csv;*.xlsx;*.xls';},'Select Trajectory Table File(s)','C:\Users\INARUPAR\Desktop\MATLAB WORKOUT\', 'MultiSelect', 'on');

if ~iscell(file)

file = {file};

disp(file)

end

output_file_name = 'output RPM.csv';

column_name = {'Y1'}; % <--- columns name here

fig = figure();

ax = axes();

l = legend(ax);

hold(ax);

ax.ColorOrder = [1 0 0 ; 0 0 1]; % it gives RED Color

drawnow;