Skip to content

Instantly share code, notes, and snippets.

Avatar

Kanshi TANAIKE tanaikech

View GitHub Profile
@tanaikech
tanaikech / submit.md
Created Aug 10, 2022
Report: Challenging Exporting Selected Cells on Spreadsheet as Image using Google Apps Script and Javascript
View submit.md

Report: Challenging Exporting Selected Cells on Spreadsheet as Image using Google Apps Script and Javascript

Overview:

This is a report for challenging exporting the selected cells on Spreadsheet as an image using Google Apps Script and Javascript.

Description:

@tanaikech
tanaikech / submit.md
Created Aug 8, 2022
Clearing Discrete Cell Values on Multiple Sheets using Google Apps Script
View submit.md

Clearing Discrete Cell Values on Multiple Sheets using Google Apps Script

This is a sample script for clearing the discrete cell values on multiple sheets using Google Apps Script.

There might be a case where you want to clear the values of the discrete cells in the multiple sheets using Google Apps Script. In this post, I would like to introduce the efficient script for achieving this.

Sample script 1

Please copy and paste the following script to the script editor of the Google Spreadsheet you want to use.

@tanaikech
tanaikech / submit.md
Last active Aug 8, 2022
Sample Script for Resumable Upload to Google Drive using Axios with Node.js
View submit.md

Sample Script for Resumable Upload to Google Drive using Axios with Node.js

This is a sample script for the resumable upload using Axios with Node.js.

Sample script

In this sample script, as a sample situation in order to explain the resumable upload, the file data is loaded from the local PC, and the data is uploaded to Google Drive with the resumable upload.

const axios = require("axios");
@tanaikech
tanaikech / submit.md
Created Aug 1, 2022
Creating User's Dashboard by Inputting Name and Password using Web Apps with Google Apps Script
View submit.md

Creating User's Dashboard by Inputting Name and Password using Web Apps with Google Apps Script

This is a sample script for creating the user's dashboard by inputting the user name and password using Web Apps with Google Apps Script. In this case, Google Spreadsheet is used as a database of the dashboard.

Usage

1. Create a Google Apps Script project.

In order to use Web Apps, please create a new Google Apps Script project. In this case, please create a new Spreadsheet and open the script editor of Spreadsheet.

@tanaikech
tanaikech / submit.md
Created Jul 30, 2022
Retrieving Names of Month and Day of Week using Google Apps Script
View submit.md

Retrieving Names of Month and Day of Week using Google Apps Script

This is a sample script for retrieving the names of month and day of week using Google Apps Script.

I think that you might have a case that you want to retrieve the names of month and day of week using Google Apps Script. This sample script retrieves them using a simple script.

Using Utilities.formatDate of Google Apps Script, the names of month and day of week can be retrieved using a simple script.

Sample script 1

@tanaikech
tanaikech / submit.md
Last active Jul 29, 2022
Checking Exchange Rate using GOOGLEFINANCE with Google Apps Script
View submit.md

Checking Exchange Rate using GOOGLEFINANCE with Google Apps Script

This is a sample script for checking the exchange rate using GOOGLEFINANCE with Google Apps Script.

Recently, I have published a report of "Report: Obtaining Values from GOOGLEFINANCE using Google Apps Script". Ref In this post, I would like to introduce a sample script for checking the exchange rate using Google Apps Script.

Sample script

@tanaikech
tanaikech / submit.md
Created Jul 27, 2022
Replacing Images on Google Document in Order using Google Apps Script
View submit.md

Replacing Images on Google Document in Order using Google Apps Script

This is a sample script for replacing images on Google Document in order using Google Apps Script.

Sample script

This sample script uses Drive API and Docs API. So, please enable Drive API and Docs API at Advanced Google services. Ref

@tanaikech
tanaikech / submit.md
Last active Jul 25, 2022
Report: Management of Images on Google Spreadsheet using Google Apps Script
View submit.md

Report: Management of Images on Google Spreadsheet using Google Apps Script

This is a report for management of images on Google Spreadsheet using Google Apps Script.

At October 30, 2018, Cass OverGridImage and the method of inserImage have been added to Spreadsheet Service. Ref At January 19, 2022, Class CellImageBuilder and Class CellImage have been added to Spreadsheet Service. Ref By these Classes and methods, the images got to be able to be managed on Google Spreadsheet. But, when the image is used to the various situations, there are the cases that it is required to ingenuity to manage the images. So, in this report, I would like to introduce the management of images on Google Spreadsheet using the sample scripts of Google Apps Script.

In this report, I would like to introduce the follwoing

@tanaikech
tanaikech / submit.md
Last active Aug 7, 2022
Report: Documentation Comments including JsDoc for Functions of Google Apps Script
View submit.md

Report: Documentation Comments including JsDoc for Functions of Google Apps Script

This is a report for the documentation comments for the functions of Google Apps Script.

When the documentation comments for functions of Google Apps Script are considered, you will think JsDoc. At Google Apps Script, a part of JsDoc can be used. But, in this report, I would like to introduce the documentation comments including JsDoc.

Sample situations

Sample 1

@tanaikech
tanaikech / submit.md
Last active Jul 14, 2022
Benchmark: Process cost for Parsing XML data using Google Apps Script
View submit.md

Benchmark: Process cost for Parsing XML data using Google Apps Script

Introduction

In order to retrieve the values from XML data, when XML data is parsed using Google Apps Script, there are several methods for parsing the data. Class XmlService, which is a built-in Class for managing XML data, might be the first way to come up with it. At Stackoverflow, it is posted questions that XML data is often parsed using Class XmlService. It is considered that Class XmlService is suitable for managing XML data.

But, when I have created applications using XML data with Google Apps Script before, I have felt that the process of Class XmlService might be high. So, in this report, the process cost for parsing XML data using Google Apps Script. As the result, it was found that after the V8 runtime had been released, the methods except for Class XmlService in order to parse XML data can be also used.

Experimental procedure