Need to delete rows from excel

Learn
,
1

Hi Team,

By keeping headers i want to delete all the rows whatever the range will be, i tried using delete range and clear content activity but didn’t get what i need to be.

can you please guide me how i can delete all content from range A2.

Generally i do it manually by selelcting A2 cell and used Ctrl+Shft+End and then Delete. i want to get it done by Robot

1 Like
2

Hi @omkard222

use excel application scope and use select range and then use send hot key as ctrl+shift+end and delete

Thanks
Ashwin S

3

@omkard222

  1. First use Read Range activity to read the data from excel file and it will give output as DataTable and say inputDT.

  2. And then use Insert/Delete Rows activity to delete rows and specify below values.

NoRows - inputDT.Rows.Count
Position - 2
ChangeMode - Remove
Sheet Name - “SheetName”

5 Likes
4

Hi @omkard222

use excel application scope and use select range and then use send hot key as ctrl+shift+end and delete

Thanks
Ashwin S

5

ok let me try this way

1 Like
6

hi Ashwin,

the range is not specific hence Im not able to specify the range, all i want is delete the rows from A2 to till whatever rows are available

7

Hi Lakshman,

Thank you so much it works… :slight_smile:

1 Like
8

@omkard222

Glad to help you. Happy Automation :slight_smile:

Could you please close this thread by marking above my post as solution.

9

Hi Ashwin,

Is possible for you to provide simple workflow? regarding same which you have explain

10

It is use that read range activity

11

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