Skip to content

Instantly share code, notes, and snippets.

Avatar

Kanshi TANAIKE tanaikech

View GitHub Profile
@tanaikech
tanaikech / submit.md
Created Oct 21, 2020
Creating Multiple Buttons on Google Spreadsheet using Google Apps Script
View submit.md

Creating Multiple Buttons on Google Spreadsheet using Google Apps Script

This is a sample script for creating the multiple buttons on Google Spreadsheet using Google Apps Script.

Recently, I have got several contacts about this. I thought that when this is published, it might be useful for other users. So I published this sample script.

Sample script

@tanaikech
tanaikech / submit.md
Last active Oct 21, 2020
Request of multipart/form-data with Simple Request Body using Google Apps Script
View submit.md

Request of multipart/form-data with Simple Request Body using Google Apps Script

This is a sample script of the request of multipart/form-data with a simple request body using Google Apps Script. I hope that the users will easy to use Class UrlFetchApp by this report.

This report is the updated post of "Multipart-POST Request Using Google Apps Script".

Description

I had already reported about this at this report. In that case, it was required to create a bit complicated request body to request multipart/form-data. Today, by a comment, I could notice the sample script of Class UrlFetchApp in the official document had been updated. By this, I thought that multipart/form-data

@tanaikech
tanaikech / submit.md
Created Oct 13, 2020
Retrieving All Values from All Sheets from URL of 2PACX- of Web Published Google Spreadsheet using Python
View submit.md

Retrieving All Values from All Sheets from URL of 2PACX- of Web Published Google Spreadsheet using Python

This is a sample script for retrieving all values from all sheets from URL of 2PACX- of Web Published Google Spreadsheet using Python.

In this post, it supposes that the Google Spreadsheet has already been published for Web. Ref

Flow

The flow of this method is as follows.

@tanaikech
tanaikech / submit.md
Last active Oct 15, 2020
Inserting Text on Image using Google Apps Script
View submit.md
@tanaikech
tanaikech / submit.md
Last active Oct 13, 2020
Retrieving All Values from All Sheets from URL of 2PACX- of Web Published Google Spreadsheet using Node.js
View submit.md

Retrieving All Values from All Sheets from URL of 2PACX- of Web Published Google Spreadsheet using Node.js

This is a sample script for retrieving all values from all sheets from URL of 2PACX- of Web Published Google Spreadsheet using Node.js.

In this post, it supposes that the Google Spreadsheet has already been published for Web. Ref

Before you use this sample script, please install SheetJS js-xlsx.

Flow

@tanaikech
tanaikech / submit.md
Last active Oct 13, 2020
Retrieving All Values from All Sheets from URL of 2PACX- of Web Published Google Spreadsheet using Google Apps Script and Javascript
View submit.md

Retrieving All Values from All Sheets from URL of 2PACX- of Web Published Google Spreadsheet using Google Apps Script and Javascript

This is a sample script for retrieving all values from all sheets from URL of 2PACX- of Web Published Google Spreadsheet using Google Apps Script and Javascript.

In this post, it supposes that the Google Spreadsheet has already been published for Web. Ref

Flow

The flow of this method is as follows.

@tanaikech
tanaikech / submit.md
Last active Oct 15, 2020
Sorting Cells on Google Spreadsheet with Background colors using Google Apps Script
View submit.md

Sorting Cells on Google Spreadsheet with Background colors using Google Apps Script

This is a sample script for sorting the cells on Google Spreadsheet with the background colors using Google Apps Script.

Unfortunately, in the current stage, it seems that sort(sortSpecObj) of Class Range cannot directly sort by the background colors of cells. But when Sheets API is used, this goal can be achieved. Here, "SortRangeRequest" of the method of "spreadsheets.batchUpdate" in Sheets API is used.

Flow

@tanaikech
tanaikech / submit.md
Created Oct 7, 2020
Statistical Analysis of Duplicated Questions for google-apps-script tag in Stackoverflow
View submit.md

Statistical Analysis of Duplicated Questions for google-apps-script tag in Stackoverflow

Introduction

At Stackoverflow, a lot of people post the questions and answer to the questions every day. By this, there are a lot of important information in Stackoverflow. I have already reported "Trend of google-apps-script Tag on Stackoverflow" using the data retrieved from Stackoverflow. Ref. 1 It is found that the important statistical result can be obtained by analyzing the data on Stackoverflow. In this report, I would like to introduce the statistical analysis of duplicated questions for the google-apps-script tag in Stackoverflow. When the duplicated question is analyzed, it is considered that the important issues for users can be known. As the result, it was found that there are the trend that the duplicated questions related to Javascript, Google Spreadsheet , the process cost and the cooperation with HTML and Javascript are posted.

Experimental procedure

When the history of Stackov

@tanaikech
tanaikech / submit.md
Created Oct 6, 2020
Setting Alternate Background Colors for Rows in Google Spreadsheet using Google Apps Script
View submit.md

Setting Alternate Background Colors for Rows in Google Spreadsheet using Google Apps Script

This is a sample script for setting alternate background colors for rows in Google Spreadsheet using Google Apps Script.

It has already been known when the conditional formatting rule and custom function are used, this can be simply achieved. Ref In this report, I would like to introduce the method for using Google Apps Script.

Sample script

@tanaikech
tanaikech / submit.md
Last active Oct 15, 2020
Google Apps Script: Running Specific Function When Specific Sheet is Edited on Google Spreadsheet
View submit.md

Google Apps Script: Running Specific Function When Specific Sheet is Edited on Google Spreadsheet

This is a sample Google Apps Script for running the specific function when the specific sheet is edited.

Sample script

Please copy and paste the following script to the container-bound script of Spreadsheet and set sheets object.

// When the cells are edited, this function is run by the fire of event trigger.
You can’t perform that action at this time.