tanaike

The Thinker

Decrypting Salted Base64 of finance.yahoo.com using Google Apps Script

Gists This sample script decrypts the salted base64 data of finance.yahoo.com using Google Apps Script. Recently, it seems that the specification of the key for decrypting the data has been changed at the server side. So. in this post, this post is updated. About this specification, I checked this thread. Sample script function myFunction() { // Load crypto-js.min.js. const cdnjs = "https://cdnjs.cloudflare.com/ajax/libs/crypto-js/4.1.1/crypto-js.min.js"; eval(UrlFetchApp.fetch(cdnjs).getContentText()); // Retrieve HTML and retrieve salted base64.

Converting All Pages in PDF File to PNG Images using Google Apps Script

Gists This is a sample script for converting all pages in a PDF file to PNG images using Google Apps Script. I have already published “Merging Multiple PDF Files as a Single PDF File using Google Apps Script”. In this post, it was found that pdf-lib can be used with Google Apps Script. From this, in this post, I would like to propose a sample script for converting all pages in a PDF file to PNG images using Google Apps Script.

Merging Multiple PDF Files as a Single PDF File using Google Apps Script

Gists This is a sample script for merging multiple PDF files as a single PDF file using Google Apps Script. In this sample script, pdf-lib is used. In the current stage, it seems that this Javascript can be directly used with Google Apps Script. Sample script 1 As a sample situation, please put multiple PDF files in your Google Drive. This sample merges those PDF files as a single PDF file.

Transferring Owner of File to Other User using Google Apps Script

Gists This is a sample script for transferring the ownership of a file to another user using Google Apps Script. In the current stage, about the consumer account (gmail.com) the specification for transferring the ownership of a file has been changed as follows. Ref The current owner initiates an ownership transfer by creating or updating the prospective new owner’s file permission. The permission must include these settings: role=writer, type=user, and pendingOwner=true.

Retrieving Start and End of Month in Year using Google Apps Script and Javascript

Gists This is a sample script for retrieving the start and end of the month in a year using Google Apps Script and Javascript. Sample script function myFunction() { const year = 2023; // Please set year you expect. const res = [...Array(12)].map((_, i) => [0, 1].map((e) => new Date(year, i + e, 1 - e)) ); console.log(res); console.log(res.map(([a, b]) => [a.toDateString(), b.toDateString()])); } Testing https://jsfiddle.