Delete row excel

I want to delete row after text summary as below.

image

guide me, please.

Hello @fairymemay,
I assume your requirement is to delete all the rows coming after ‘Summary’ keyword.

If you are using Studio/ Studio X product, i would recommend you to follow below steps:

  1. Read Excel file using Read range in Excel application scope.
  2. Find the row number of ‘Summary’ keyword.
  3. Use delete Range activity to delete range of rows from same sheet.

But by observing the attached screenshot, using filter datatable activity on C column to have only not null values will give you required output.

Regards,
@poorna_nayak07

1 Like

Use delete Range activity to delete range of rows from same sheet.

How to set property in delete Range activity?

Drop Delete Range activity inside Excel Application Scope and set properties as below:
you may have to check ShiftCells propery to get proper output.

“A”+(KeywordRowIndex+1).Tostring+“:A”+(inputDT.Rows.Count+1).Tostring
Regrds,
@poorna_nayak07

Hi @fairymemay,

Take a look this activity to delete the row.

Video demonstration :

Regards
Balamurugan.S

1 Like