Here, I would like to report the process costs for searching values in Spreadsheet using Google Apps Script (GAS). When the values are searched in Google Spreadsheet, the following 3 patterns can be considered. Ref
Retrieve all values using getValues, and the values are searched from the retrieved array.
Use TextFinder.
Use Query language.
TextFinder is a relatively new addition to Google Apps Script with was released on April 5, 2019. TextFinder is part of the Spreadsheet Service and provides methods for finding or replacing text within a range, sheet or spreadsheet. There have been some reports on Stack Overflow that the TextFinder methods can be relatively slow to execute compared to using native JavaScript techniques. This post by Tanaike explores the process time of TextFinder against other techniques. Click through to the source for the results and code for running the experiment.
This is a sample script for converting a range in Google Spreadsheet as an image data using Google Apps Script. Unfortunately, there are no methods for directly converting the range in Google Spreadsheet as an image data in the built-in functions. So in this case, as a workaround, Charts Service is used.
This is a sample script for decoding a QR code put in Google Slides using Google Apps Script. In this case, Javascript is used at the opened dialog. And Canvas API and jsQR are used.
This is a nice example of how you can easily drop in existing JavaScript libraries into your Apps Script project by using a HTML dialog. The post also has some nice tricks for handing image data, in particular, from getDataFromQRCode() the image data is passed into the HtmlService:
const html = HtmlService.createTemplateFromFile("index"); html.image = JSON.stringify(blob.getBytes()); // adding image data SlidesApp.getUi().showModalDialog(html.evaluate(), "sample");
This is a sample script for cropping images in the Google Slides using Google Apps Script.
Useful snippet from Tanaike which shows how you can crop images in Google Slides by using the replace(blobSource, crop) method. The post also highlights a limitation with the image manipulation methods available around crop centering.
This is a sample script for converting the SVG image data to PNG image data using Google Apps Script. Unfortunately, in the current stage, there are no methods for directly converting the SVG to PNG in Google Drive service. But it can be achieved by Drive API
Nice trick to get .svg files stored in Google Drive in a raster format.
This is a sample script for disabling the buttons put on Google Spreadsheet using Google Apps Script. When a script is run by clicking a button on Google Spreadsheet, there is the case that you don’t want to make users run the script in duplicate.
Nice little Google Apps Script snippet that prevents a function assigned to an image or drawing in Google Sheets from being run simultaneously. The clever bit is the code uses Google Apps Script to modify the function assigned to the button/image when it is running.
EncodeApp is a GAS library for retrieving the encoding set (charset) and doing URL encode with the specific encoding set using Google Apps Script (GAS). – tanaikech/EncodeApp
An interesting analysis prepared by Kanshi Tanaike of the ‘google-apps-script’ tag usage on Stackoverflow which shows that since 2016 there has been an increase in questions related to the tag with a bigger increase in 2019. Clicking through to the source post you’ll also see the data shows that new users asking questions about Google Apps Script is growing quicker than those who are answering them.
