ЖА
Size: a a a
ЖА
EN
EN
ЖА
function myFunction() {
var ss = SpreadsheetApp.getActiveSpreadsheet(),
s = ss.getActiveSheet();
var options = {
'muteHttpExceptions': true
};
// var data = UrlFetchApp.fetch("https://drive.google.com/uc?id=1RX3V4mCDSbmUsKqHiIwFDvOVw3yfY-ke&export=download", options).getContentText();
var data = UrlFetchApp.fetch("https://drive.google.com/uc?id=1QbpstHRrrCWamvr638YS-r8B6I1ObBei&export=download", options).getContentText();
var xmlDocument=XmlService.parse(data);
var root=xmlDocument.getRootElement();
var smses=root.getChildren("sms");
var bodyArr;
for (var i = 0; i < smses.length; i++) {
var address = smses[i].getAttribute('address').getValue();
var read_date = smses[i].getAttribute('readable_date').getValue();
var body = smses[i].getAttribute('body').getValue();
// var categoryElements = entries[i].getChildren('category', atom);
// var labels = [];
// for (var j = 0; j < categoryElements.length; j++) {
// labels.push(categoryElements[j].getAttribute('term').getValue());
// }
bodyArr = body.split(" ");
s.getRange('A' + (i+1)).setValue(read_date);
s.getRange('B' + (i+1)).setValue(body);
s.getRange('C' + (i+1)).setValue(bodyArr[bodyArr.length-1].split("'").join("").replace('.',','));
}
var lastRow = s.getLastRow();
var lastCell = s.getRange(lastRow, 3);
s.getRange('E1').setValue(lastCell.getValue());
Logger.log(lastCell.getValue());
// Logger.log(s.getLastRow().getRange());
// Logger.log(keywords);
}
OY
EN
function myFunction() {
var ss = SpreadsheetApp.getActiveSpreadsheet(),
s = ss.getActiveSheet();
var options = {
'muteHttpExceptions': true
};
// var data = UrlFetchApp.fetch("https://drive.google.com/uc?id=1RX3V4mCDSbmUsKqHiIwFDvOVw3yfY-ke&export=download", options).getContentText();
var data = UrlFetchApp.fetch("https://drive.google.com/uc?id=1QbpstHRrrCWamvr638YS-r8B6I1ObBei&export=download", options).getContentText();
var xmlDocument=XmlService.parse(data);
var root=xmlDocument.getRootElement();
var smses=root.getChildren("sms");
var bodyArr;
for (var i = 0; i < smses.length; i++) {
var address = smses[i].getAttribute('address').getValue();
var read_date = smses[i].getAttribute('readable_date').getValue();
var body = smses[i].getAttribute('body').getValue();
// var categoryElements = entries[i].getChildren('category', atom);
// var labels = [];
// for (var j = 0; j < categoryElements.length; j++) {
// labels.push(categoryElements[j].getAttribute('term').getValue());
// }
bodyArr = body.split(" ");
s.getRange('A' + (i+1)).setValue(read_date);
s.getRange('B' + (i+1)).setValue(body);
s.getRange('C' + (i+1)).setValue(bodyArr[bodyArr.length-1].split("'").join("").replace('.',','));
}
var lastRow = s.getLastRow();
var lastCell = s.getRange(lastRow, 3);
s.getRange('E1').setValue(lastCell.getValue());
Logger.log(lastCell.getValue());
// Logger.log(s.getLastRow().getRange());
// Logger.log(keywords);
}
EN
ЖА
АИ
EN
ЖА
G
EN
C
525
Eugeny Namokonov371
Admin254
Kanat150
volond 84
Leo 70
Роман Игнатов 63
Vitaliy P. 59
Dmitriy 42
Mikhail Sh. 33
Igor BorisevichR
EN
A
EN
R
A