HOW TO REMOVE UNWANTED MULTIPLE ROWS IN A SHEET.HOW TO REMOVE ROWS IN BETWEEN OF ROWS.HOW TO SET THE RANGE OF THE ROWS WHEN WE COPY THE DATA FROM MULTIPLE SHEETS TO SINGLE SHEET.HOW TO SOLVE IT.WHAT IS THE LOGIC OF THIS

Help Automation Ops
,
1

HOW TO REMOVE MULTIPLE ROWS IN A SHEET.THE ROWS ARE IN BETWEEN DATA.HOW TO REMOVE THE ROWS FROM IT…
HOW TO REMOVE UNWANTED MULTIPLE ROWS IN A SHEET.HOW TO REMOVE ROWS IN BETWEEN OF ROWS.HOW TO SET THE RANGE OF THE ROWS WHEN WE COPY THE DATA FROM MULTIPLE SHEETS TO SINGLE SHEET.HOW TO SOLVE IT.WHAT IS THE LOGIC OF THIS.

2

can you provide the sample data

@anjani_priya

3

Hi @anjani_priya ,
You can use filter or remove data rows,
to detail , can you share your input and expect output?
regards,

4

Hi

Hope the below workflow pseudo code would help you resolve this

  1. Read Excel Data to DataTable (ExcelData)

  2. Initialize a new DataTable (FilteredData)

  3. For Each row In ExcelData

  • Check the condition to determine if the row should be kept
  • If the condition is met, add the row to FilteredData using the Add Data Row activity
  1. Write FilteredData back to Excel using the Write Range activity

Let us know if u need any further clarification

Cheers @anjani_priya

5

@anjani_priya

For removing

  1. Use a filter excel activity and then use delete rows activity with visible property…this way all the filtered rows will be deleted

For copying required ramge

  1. Usea reqd range with required range
  2. Use a copy paste ramge with the destinationr ange is also know

Cheers