How to delete specific rows from excel file

Learn
1

I want to delete specific rows within an excel file. I need to delete all of row 1 - 4 and row 6. How can I do that in Studio 2020.4.1 version? I can do it in Studio X just fine, but trying to figure out how to do in Studio is a littler trickier.

image

2

@olsonse You can use Excel Application Scope and use the Delete Rows Activity Inside specifying the position and the No. Of rows to be deleted.

3

How do I specify the position?

4

@olsonse In your Case, if you would need to Delete 1 - 4 rows, then position would be 1 and Number of rows would be 4

5

I also need to delete out row 6. Do I have to do a separate delete row activity for that or can I do it in the same activity for the deletion for rows 1-4?

6

@olsonse A Separate Delete Activity

7

what would the position and number of rows be for that? position = 6 and number of rows = 1?

8

@olsonse Actually After you delete the rows 1-4 the Row Number gets changed and think it would be in Position 2

9

it worked. thank you!

1 Like
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.