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

[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…