tanaike

The Thinker

GAS Library - UnzipGs

Overview This is a GAS library for unzipping a Zip file protected by a password using Google Apps Script. Description Recently, I had a situation that it is required to unzip a Zip file protected with the password. But unfortunately, in the current stage, the method of Utilities.unzip() cannot unzip such protected files. So when I had been looking for the other workarounds, I found zlib.js. Especially, it’s unzip.min.js. This is created for Javascript.

Resumable Uploading Files to Google Drive using Golang

Gists This is a sample script for the resumable upload of Files to Google Drive using Golang. This script uses the library of google-api-go-client. About the installation of google-api-go-client, please check the Quickstart for golang at the official site. Sample script: package main import ( "context" "encoding/json" "fmt" "io/ioutil" "log" "net/http" "os" drive "google.golang.org/api/drive/v3" "golang.org/x/oauth2" "golang.org/x/oauth2/google" "golang.org/x/oauth2/jwt" ) // ServiceAccount : Use Service account func ServiceAccount(credentialFile string) *http.Client { b, err := ioutil.

Creating a Table to Google Document by Retrieving Values from Google Spreadsheet for Python

Gists This is a sample script for creating a table to Google Document by retrieving values from Google Spreadsheet for Python. Before you use this script, please install python library of gdoctableapppy. $ pip install gdoctableapppy Sample script: This sample script uses Service Account. In this sample script, the values are retrieved from Sheet1!A1:C5 of Spreadsheet, and new table is created to the Document using the values. from google.oauth2 import service_account from gdoctableapppy import gdoctableapp from googleapiclient.

Creating a Table to Google Document by Retrieving Values from Google Spreadsheet for Node.js

Gists This is a sample script for creating a table to Google Document by retrieving values from Google Spreadsheet for Node.js. Before you use this script, please install Node.js module of node-gdoctableapp. $ npm install --save-dev gdoctableapp or $ npm install --global gdoctableapp Sample script: This sample script uses Service Account. In this sample script, the values are retrieved from Sheet1!A1:C5 of Spreadsheet, and new table is created to the Document using the values.

Creating a Table to Google Document by Retrieving Values from Google Spreadsheet for Golang

Gists This is a sample script for creating a table to Google Document by retrieving values from Google Spreadsheet for Golang. Before you use this script, please install go library of go-gdoctableapp. $ go get -v -u github.com/tanaikech/go-gdoctableapp Sample script: This sample script uses Service Account. In this sample script, the values are retrieved from Sheet1!A1:C5 of Spreadsheet, and new table is created to the Document using the values. package main import ( "encoding/json" "fmt" "io/ioutil" "log" "net/http" "os" gdoctableapp "github.