Delete Row in excel

[balupad14 (Balamurugan)]

Hi @shrutika,

1.Read the excel sheet into Datatable dtExcel1 using ReadRange Actvity
2.Use the Remove Data Row Select form the package of BalaReva.DataTable.Activities . It has the Select property where you can specify the condition to delete. (It has the sample also).
3. It has the Result return the result as datatable.
4.Use the Write Range Activity to write the data to an another excel sheet.

BalaReva.DataTable.Activities

Hi Friends. Below you have Documentation and Sample attachment for the “BalaReva.Datatable.Activities” You can find the Activities in DataTableExtensions NameSpace [image] Add Data Row Range It allows to add collection of datarow into DataTable. Sample File : AddDataRowRange.zip (7.8 KB) Remove Data Row Select It allows to remove the data rows based on the Select(Where) condition from DataTable. Sample File : RemoveDataRowSelect.zip (7.6 KB) Group By Aggregation(Sum,Count,Avg,Max,…

Regards
Balamrugan