Remove zero in excel particular column

Hi I have a excel sheet in this in one column some value contain zero.How we can remove zero

You can use filter datatable.


thanks for reply and I have excel file that contain 4-5 sheet I just want to delete 3 sheet …?


If you want to read only particular sheet 3 means you can directly give in read range.

If you want to read all the sheets in a Excel means use Get workbook sheets activity,it will give all sheets in excel.

A Manohar

1 Like