Add few features in Excel like Select Sheet, Clear Cells Values

[cthamizh (Thamizh Chezhiyan)]

Hi,

I would like to have the below functionalities to be added in Excel related activities. This would make UiPath more user friendly.

• Select or Active particular sheet
• Clear cells values
• Delete row / Delete Column

[badita (Mihai Badita)]

@cthamizh

Select or Active particular sheet
Clear cells values
Delete row / Delete Column

• use Select Range
• this is equivalent with Write Cell/Write Wrange with empty values
• you can do Delete Column/Insert Column within an Excel Table

Delete Row looks a good idea. Right now you can do it via UiAutomation.

How to delete columns in Excel file

Well, actually there are few workarounds. If you’re working with an Excel Table you can directly use Delete Column activity Though not so obvious, there are many things you can achieve via UI Automation and shortcut keyboards. Let’s say you want to delete column C. This sequence of activities will work: Go To C1, ALT+H, D, C. Make sure you remove the Activate on the last two Type Activities. DeleteColumnC.xaml (8.0 KB) Now, if you want to delete columns from G to AA you just need to re…

[Uma]

I want to copy the data from the excel file and paste it into another excel file could u please give solution.myfirst excel is not saved it just export as excel .

[badita (Mihai Badita)]

ask in Rookies but first go through the academy training.