Remove empty row in the excel

Help
16

I realize this post is a bit old, but in case anyone is searching for help I figured I’d post my approach. Sorry I can’t upload an actual .xaml due to company restrictions.

This way is a bit more customizable as it can filter on specific columns. I have it saved as a code snippet, which I’d highly recommend.

Put the following in a sequence:

1. Assign Activity: data_to_del (array of DataRow) --> datatable.Select("[COLUMN] is null")

     * This stores the empty rows of [COLUMN]  in an array of DataRows. Multiple columns can be included in the select statement

2. For each row in data_to_del (be sure to update the TypeArgument property to System.Data.Datarow)
Remove data row

This is just a quick sequence that can be added almost anywhere and is easily customizable to quickly remove empty rows from a datatable. It can also be modified to search for specific values other than null values by modifying the select statement in step 1.