导出谷歌日历与使用GAS

Question

我已经提取的谷歌日历打印请求参数事件PDF，使他们可以将它们使用Google Apps脚本用于出口或UrlFetchApp

的参数列表如下，当我访问该网址通过登录浏览器它显示事件

但是，当我通过应用程序脚本运行相同，我得到一个日历PDF没有事件。

如何隐式或显式传递授权？ 我刚刚通过承载

https://calendar.google.com/calendar/printable?psd=false 
&ctz=Asia%2FCalcutta 
&dates=20170507%2F20170520 
&mode=month 
&pbw=false 
&pfs=NORMAL 
&pft=pdf 
&pgsz=a4 
&pli=1 
&po=PORTRAIT 
&pred=20170520 
&prsd=20170507 
&psa=false 
&psdec=false 
&pset=false 
&psr=false 
&rand=-6094307348214370018# 
&src=Y29mbS5lZHUuaW5fdWxoOHIza2Fyc2QyYnVzaDAzNG10OTIzbjRAZ3JvdXAuY2FsZW5kYXIuZ29vZ2xlLmNvbQ 

我的应用程序的脚本，

//url specified as above 

    var response = UrlFetchApp.fetch(url, { 
    headers: { 
     'Authorization': 'Bearer ' + ScriptApp.getOAuthToken() 
    }, 
    'followRedirects': true 

}); 

Answer 1

我总是发现打印视图切断事件名称，无论我做了什么调整视图，使尽可能大的盒子。 我最终编写了一个使用HTML服务生成打印友好日历的脚本。 我把它作为一个网络应用程序发布，网站的访问者可以使用浏览器的打印工具来打印它，但我也会用不同的脚本将其称为不同的脚本，每个月都会通过电子邮件将其pdf发送到邮件列表。 的谷歌Apps脚本：

var hasFourthRow=false; 
var hasFifthRow=false; 
var hasPreviousMonth=false; 

