Clear specific range in excel

[murat.karasoy]

Hi,

I want to clear beetween A1 and Z5 and the remaining columns to go up.I use delete range activity but I failed. How can I do that?
my resault:

my desire:

[argin.lerit]

@murat.karasoy

Try Delete Rows instead of Delete Range: https://docs.uipath.com/activities/other/latest/user-guide/delete-rows-x

Hope this helps!

[rlgandu (Rajyalakshmi Gandu)]

Hi,
I hope this will help you,

1. Drag and drop an “Excel Application Scope” activity into your workflow and indicate the Excel file you want to work with.
2. Within the “Excel Application Scope” activity, place a “Clear Range” activity.
3. In the “Clear Range” activity properties panel, specify the following details:

• Range: Enter the range you want to clear, such as “A1:C10”. You can provide a specific cell range or a named range.
• SheetName: Specify the name of the worksheet where the range is located. You can either enter the sheet name directly or use a variable that holds the sheet name.

4. Save and run your automation to clear the specified range in Excel.
   Thank You.