I have one excel file and have some data inside [image] I need to empty data in every fields by specific by sheet name … such as “Sheet1” so, the result will be good if it like this [image] Thanks,

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 …

How can i empty data by reference by sheet name?

Help Activities

lovepong66 (Rugpong Sirimart (Luck)) November 16, 2022, 10:32am 5

100% for me Thanks,

1 Like

Topic		Replies	Views
How to delete Excel sheet data without Excel activities Studio studio , question , workflow_diff	8	541	January 21, 2024
Delete excel work sheet Activities excel , activities , question	6	1438	December 31, 2021
Delete column of the sheet Academy Feedback studio	8	3892	April 4, 2019
How to delete data in excel sheets without deleting sheetnames Help excel , activities , question	7	1046	May 28, 2020
Delete a sheet in Excel Help excel	6	18896	October 29, 2018

How can i empty data by reference by sheet name?

Related topics