This is a sample script for managing the texts on Google Slides using Google Apps Script. Recently, I got the request like this. I published this here, because I thought that this might be also useful for other users.
In this demonstration, the text of {{baz}} on Google Slides are searched and replaced to other text, and also, the text style is changed.
| library(ggplot2) | |
| library(dplyr) | |
| library(lubridate) | |
| library(ical) | |
| # For a screencast demo on creating a calendar and exporting it to .ics file format | |
| # see this video: https://youtu.be/vLlR4lBWAoc | |
| # Locate your .ics calendar file on your computer and change what's in quotation marks | |
| calendar_data <- "192.ics" %>% |
This is a sample script for summarizing Slides as thumbnails. For example, it supposes a Slides including 15 pages. When this script is run, it summarizes 6 pages to one page as images. I created this because there are no methods for directly achieving this. This is useful for myself. If this is also useful for you, I'm glad.
The flow of this workaround is as follows.
| Sub addCustomSlideNumber() | |
| On Error Resume Next | |
| Dim PPSlide As Slide | |
| For Each PPSlide In ActivePresentation.Slides | |
| PPSlide.Shapes("customNumberBox").Delete | |
| Next | |
| Dim x As Integer | |
| Dim slideToNumber As Slide |
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <script> | |
| var data | |
| var formId = 'form' | |
| function drawForm() { | |
| if (!data) return | |
| var outputEl = document.getElementById(formId); |
| require 'open-uri' | |
| require 'nokogiri' | |
| require 'pry-byebug' | |
| BASE_URL = "https://www.imdb.com" | |
| def fetch_urls | |
| url = "https://www.imdb.com/chart/top" | |
| html_file = open(url).read # string | |
| html_doc = Nokogiri::HTML(html_file) #Nokogiri::HTML::Document |
| /* Put Google Ads Data in Google Spreadsheet | |
| * ----------------------------------------- | |
| * | |
| * Script by Optmyzr.com | |
| * | |
| * v3 (20190702) | |
| * - updated to API v201809 | |
| * v2 (20180810) | |
| * - updated to newer reporting version in ads API | |
| * |
| /* | |
| * script to export data of the named sheet as an individual csv files | |
| * sheet downloaded to Google Drive and then downloaded as a CSV file | |
| * file named according to the name of the sheet | |
| * original author: Michael Derazon (https://gist.github.com/mderazon/9655893) | |
| */ | |
| function onOpen() { | |
| var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
| var csvMenuEntries = [{name: "Download Primary Time File", functionName: "saveAsCSV"}]; |
| id | dataset | x | y | |
|---|---|---|---|---|
| 0 | I | 10.0 | 8.04 | |
| 1 | I | 8.0 | 6.95 | |
| 2 | I | 13.0 | 7.58 | |
| 3 | I | 9.0 | 8.81 | |
| 4 | I | 11.0 | 8.33 | |
| 5 | I | 14.0 | 9.96 | |
| 6 | I | 6.0 | 7.24 | |
| 7 | I | 4.0 | 4.26 | |
| 8 | I | 12.0 | 10.84 |
| Afghanistan | |
| Albania | |
| Algeria | |
| Andorra | |
| Angola | |
| Antigua & Deps | |
| Argentina | |
| Armenia | |
| Australia | |
| Austria |
