How to Delete Range on Sharepoint Excel File?

Help Activities
, ,
1

I’ve tried Delete range activity, Clear range activity to delete some column range (Ex: A - E). I am not getting any error but also not getting rows deleted.

Used Find file and folder - and using that result to get particular file for Delete Range.

Thanks in advanced.

2

Hi @PALKUMARI_PATEL

Would you please ensure that you are providing the correct range when using the Delete Range or Clear Range activity. Double-check the range input parameter to ensure that it accurately specifies the columns you want to delete. For example, if you want to delete columns A to E, the range should be “A:E”.

Thanks!

3

Hi,

Please specify the correct range in clear sheet activity it will work…

4

Hi @PALKUMARI_PATEL
Try this

image
image812×700 20.9 KB

I hope it will works.
Regards,

5

I exactly using this “A:E” but not deleting any of the columns. I am not sure why. And I give shift : UP or Left then gives error. for the None no errors and nothing deleting.

FYI : I don’t want to shift but just tried.

6

Thanks but not sure if these will work on sharepoint directly ? I am trying to do it on sharepoint directly .

7

you will need to ensure that the user account you are using to connect to SharePoint has the appropriate permissions to delete data from the Excel file.

8

I have permissions. Clear range also not deleting the range. Can you help me to figure out the issue ?

9

@PALKUMARI_PATEL

Just to test can you try this…I guess its important to give the row numbers as well

"A1:E10"

Graph api needs A1 notation format to delete the cells…so please try to give max range to delete all the rows as needed or you can get count using read rnage and then use that to delete till end

Cheers

10

In my case it is deleting the range what i am providing.
can u send the ss.

11

Hey able to get it.
Thanks for the help.

1 Like
12

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