1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
| function transpose() {
var SPREADSHEET_URL = 'docs.google.com';
var SECONDSPREADSHEET_URL = 'docs.machin.google.com';
var ss = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
var ssd= SpreadsheetApp.openByUrl(SECONDSPREADSHEET_URL);
//Logger.log(ss.getSheetByName(SPREADSHEET_URL));
//Logger.log(ssd.getSheetByName(SECONDSPREADSHEET_URL));
var SHEET_NAME = 'worksk';
var SHEET_SECONDNAME='works1'
var ss = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
var sheet = ss.getSheetByName(SHEET_NAME);
var ssd = SpreadsheetApp.openByUrl(SECONDSPREADSHEET_URL);
var sheetd = ss.getSheetByName(SHEET_SECONDNAME);
// var cells= sheetd.getRange('A2');
var cell = sheet.getRange('A2');
var rule = SpreadsheetApp.newDataValidation()
.requireNumberBetween(1, 100)
.setAllowInvalid(false)
.setHelpText('Number must be between 1 and 100.')
.build();
cell.setDataValidation(rule);
// append ligne in the project
// the values in the array.
sheet.appendRow(['a man', 'a plan', 'panama', 'a plan', 'a plan', 'a plan', 'a plan']);
{
// copy the first 5 columns over to the 6th column.
var rangeToCopy = sheet.getRange(1, 1, sheet.getMaxRows(), 5);
rangeToCopy.copyTo( sheetd.getRange(10, 5));
}
} |
Partager