I am using GSuite application block to write range in a particular spreadsheet
I am getting a value from another spreadsheet and processing it and after which i write the datatable in a new sheet.
First time i am having 20 rows which i am processing and writing and in the next run the output row count reduces to 10.
The new set of data over rights the first 10 rows and the range 10 to 20 is not deleted.
Can some one advice what can be done for deleting the whole range of cells before writing.
Tried: Deleting the sheet and creating a new sheet with the same name before writing but this removes my conditional formatting which is required.