Append a row of data to the end of the current sheet
Append a row of data to the end of the current sheet
Instructions:
Follow the general script setup instructions.
Paste this code into the script editor.
Save and run the appendRowToSheet function.
Explanation: This script appends a new row to the bottom of the active sheet with the data provided in the rowData array.
function appendMyRow(){
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');
const rowData = ['New','Laurence','Svekis'];
sheet.appendRow(rowData);
//Logger.log(sheet.getName());
}
Google Apps Script code snippet appends a new row of data to a Google Sheets spreadsheet. Let's break down the code:
const rowData = ['New','Laurence','Svekis'];: This line declares a constant variable named rowData and assigns it an array containing three elements: 'New', 'Laurence', and 'Svekis'. Each element represents a value that will be added to a cell in the new row.
sheet.appendRow(rowData);: This line appends a new row of data to the Google Sheets spreadsheet referenced by the sheet variable. It uses the appendRow() method, which is a built-in function in Google Apps Script for adding a new row to the end of the specified sheet.
Here's what each part of the code does:
The rowData array contains the values that you want to insert into the new row. In this case, you have three values: 'New', 'Laurence', and 'Svekis'.
The sheet variable should be previously defined to reference the specific sheet within the Google Sheets spreadsheet where you want to append the new row. For example, you can obtain the sheet using getSheetByName() or another method based on your needs.
The appendRow(rowData) method takes the rowData array as its argument and adds a new row to the specified sheet with the values from the rowData array. Each value in the array is placed in a separate cell in the new row, starting from the first column.
When you execute this code, it will add a new row to the specified sheet with the values 'New', 'Laurence', and 'Svekis' in the respective columns.
This is a common way to programmatically insert data into a Google Sheets spreadsheet using Google Apps Script, and it's particularly useful for automating data entry tasks or updating spreadsheet content dynamically.
Course content web development and web design courses with coding examples and source code for the lesson content. Source Code is available within my Github account. Lessons posted are designed to help students learn more about a specific topic related to modern web development and applying code.
Laurence Svekis is a professional top selling course author having instructed over 1 Million students both online and in person. Laurence Svekis is a Google Developer Expert specializing in Google Workspace automation using Google Apps Script Code.
Check out my Website for more details at https://basescripts.com/
Watch video Append a row of data to the end of the current sheet online without registration, duration hours minute second in high quality. This video was added by user Laurence Svekis 05 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 354 once and liked it 3 people.