Google Scripts Guide to Clearing Data

  1. Get a range
let range = mySheet.getRange("A1:B8")
range.clear()
range.clearContent()
range.clearFormat()
let formulas = range.getFormulas()range.clearContent()range.setFormulas(formulas)

--

--

--

Tech stuff and SwiftUI

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Game Design with Flyweight Pattern

Sweet Sweet Syntax  — in Ruby

Using J-Meter to upload bulk details in a CSV file to the database via an endpoint

Spring integration xml : Retry handler in outbound adapter

5 Ways to Learn a New Coding Language

The technology insurance platform of the future

A person working with a laptop

Azure App Service Networking

Getting started with Serverless framework + AWS Lambda and API Gateway

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Peter Flickinger

Peter Flickinger

Tech stuff and SwiftUI

More from Medium

Developing Skills for Future Success With Restaurant Work

16–2. Development and Deployment

Revenue model of UberEats clone app from Foodtro

Professional Benefits of Getting your AWS Certification (Dmytro Bavykin)