How to delete a sheet from excel or clear its data?

How to delete a sheet from excel or clear its data?

Hi,
You can make use of Excel shortcut keys
ALT + E + L or
ALT+H+D+S
Use send hotkey activity to make use of them.

PS: If you’re looking to clear DataTable then UiPath has Clear DataTable Activity.

3 Likes

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)

1 Like

Yes, I got it just now before you replied. I was missing the step where Excel needs to run in foreground. :slight_smile:
I have to add excel screen shot in XAML so that keystrokes will be done on Excel app.

1 Like

Hi @abskulkarni,

Please refer this link here…

Thanks and Regards,
Manoj Vijayakumar.

hi @abskulkarni

Here is a detailed article on that :slight_smile:
# How To Delete Sheets From An Excel File Programmatically – In UiPath

Regards,

1 Like