How to delete a sheet from excel or clear its data?
You can make use of Excel shortcut keys
ALT + E + L or
Use send hotkey activity to make use of them.
PS: If you’re looking to clear DataTable then UiPath has Clear DataTable Activity.
No, It is not working. I am looking for Excel sheet delete only. Can you attach some sample XAML which I can quickly refer?
Here we go.
Just make sure excel is in the foreground while running the workflow.
DeletExcel.xaml (5.8 KB)
Yes, I got it just now before you replied. I was missing the step where Excel needs to run in foreground.
I have to add excel screen shot in XAML so that keystrokes will be done on Excel app.
Here is a detailed article on that
# How To Delete Sheets From An Excel File Programmatically – In UiPath