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)
Delete a sheet in excel?
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.