function doGet(e) { 
    var calendarID = "your_cal_id"; 
    var calName = "My Calendar"; 
    var future; 
    if(!e.parameter.future){ 
    future = 0 
    } else { 
    future = +e.parameter.future; 
    hasPreviousMonth = true; 
    } 
    if(!d){ 
    var d = new Date(); 
    } 
    var months = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"]; 
    var monthNumber = future + d.getMonth() 
    var yearNumber = d.getFullYear(); 

    if(monthNumber > 12){ 
    monthNumber = monthNumber - 12; 
    yearNumber = yearNumber + 1; 
    } 



    var monthBegin = new Date(yearNumber, monthNumber, 1); 
    var firstSundayInGrid = new Date(monthBegin); 



    monthNumber = monthNumber + 1; 
    if(monthNumber > 12){ 
    monthNumber = monthNumber - 12; 
    yearNumber = yearNumber + 1; 
    } 

    var prevMonthNumber = monthNumber - 1; 
    var prevYearNumber = yearNumber; 
    if(prevMonthNumber < 1){ 
    prevMonthNumber = prevMonthNumber + 12; 
    prevYearNumber = prevYearNumber - 1; 
    } 
    var nextMonthNumber = monthNumber + 1; 
    var nextYearNumber = yearNumber; 
    if(nextMonthNumber > 12){ 
    nextMonthNumber = nextMonthNumber - 12; 
    nextYearNumber = nextYearNumber + 1; 
    } 

    var calDate = months[monthNumber-1].concat(" ", yearNumber); 
    firstSundayInGrid.setDate(monthBegin.getDate() - monthBegin.getDay()); 
    var monthEnd = new Date(yearNumber, monthNumber,0); 
    var lastSaturdayInGrid = new Date(monthEnd); 
    lastSaturdayInGrid.setDate(monthEnd.getDate() + (6 - monthEnd.getDay())); 

    var cal = CalendarApp.getCalendarById(calendarID); 

    var gridStrings = []; 
    var i=0; 
    for(var indexDate = new Date(firstSundayInGrid);indexDate <= lastSaturdayInGrid;indexDate.setDate(indexDate.getDate()+1)){ 
    if(indexDate.getDate() == 1){ 
     gridStrings[i] = "<strong>" + months[indexDate.getMonth()].concat(" ", indexDate.getDate().toString()) + "</strong><br/>"; 
    } else { 
     gridStrings[i] = indexDate.getDate().toString() + "<br/>"; 
    } 
    var calEvents = cal.getEventsForDay(indexDate); 
    for(e in calEvents){ 
     if(calEvents[e].isAllDayEvent()){ 
     gridStrings[i] = gridStrings[i].concat(calEvents[e].getTitle(), '<br/>'); 
     } else if(calEvents[e].getStartTime() < indexDate){ 
     gridStrings[i] = gridStrings[i].concat(calEvents[e].getTitle(), '<br/>'); 
     } else { 
     gridStrings[i] = gridStrings[i].concat(friendlyTimeString(calEvents[e].getStartTime()), ' - ', calEvents[e].getTitle(), '<br/>'); 
     } 
    } 
    i++; 
    } 

    var calGrid = HtmlService.createTemplateFromFile("CalendarTemplate"); 
    calGrid.CalName = calName; 
    calGrid.CalDate = calDate; 
    var newFuture; 
    if(future>1){ 
    newFuture = future - 1; 
    calGrid.PrevMonthURL = "?future=" + newFuture; 
    calGrid.PrevMonth = months[prevMonthNumber-1].concat(" ", prevYearNumber); 
    } 
    if(future==1){ 
    calGrid.PrevMonthURL = ""; 
    calGrid.PrevMonth = months[prevMonthNumber-1].concat(" ", prevYearNumber); 
    } 
    newFuture = future + 1; 
    calGrid.NextMonthURL = "?future=" + newFuture; 
    calGrid.NextMonth = months[nextMonthNumber-1].concat(" ", nextYearNumber); 

    calGrid.Sun0 = gridStrings[0]; 
    calGrid.Mon0 = gridStrings[1]; 
    calGrid.Tue0 = gridStrings[2]; 
    calGrid.Wed0 = gridStrings[3]; 
    calGrid.Thu0 = gridStrings[4]; 
    calGrid.Fri0 = gridStrings[5]; 
    calGrid.Sat0 = gridStrings[6]; 

    calGrid.Sun1 = gridStrings[7]; 
    calGrid.Mon1 = gridStrings[8]; 
    calGrid.Tue1 = gridStrings[9]; 
    calGrid.Wed1 = gridStrings[10]; 
    calGrid.Thu1 = gridStrings[11]; 
    calGrid.Fri1 = gridStrings[12]; 
    calGrid.Sat1 = gridStrings[13]; 

    calGrid.Sun2 = gridStrings[14]; 
    calGrid.Mon2 = gridStrings[15]; 
    calGrid.Tue2 = gridStrings[16]; 
    calGrid.Wed2 = gridStrings[17]; 
    calGrid.Thu2 = gridStrings[18]; 
    calGrid.Fri2 = gridStrings[19]; 
    calGrid.Sat2 = gridStrings[20]; 

    calGrid.Sun3 = gridStrings[21]; 
    calGrid.Mon3 = gridStrings[22]; 
    calGrid.Tue3 = gridStrings[23]; 
    calGrid.Wed3 = gridStrings[24]; 
    calGrid.Thu3 = gridStrings[25]; 
    calGrid.Fri3 = gridStrings[26]; 
    calGrid.Sat3 = gridStrings[27]; 

    if(gridStrings[28]){ 
     hasFourthRow=true; 
     calGrid.Sun4 = gridStrings[28]; 
     calGrid.Mon4 = gridStrings[29]; 
     calGrid.Tue4 = gridStrings[30]; 
     calGrid.Wed4 = gridStrings[31]; 
     calGrid.Thu4 = gridStrings[32]; 
     calGrid.Fri4 = gridStrings[33]; 
     calGrid.Sat4 = gridStrings[34]; 
    } 

    if(gridStrings[35]){ 
     hasFifthRow=true; 
     calGrid.Sun5 = gridStrings[35]; 
     calGrid.Mon5 = gridStrings[36]; 
     calGrid.Tue5 = gridStrings[37]; 
     calGrid.Wed5 = gridStrings[38]; 
     calGrid.Thu5 = gridStrings[39]; 
     calGrid.Fri5 = gridStrings[40]; 
     calGrid.Sat5 = gridStrings[41]; 
    } 

    calGrid.datePrinted = d.toDateString(); 

    return calGrid.evaluate(); 
    } 

    function fourthRow() { 
    return hasFourthRow; 
    } 

    function fifthRow() { 
    return hasFifthRow; 
    } 

    function showPreviousMonth(){ 
    return hasPreviousMonth; 
    } 


    function friendlyTimeString(time){ 
    var hours = time.getHours(); 
    var minutes = time.getMinutes(); 
    var minutesString = ""; 
    if(minutes < 10){ 
     minutesString = "0" + minutes.toString(); 
    } else { 
     minutesString = minutes.toString(); 
    } 
    var dayPart = "AM"; 
    if(hours>=12){ 
     dayPart = "PM"; 
     hours -= 12; 
    } 
    if(hours == 0){ 
     hours = 12; 
    } 
    return hours.toString() + ":" + minutesString + " " + dayPart; 

而对于模板中的HTML：

<!DOCTYPE html> 
 
<style> 
 
table, th, td { 
 
    border: 1px solid black; 
 
    border-collapse: collapse; 
 
} 
 

 
@media print { .noprint { display: none; } } 
 

 
tfoot { 
 
    font-size: small; 
 
} 
 

 
table { 
 
    width: 100%; 
 
    height: 100%; 
 
} 
 
    
 
th, td { 
 
    padding: 5px; 
 
    vertical-align: top; 
 
    width: 14%; 
 
} 
 

 
h2 { 
 
    text-align: center; 
 
} 
 

 
body { 
 
    margin: 1; 
 
    padding: 1; 
 
} 
 

 
.cal{ 
 
    min-height: 90px; 
 
} 
 

 
.container { 
 
    position: relative; 
 
    width: 100%; 
 
} 
 

 
.right { 
 
    position: absolute; 
 
    right: 0px; 
 
    width: 50px; 
 
} 
 

 
.left { 
 
    position: absolute; 
 
    left: 0px; 
 
    width: 50px; 
 
} 
 
</style> 
 
<div> 
 
<div class="container"> 
 
    <img class="left" src=""> 
 

 
<img class="right" src=""> 
 
<h2><?=CalName?><br/> 
 
     <?=CalDate?> 
 
    </h2> 
 
</div> 
 
<table> 
 
<tr> 
 
    <th>Sun</th> 
 
    <th>Mon</th> 
 
    <th>Tue</th> 
 
    <th>Wed</th> 
 
    <th>Thu</th> 
 
    <th>Fri</th> 
 
    <th>Sat</th> 
 
</tr> 
 
<tr> 
 
    <td><div class="cal"><?!=Sun0?></div></td> 
 
    <td><?!=Mon0?></td> 
 
    <td><?!=Tue0?></td> 
 
    <td><?!=Wed0?></td> 
 
    <td><?!=Thu0?></td> 
 
    <td><?!=Fri0?></td> 
 
    <td><?!=Sat0?></td> 
 
</tr> 
 
<tr> 
 
    <td><div class="cal"><?!=Sun1?></div></td> 
 
    <td><?!=Mon1?></td> 
 
    <td><?!=Tue1?></td> 
 
    <td><?!=Wed1?></td> 
 
    <td><?!=Thu1?></td> 
 
    <td><?!=Fri1?></td> 
 
    <td><?!=Sat1?></td> 
 
</tr> 
 
<tr> 
 
    <td><div class="cal"><?!=Sun2?></div></td> 
 
    <td><?!=Mon2?></td> 
 
    <td><?!=Tue2?></td> 
 
    <td><?!=Wed2?></td> 
 
    <td><?!=Thu2?></td> 
 
    <td><?!=Fri2?></td> 
 
    <td><?!=Sat2?></td> 
 
</tr> 
 
<tr> 
 
    <td><div class="cal"><?!=Sun3?></div></td> 
 
    <td><?!=Mon3?></td> 
 
    <td><?!=Tue3?></td> 
 
    <td><?!=Wed3?></td> 
 
    <td><?!=Thu3?></td> 
 
    <td><?!=Fri3?></td> 
 
    <td><?!=Sat3?></td> 
 
</tr> 
 
<? if(fourthRow()){?> 
 
    <tr> 
 
     <td><div class="cal"><?!=Sun4?></div></td> 
 
     <td><?!=Mon4?></td> 
 
     <td><?!=Tue4?></td> 
 
     <td><?!=Wed4?></td> 
 
     <td><?!=Thu4?></td> 
 
     <td><?!=Fri4?></td> 
 
     <td><?!=Sat4?></td> 
 
    </tr> 
 
<? } ?> 
 
<? if(fifthRow()){?> 
 
    <tr> 
 
     <td><div class="cal"><?!=Sun5?></div></td> 
 
     <td><?!=Mon5?></td> 
 
     <td><?!=Tue5?></td> 
 
     <td><?!=Wed5?></td> 
 
     <td><?!=Thu5?></td> 
 
     <td><?!=Fri5?></td> 
 
     <td><?!=Sat5?></td> 
 
    </tr> 
 
<? } ?> 
 
<tfoot> 
 
    <tr><td colspan="7">This calendar is accurate as of <?= datePrinted ?>.</td></tr> 
 
</tfoot> 
 
</table> 
 
</div> 
 
<div class="noprint"> 
 
    <table> 
 
     <tr> 
 
     <td> 
 
      <? if(showPreviousMonth()){?> 
 
       <a href="url to your script when you publish it<?!=PrevMonthURL?>" target="_new"><?!=PrevMonth?></a> 
 
      <? } ?> 
 
     </td> 
 
     <td style="text-align: right"> 
 
      <a href="url to your script when you publish it<?!=NextMonthURL?>" target="_new"><?!=NextMonth?></a> 
 
     </td> 
 
     </tr> 
 
    </table> 
 
</div>