Extinct Animals in the Sahara

After animals go through the different stages of endangered, they eventually become extinct. Extinct is no longer in existence. In the beginning, many animals left the Sahara because they realized…


独家优惠奖金 100% 高达 1 BTC + 180 免费旋转

Google App Script Reading and Writing Excel Sheet

Welcome to my blog again. This time I’m here to teach you Google App Script

Today we will see how to write data validations & adding dynamic dropdown in excel sheet.

Data Validation Image

After clicking on Data Validation below image will come-up

Today our main focus is on second approach that is, google app script. I’m assuming while reading this blog you have prior knowledge to google app scripts.

In this blog we will use SpreadsheetApp class from google sheets. Below are the methods which will be used for reading and writing the sheets.

We will understand this class and above methods one by one.

2. openById ( fileId )

3. newDataValidation ( )

4. requireValueInList ( range, showDropDown)

5. setDataValidation ( rule )

Below is the example code snippet that will access a sheet and will create a dropdown in Sheet1 using Sheet2

Code Snippet

I hope you enjoyed my blog. I would love to hear from you. Do comment, share & don’t forget to clap !!!

Add a comment

Related posts:

The comeback of Christian Eriksen

Five days before Christian Eriksen arrived at Brentford, Thomas Frank predicted he could be the club’s “greatest signing.” Frank hadn’t yet seen him train, but the Brentford manager — who coached…

Where to Invest in Cleantech

The 17th Wall Street Green Summit (link is external) put that notion that CleanTech is solar and wind to shame. Investors and market makers convened to talk about water, agriculture, drones…


Come with me in the silence of darkness I want to show you secrets of life I will ___ you where dreams could’t take you She seldom flew away in the night You’re the ____ flower You’re the…