EN
Size: a a a
EN
АМ
EN
АМ
EN
ФЧ
function onOpen() {
var ui = SpreadsheetApp.getUi();
// Or DocumentApp or FormApp.
ui.createMenu('Custom Menu')
.addItem('importresult', 'importresult')
.addItem('importpayments', 'importpayments')
.addItem('importpaymege', 'importpaymege')
.addToUi();
}
function importresult() {
var file = DriveApp.getFilesByName("result.csv").next();
var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
var sheet = SpreadsheetApp.getActiveSheet();
sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}
function importpayments() {
var file = DriveApp.getFilesByName("payments.csv").next();
var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
var sheet = SpreadsheetApp.getActiveSheet();
sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}
function importpaymege() {
var file = DriveApp.getFilesByName("payments_ege.csv").next();
var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
var sheet = SpreadsheetApp.getActiveSheet();
sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}P
МС
МС
AI
AI
AI
EN
EN
EN

AI

EN
EN

AI