How to delete certain columns in a excel spreadsheet

Ask in Your Language 中文
1

Hi guys

Just want to know how to delete the whole column whose row 21 is 0. (Range B21:O21) in UiPath. Thanks

2

Hie @zhenghua_cui you can use activity provided by UiPath…

This image shows a UiPath workflow for modifying an Excel file by inserting/deleting columns and rows in "Sheet1" at specified positions. (Captioned by AI)
This image shows a UiPath workflow for modifying an Excel file by inserting/deleting columns and rows in "Sheet1" at specified positions. (Captioned by AI)888×494 27.9 KB

Choose want you want to delete row or column and in the property panel select change mode to remove
cheers Happy Automation

1 Like
3

@zhenghua_cui mark this as solution if it finds you as a solution
cheers

4

Hi @zhenghua_cui ,

You can Use Delete row activity and Delete the range you have mentioned.