Delete empty row

I’m removing maching value from data table after that i want to rewrite that table to same excel file ,but it was not removing complete row from data table some columns have sum at bottom these corresponding column rows not removing? anuyone know why ?


Did you try using filter datatable to filter out the non required rows?


Hi @pravin_bindage ,

When rewriting the data to the same excel sheet, you would need to remove/Delete the rows that is already present and then Insert the new Data.

The removal of existing data can be done by using a Write Cell Activity. Below post describes the steps to perform the operation :

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.