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

Help
1

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

2

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
3

No, It is not working. I am looking for Excel sheet delete only. Can you attach some sample XAML which I can quickly refer?

4

Here we go.
Just make sure excel is in the foreground while running the workflow.
DeletExcel.xaml (5.8 KB)

1 Like
5

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
6

Hi @abskulkarni,

Please refer this link here…

Thanks and Regards,
Manoj Vijayakumar.

7

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