Hi I’m trying to delete all the data in the sheet using the Excel.Delete.Range activity. I know that the current situation can be realized by specifying “A1: XFD1048576” which is the maximum value of Excel in the property of range specification, but if possible, delete up to the maximum location w…

Hi @nittobo5 , I’ve delete the entire data from sheet by the below method. I’ve connect the Excel as a db and then update all the column values into NULL. Note: We can’t delete the table while it’s connecting. I think this method will help you to achieve. Thanks and Regards, Manoj Vijayakumar D…

Delete all the data in the ExcelSheet using the Excel.Delete.Range activity

Help

balupad14 (Balamurugan) June 24, 2019, 9:48am 6

Hi @nittobo5,

Instead of delete all data. Better to delete the sheet and add a new sheet in the excel with same name.

Regards
Balamurugan.S

How to get the last column header and the data of last row value from the excel sheet

Invoke code - Exception has been thrown by the target of an invocation

Topic		Replies	Views
Delete Range Activities Help excel , activities , question	3	3172	March 13, 2020
Delete range Help studio	12	11284	February 3, 2022
How to delete all the data from a sheet using delete range activity Studio studio , question , activities_panel	4	1524	August 24, 2022
Sql query to delete the excel sheet data Help	36	4988	August 29, 2019
How to clear Excel Sheet using Uipath Studio datatable , excel , studio , question , activities_panel	10	3442	August 3, 2022

Most Active Users - Yesterday
ashokkarale
Yoichi
sharazkm32
pr1
lrtetala
H_Kim
AkshaySandhu
Muhammad_Taeyyab
Roman-Routinuum
sudster
More details...

Delete all the data in the ExcelSheet using the Excel.Delete.Range activity

Related topics