Conditional formatting

[supermanPunch (Arpan)]

@E.T.S

Read range → filter data table → write to csv

@E.T.S ,

For the Highlighted one, Could you show us the configuration done in Filter Datatable activity ?

For Removing Empty rows, we could also try with the Linq instead of Filter Datatable :

YourDT = YourDT.AsEnumerable.Where(Function(x)Not (x.ItemArray.All(Function(i)String.IsNullOrWhiteSpace(i.ToString)))).CopyToDatatable

For Handling errors when all rows are empty, CopyToDatatable method gives out an Error and we could handle it by implementing it like shown below :

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…