How can i empty data by reference by sheet name?

Hi @lovepong66

You can try with Delete Range activity

In the Range try with this expression

"A2:"+UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DtRead.Columns.Count)+(DtRead.Rows.Count+1).ToString

Check out this XAML file

DeleteRange.xaml (6.7 KB)

image

Regards
Gokul

1 Like