Delete data except header in excel

vvaidya (Vinay Vaidya) February 20, 2018, 2:27pm 11

One workaround is add an empty row and write range with Add headers. Make sure the empty row doesn’t impact the downstream process.

1 Like

Clear worksheet

Topic		Replies	Views
Clone data table but use only headers and write to excel Help datatable , excel	10	6246	February 21, 2020
To clear data in an Excel sheet before writing a datatable in to it Help excel , activities , question	10	8930	August 10, 2020
Write Range Activity doesn't allow empty DT to add headers in the Excel Activities activities , completed	13	4432	June 17, 2021
In UIPath I have a requirement for Excel Help	5	1093	March 15, 2019
Clear worksheet Help	13	8112	April 25, 2021