How to overwrite the existing data in Google Spreadsheet with Blanks

datatable
uiautomation
activities
google

#1

Hi everyone,

I am trying to write a complete range to a Google Spreadsheet. I am using the Google Spreadsheet Activities for doing so.

But when I am writing to my existing Google spreadsheet, that already has data, the Write Range activity is not overwriting the existing text, in the cases when a blank is present in the data table.

So I am getting an incorrect output in my Google spreadsheet since text is present in the cells that should actually be blank.

Is there any method using which I can write the blanks present in my data table to my Google Spreadsheet?

Thanks in advance.