我正在使用以下函式將事件從 Google 日歷提取到 Google 表格，有沒有辦法修改它以從多個日歷中提取事件。
function getEvents () {
var ss = SpreadsheetApp.openById("spreadsheetID").getSheetByName("Cal");
var cal = CalendarApp.getCalendarById("[email protected]");
var events = cal.getEvents(new Date("4/1/2022 12:00 AM"), new Date("4/30/2022 11:59 PM"));
var lr = ss.getLastRow();
ss.getRange(2, 1, lr-1, 5).clearContent();
for(var i = 0;i<events.length;i ){
var title = events[i].getTitle();
var sd = events[i].getStartTime();
var ed = events[i].getEndTime();
var loc = events[i].getLocation();
var des = events[i].getDescription();
ss.getRange(i 2, 1).setValue(sd);
ss.getRange(i 2, 1).setNumberFormat("mm/dd/yyyy h:mm AM/PM")
ss.getRange(i 2, 2).setValue(ed);
ss.getRange(i 2, 3).setNumberFormat("mm/dd/yyyy h:mm AM/PM")
ss.getRange(i 2, 3).setValue(title);
ss.getRange(i 2, 4).setValue(loc);
ss.getRange(i 2, 5).setValue(des);
}
}
uj5u.com熱心網友回復：
試試這個：
function getEvents() {
const ss = SpreadsheetApp.getActiveSheet();
var lr = ss.getLastRow();
if (lr > 0) {
ss.getRange(2, 1, lr - 1, 5).clearContent();
}
const ids = ['[email protected]', '[email protected]'];//cal ids
ids.forEach(id => {
let cal = CalendarApp.getCalendarById(id);
let events = cal.getEvents(new Date("4/23/2022 8:00 AM"), new Date("4/23/2022 5:00 PM"));
for (var i = 0; i < events.length; i ) {
var title = events[i].getTitle();
var sd = events[i].getStartTime();
var ed = events[i].getEndTime();
var loc = events[i].getLocation();
var des = events[i].getDescription();
ss.appendRow([sd,ed,title,loc,des])
}
})
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/463290.html
標籤：javascript 谷歌应用脚本 谷歌表格 谷歌日历 API