Google apps script for next loop tutorial

Google apps script for next loop tutorial

In this post, you’ll learn Google Apps Script For Next loop, syntax and examples explaining how to use For Next loop effectively in the apps scripting.Google apps script for next loop thumbnail

Google Apps Script For Next loop

For loop execute a set of statements or instructions for specified number of times. It has the loop index which counts the number iterations as the loop executes.

 

Syntax of Google Apps Script For Next loop

 

            for(initialization, condition, increment)

          {

              Set of instructions to be executed;

          }

 

Initialization– It is executed only one time when compiler enters into the for loop. Here, you have to declare and initialize for loop counter variable and start value.

Condition – During each iteration, the compiler checks the condition given in this place. It executes the instructions present inside the curly braces only if the condition is true.

Increment– It increments the counter variable after each iteration of For loop.

 

Example of Google apps script for next loop

In this example, we’ll learn about the Google apps for next loop by printing numbers 1 to 10 in Column A of sheet 1.Go to Google drive -> New -> Google sheets. A new Google sheets will be opened. Enter a sheet name and save it. Go to Tools-> Script Editor. A script editor window will be opened in a new tab. Enter the below code in the script editor, save and execute it.


function for_next_loop_apps_scrip()

{
 var wb= SpreadsheetApp.getActiveSpreadsheet();
 var sh1=wb.getActiveSheet();
  
  for(i=1;i<=10;i++)
  {
    var cell=sh1.getRange(i, 1);
    cell.setValue(i);
      
  }
    
}

Explanation

 var wb= SpreadsheetApp.getActiveSpreadsheet(); – getActiveSpreadsheet() method returns the object of currently opened spreadsheet.

var sh1=wb.getActiveSheet(); – getActiveSheet() method returns the currently active sheet in the google sheets app.

  for(i=1;i<=10;i++)– Here for loop is initialized with value 1, then it check the condition whether variable i is always lesser than or equal to 10 before executing the loop statement. After each iteration, counter variable i is increased by 1.

 var cell=sh1.getRange(i, 1) – getRange(rows, columns) method return the position of cell in a sheet by its rows and column index.

cell.setValue(i);- setValue(Object) method populate the object or value present inside the parenthesis on the specified cell.

Outputgoogle apps script for next loop output

Leave a Reply