tanaike

ggsrun was updated to v.1.2.1 Configuration file (ggsrun.cfg) became to be able to be read using the environment variable. You can check this at here.

This sample script embeds a chart to a cell using custom function on Spreadsheet. I think that this method is one of various ideas. Problem When you want to create a chart and embed it to a cell using custom functions, you notice that insertChart() cannot be used. There are some limitations for using custom functions. But insertChart() creates floating charts. So in order to embed a chart to a cell, the function =IMAGE() is suitable for this situation.

This sample script converts from Microsoft Docx File on Google Drive to Google Spreadsheet, and converts to HTML file. Drive APIs v2 and v3 are used for this. Please set as follows. Drive API v2 Drive API v3 “Drive API v2” can be used at Google Apps Script by enabling Drive API of Advanced Google services and of Google API Console. How to use it is as follows.

Decoding JSON by Golang func main() { data := `{ "A_key1": { "B_key1": { "C_key": "value" } }, "A_key2": { "B_key2": { "C_key": "value" } }, "A_key3": { "B_key3": { "C_key": "value" } }, "A_key4": { "B_key4": { "C_key": "value" } }, "A_key5": { "B_key5": { "C_key": "value" } } }` var p interface{} json.NewDecoder(strings.NewReader(data)).Decode(&p) fmt.Println(p) } Go Playground

Dynamically Creating JSON by Golang obj := map[string]interface{}{} obj["hoge"] = "huga" fmt.Println(obj) Go Playground