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

import function in AppsScript

Thankful Toad answered on March 11, 2024 Popularity 1/10 Helpfulness 1/10

answer import function in AppsScript

import function in AppsScript

Comment

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Custom Menu')
      .addItem('Import Values', 'showSidebar')
      .addToUi();
}

function showSidebar() {
  var html = HtmlService.createHtmlOutputFromFile('Sidebar')
      .setTitle('Import Data');
  SpreadsheetApp.getUi().showSidebar(html);
}

# add the sheet ID and the name
function importValues(sourceId, sourceSheetName) {
  try {
    var sourceSheet = SpreadsheetApp.openById(sourceId).getSheetByName(sourceSheetName);
    var destinationSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet_Name');
    
    if (!sourceSheet || !destinationSheet) {
      throw new Error("Source sheet or destination sheet not found!");
    }
    
    var values = sourceSheet.getRange('custom:range').getValues();
    destinationSheet.getRange(1,1,values.length,values[0].length).setValues(values);
    
    SpreadsheetApp.getUi().alert('Values imported successfully!');
  } catch (error) {
    SpreadsheetApp.getUi().alert('Error: ' + error.message);
  }
}

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: chat.openai.com

Tags: function import javascript

Link to this answer
Share Copy Link

Contributed on Mar 11 2024

Thankful Toad

0 Answers Avg Quality 2/10

import function in AppsScript

Contents

More Related Answers

import function in AppsScript

Grepper

Documentation

Social

Legal

Contact

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