How to delete specific column in a Google Spreadsheet

Help StudioX
,
1

I want to create a program to delete specific columns in a Google spreadsheet.
(I want to delete “C” column)
I tried to do it by using 「Gsuite activities “DeleteRange”」but it failed .
(I input C:C in the 「Range」Box but it only clear cells but clolumn is still exist. )
(I also tried “ClearRange” Activity but the result is the same.)
I used Uipath Google Workspace package(v1.16.2)

I want to know how to solve this problem.

2

HI @seino.esuv

Welcome to community

Check out this steps

image
image1378×461 24.2 KB

Regards
Sudharsan

2 Likes
3

Hi @seino.esuv

You can use the Google activity ‘Add Delete Columns’.

image

You need to pass following properties and also make sure you have selected as ‘Delete’ from drop down:

image

Hope it will help you.

2 Likes
4

Hi Sudharsan

Thank you for your kind reply!

I tried your sugestion but I can’t save to “dt”(Cannot sellect it).
I think maybe it is because of my studioX version or something.
I’ll check the newest version and try another suggestions.
If it can’t fix the problem I’ll ask you later.

Best Regards

5

Hi Rahul_S

Thank you for your kind reply

I can’ t find “Add delete Columns” in the Google activity.
I don’t know why but I think that it may be because of my old studioX version.
I"ll try updating it and I"ll try your question again!

Best Regards

7

Can you share the screen shot of your flow? @seino.esuv