tanaike

The Thinker

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

Gists Updated on January 25, 2024 Overview: This is a report for challenging exporting the selected cells on Spreadsheet as an image using Google Apps Script and Javascript. Description: This report is based on this question by Max Makhrov. When I saw this question, I remembered that there are many questions for asking this in Stackoverflow. And, I thought that when this is achieved, it will be useful for the owner of this question and a lot of users.

Javascript library - CropImageByBorder_js

Javascript Library for Cropping Image by Border Overview This is a Javascript library for cropping images by the border. Description When an image is used, there is a case where I wanted to simply crop the image by a script. In this Javascript library, the image is cropped by a border. The sample situation is as follows. In this sample situation, a red rectangle is enclosed by a border (1 pixel) with “#000000”.

Clearing Discrete Cell Values on Multiple Sheets using Google Apps Script

Gists 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.

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

Gists 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"); const fs = require("fs").promises; async function sample() { const filepath = "./###"; // Please set the filename and file path of the upload file.

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

Gists 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.