Parameter List
Syntax
OVERWRITE(data,
[destination]
)data
The range or {data}
cell from where data is to be inserted into the destination range. The first row of data will be used as a header of the destination range. For example: A1:E4
or A2
.
Pro tip: If the headers are in a column instead of a row of a range, use RANGE2JSON
to create a {data}
cell first.
[optional] destination
The cell or range where the data is to be inserted. In case of a vertical range, headers will be inserted vertically. For example: A15:E15
.