How to Delete multiple colums in Excel by StudioX

Help StudioX
, ,
1

How to delete multiple open tabs in Studio X?

I used the Delete Column activity to delete columns A through E, but it’s not working.

Please share your wisdom…

The image shows a software interface for a process automation tool, specifically configured to delete a column from an Excel source that includes headers. (Captioned by AI)
The image shows a software interface for a process automation tool, specifically configured to delete a column from an Excel source that includes headers. (Captioned by AI)487×415 9.95 KB

2

@_ICNFBG_KIM_SE_JIN,

Could you please try using Delete range activity?

In this activity we can pass the column range to delete.

3

Hi,

Can you try as the following?

image
image651×734 17.2 KB

Regards,

4

The image shows a UiPath activities panel with various Excel range operations listed, including append, autofit, clear sheet, copy/paste, fill, get selected, lookup, read, select, and sort. (Captioned by AI)
The image shows a UiPath activities panel with various Excel range operations listed, including append, autofit, clear sheet, copy/paste, fill, get selected, lookup, read, select, and sort. (Captioned by AI)351×385 9.44 KB

There is no Delete range..:cry:

5

Hi @_ICNFBG_KIM_SE_JIN

Try to install latest package , and then search “Delete Column” activity

The image shows a software package manager interface for UiPath, specifically highlighting the "UiPath.Excel.Activities" package, including its details and version options. (Captioned by AI)
The image shows a software package manager interface for UiPath, specifically highlighting the "UiPath.Excel.Activities" package, including its details and version options. (Captioned by AI)892×494 38.8 KB

Happy Automation.