コード.gs
function myFunction() {
var url = "https://docs.google.com/document/d/ID/edit";
var doc = DocumentApp.openByUrl(url);
doc.editAsText().setForegroundColor('#d3d3d3');
}
|
コード.gs
function addFileDescriptionsToDocument() {
const fileObjArray = getFileDescriptionsInFolder();
const sortedArray = fileObjArray.sort(asc);
Logger.log(sortedArray);
const descriptionsArray = createDescriptionArray(sortedArray);
const str = descriptionsArray.join("\n");
addTextToDocument(str);
}
function getFileDescriptionsInFolder() {
const folderId = "FOLDER_ID";
const folder = DriveApp.getFolderById(folderId);
const files = folder.getFiles();
let array = [];
while(files.hasNext()) {
const file = files.next();
const obj = {};
obj["name"] = file.getName();
obj["url"] = file.getUrl();
obj["description"] = file.getDescription();
array.push(obj);
}
return array;
}
function asc(a, b){
const targetA = a.name;
const targetB = b.name;
if(targetA > targetB){
return 1;
}else if(targetA < targetB ){
return -1;
}else{
return 0;
}
}
function createDescriptionArray(sortedArray) {
const array = [];
const target = "description";
for(let i = 0; i < sortedArray.length; i++){
const description = sortedArray[i][target];
array.push(description);
}
return array;
}
function addTextToDocument(description) {
const url = "DOCUMENT_URL";
const doc = DocumentApp.openByUrl(url);
const body = doc.getBody();
body.appendParagraph(description);
}
|
コード.gs
const docUrl = "https://docs.google.com/document/d/ID/edit";
const FOLDER_ID = "Google Drive FOLDER ID";
function insertImages() {
const doc = DocumentApp.openByUrl(docUrl);
const docBody = doc.getBody();
const docWidth = docBody.getPageWidth();
const docHeight = docBody.getPageHeight();
const fileIds = getFileIds();
for(let i = 0; i < fileIds.length; i++) {
const image = DriveApp.getFileById(fileIds[i]);
docBody.getParagraphs()[0].insertInlineImage(0, image)
.setWidth(docWidth*1.2)
.setHeight(docHeight*1.2);
}
}
function getFileIds() {
let fileIds = [];
const folder = DriveApp.getFolderById(FOLDER_ID);
const files = folder.getFiles();
while(files.hasNext()) {
const file = files.next();
const id = file.getId();
fileIds.push(id);
}
return fileIds;
}
|
コード.gs
const docUrl = "https://docs.google.com/document/d/ID/edit";
const imageUrl = "https://drive.google.com/file/d/ID/view?usp=sharing";
const imageId = imageUrl.split("/d/")[1].split("/view?")[0]
const image = DriveApp.getFileById(imageId);
function myFunction() {
const doc = DocumentApp.openByUrl(docUrl);
const docBody = doc.getBody();
const docWidth = docBody.getPageWidth();
const docHeight = docBody.getPageHeight();
docBody.getParagraphs()[0].insertInlineImage(0, image).setWidth(docWidth).setHeight(docHeight);
}
|
コード.gs
function myFunction() {
var doc = DocumentApp.getActiveDocument()
var body = doc.getBody();
body.replaceText("hello", "Hello");
}
|
意訳この機能がやること ドキュメントを取得して Bodyを取得して hello を Hello に置換する |
The Body may contain ListItem, Paragraph, Table, and TableOfContents elements. For more information on document structure, see the guide to extending Google Docs.
コード.gs
function doGet(e) {
return HtmlService.createHtmlOutputFromFile("index");
}
var docUrl = 'https://docs.google.com/document/d/ID/edit';
var docId = docUrl.split('/d/')[1].split('/')[0];
function getDocText() {
var doc = DocumentApp.openById(docId);
var body = doc.getBody().getText();
return body;
}
function updateDocText(text) {
var doc = DocumentApp.openById(docId);
var body = doc.getBody();
body.setText(text);
}
|
index.html
<!DOCTYPE html>
<html>
<body>
<textarea id="ta" style="width: 20vw;height:90vh;"></textarea>
<script>
getData();
/************************************
elem(id)
************************************/
function elem(id) {
return document.getElementById(id);
}
/************************************
getData()
************************************/
function getData() {
google.script.run
.withFailureHandler(onFailure)
.withSuccessHandler(gotDocText)
.getDocText();
}
/************************************
gotDocText(result)
************************************/
function gotDocText(result) {
elem('ta').value = result;
}
/************************************
updateData()
************************************/
function updateData() {
var text = elem('ta').value;
google.script.run
.withFailureHandler(onFailure)
.updateDocText(text);
}
/************************************
onFailure(e)
************************************/
function onFailure(e) {
alert([e.message, e.stack]);
}
/************************************
timeout
2秒後にupdateData()を実行する
************************************/
var timeOut;
var milisec = 2000;
document.addEventListener("load", timeoutStart);
document.addEventListener("click", resetTimeout);
document.addEventListener("mousemove", resetTimeout);
document.addEventListener("keypress", resetTimeout);
function timeoutStart(){
timeOut = setTimeout('updateData()', milisec);
}
function resetTimeout() {
clearTimeout(timeOut);
timeoutStart();
}
</script>
</body>
</html>
|
コード.gs
function doGet(e) {
return HtmlService.createHtmlOutputFromFile("index");
}
function getDocText() {
var url = 'https://docs.google.com/document/d/1MqQIPvp8NjFrCI8BOOUOMFWh1yXjuIebP1nx9iDoSCU/edit';
var id = url.split('/d/')[1].split('/')[0];
var doc = DocumentApp.openById(id);
var body = doc.getBody().getText();
return body;
}
|
index.html
<!DOCTYPE html>
<html>
<body>
<textarea id="ta" style="width: 20vw;height:90vh;"></textarea>
<script>
getData();
/************************************
elem(id)
************************************/
function elem(id) {
return document.getElementById(id);
}
/************************************
getData()
************************************/
function getData() {
google.script.run
.withFailureHandler(onFailure)
.withSuccessHandler(gotDocText)
.getDocText();
}
/************************************
gotDocText(result)
************************************/
function gotDocText(result) {
elem('ta').value = result;
}
/************************************
onFailure(e)
************************************/
function onFailure(e) {
alert([e.message, e.stack]);
}
</script>
</body>
</html>
|
コード.gs
function getDocTexts() {
var folderId = 'ID';
var folder = DriveApp.getFolderById(folderId);
var ids = getFileIds(folderId);
var textArray = [];
for(var i = 0; i < ids.length; i++) {
var text = getDocText(ids[i]);
textArray.push(text);
}
Logger.log(textArray);
}
function getDocText(id) {
var doc = DocumentApp.openById(id);
var text = doc.getBody().getText();
return text;
}
function getFileIds(folderId) {
var ids = [];
var folder = DriveApp.getFolderById(folderId);
var contents = folder.getFiles();
while(contents.hasNext()) {
var file = contents.next();
var id = file.getId();
ids.push(id);
}
return ids;
}
|
コード.gs
function addText() {
var url = "https://docs.google.com/document/d/ID/edit";
var doc = DocumentApp.openByUrl(url);
var body = doc.getBody();
body.appendParagraph("hi" + "\n" + "hey");
}
|
コード.gs
function changeFontSize() {
var url = "https://docs.google.com/document/d/ID/edit";
var doc = DocumentApp.openByUrl(url);
doc.editAsText().setFontSize(14);
}
|
コード.gs
function createDocFromText() {
var url = "https://drive.google.com/file/d/ID/view?usp=sharing";//テキストファイルのURL
var id = url.split("/d/")[1].split("/")[0];
var file = DriveApp.getFileById(id);
var name = file.getName();
var blob = file.getBlob();
var file = {
title: name,
mimeType: 'application/vnd.google-apps.document'
};
file = Drive.Files.insert(file, blob);
var id = file.id;
var docUrl = "https://docs.google.com/document/d/" + id + "/edit";
Logger.log(docUrl);
}
|
コード.gs
function createNewDoc() {
var doc = DocumentApp.create('Document Name');
var body = doc.getBody();
body.setText("テキスト1\nテキスト2");
var url = doc.getUrl();
Logger.log(url);
}
|
意訳この機能がやること 新規ドキュメントを作成する bodyを取得する テキストを入力する urlを取得する ログに出す |
コード.gs
function createNewDoc() {
var doc = DocumentApp.create('Document Name');
var url = doc.getUrl();
Logger.log(url);
}
|
意訳この機能がやること 新規ドキュメントを作成する（名前を決める） 作成したドキュメントのurlを取得して ログに出す |