应用程序脚本:如何查看Google表格的PDF功能后保存到Google Drive? [英] App Script: How to view PDF of Google Sheet after function to save to Google Drive?
本文介绍了应用程序脚本:如何查看Google表格的PDF功能后保存到Google Drive?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
需要用户查看他们刚刚通过以下功能保存到Google云端硬盘的PDF版本的Google表格。如何在此代码中添加查看PDF功能?在线建议并不完全。
Needing users to view PDF version of the Google Sheet they have just saved to Google Drive via the function below. How do I add in a view PDF function within this code? Online suggestions are not working entirely.
function checkSheet() {
var sheetName = "POTemplate";
var folderID = "Eric";
var sourceSpreadsheet = SpreadsheetApp.getActive();
var sourceSheet = sourceSpreadsheet.getSheetByName(sheetName);
var poNo = sourceSheet.getRange("b2").getValue();
var pdfName = "Sample PO Hi Eric - Happy Valentine's" + poNo;
var folder = DriveApp.getFoldersByName(folderID);
var destSpreadsheet = SpreadsheetApp.open(DriveApp.getFileById(sourceSpreadsheet.getId()).makeCopy(folder));
var sheets = destSpreadsheet.getSheets();
for (i = 0; i < sheets.length; i++) {
if (sheets[i].getSheetName() != sheetName){
destSpreadsheet.deleteSheet(sheets[i])}};
var theBlob =
destSpreadsheet.getBlob().getAs('application/pdf').setName(pdfName);
var newFile = folder.next().createFile(theBlob);
DriveApp.getFileById(destSpreadsheet.getId()).setTrashed(true);
}
推荐答案
可以使用 file.getUrl()
获得新文件的链接,并在对话框中显示链接,如
To add a view function you can get the link to the new file using file.getUrl()
and present the link to the user in a dialog box like so
var strUrl = newFile.getUrl()
var html = HtmlService.createTemplateFromFile("NewTab")
html.strUrl = strUrl
SpreadsheetApp.getUi().showModelessDialog(html.evaluate(), "Pdf Link")
You Html文件 NewTab
会被编码为像这样
You Html file NewTab
will be coded like so
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<a href ="<?!= strUrl ?>"> Link </a> to your PDF File
</body>
<script>
var evLink = document.getElementsByTagName('a')[0]
//evLink.click(); //If you try to programmatically activate link,
// pop-up blocker stops the link from opening.
</script>
</html>
参考:
file.getUrl()
对话框
查询打开新标签页/链接
这篇关于应用程序脚本:如何查看Google表格的PDF功能后保存到Google Drive?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文