Breaking News: Grepper is joining You.com. Read the official announcement!

import data from all sheets into 1 sheet in appscript

Isaac Munuhe answered on July 3, 2023 Popularity 1/10 Helpfulness 1/10

answer import data from all sheets into 1 sheet in appscript

import data from all sheets into 1 sheet in appscript

Comment

function importDataFromAllSheets() {
  var destinationSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("DestinationSheet");
  var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
  
  // Clear the destination sheet before importing data
  destinationSheet.clear();
  
  // Loop through each sheet
  for (var i = 0; i < sheets.length; i++) {
    var sheet = sheets[i];
    var sheetName = sheet.getName();
    
    // Skip the destination sheet
    if (sheetName === "DestinationSheet") {
      continue;
    }
    
    // Get the data range in the current sheet
    var dataRange = sheet.getDataRange();
    var values = dataRange.getValues();
    
    // Get the last row in the destination sheet
    var lastRow = destinationSheet.getLastRow();
    
    // Append the data to the destination sheet
    destinationSheet.getRange(lastRow + 1, 1, values.length, values[0].length).setValues(values);
  }
}

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: chat.openai.com

Tags: import javascript

Link to this answer
Share Copy Link

Contributed on Jul 03 2023

Isaac Munuhe

0 Answers Avg Quality 2/10

import data from all sheets into 1 sheet in appscript

Contents

More Related Answers

import data from all sheets into 1 sheet in appscript

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.