Deleting matches in a huge Excel file

Help Activities
, ,
8

Hi @aaydin ,

Using BalaReva Easy Excel package, You can delete all the rows which are matched with T (“2.Flag”) is “Y”.

  • Use Excel Application Scope from BalaReva Easy Excel. Select the file.
  • Use Find an activity and specify the cell range as “T:T” and set the Find Text as “Y”.
  • Now the activity returns the row index as an integer array.
  • Conver the integer array to stirng array like this arr_strValue= arr_intValue.Select(Function(i) i.ToString()).ToArray()
  • Use the Delete Rows activity and set the Row Range the string array variable “arr_strValue”

Ref :

Regards
Balamurugan.S

Regards
Balamurugan.S