
Programming macros with Google Sheets
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
ABOUT THE AUTHOR
Rémy Lentzner has been an IT trainer since 1985. Specialized in mastering office automation tools, he supports companies in the professional training of their employees. Self-taught, he has twenty computer books to his credit.
More details
Content
- Intro
- Chapter 1Recording a macro
- 1.1 Creating a macro
- 1.2 Performing and modifying a macro
- 1.2.1 A macro used to format a text
- 1.2.2 A macro to empty cells
- 1.2.3 A macro to filter
- 1.2.4 An object-oriented language
- 1.2.5 The program structure
- Chapter 2Fundamentals
- 2.1 How to write the code
- 2.2 Debugging the code
- 2.2.1 Inserting a breakpoint
- 2.2.2 Catching error with try and catch
- 2.3 The code history
- 2.4 The project
- 2.5 Training
- 2.5.1 Formatting text
- 2.5.2 Calculation
- 2.5.3 Linking a macro to a button
- 2.5.4 Date functions
- 2.5.5 Other date functions
- 2.5.6 Looping with FOR to copy formulas
- 2.5.7 Looping with WHILE to copy formulas
- 2.5.8 Operators
- 2.5.9 Testing with IF condition
- 2.5.10 Finding the last row
- 2.5.11 A new address list
- 2.6 Browser class with msgBox and inputBox
- 2.6.1 Browser.msgBox
- 2.6.2 Browser.inputBox
- 2.7 Opening a file in Google Drive
- 2.7.1 Opening a file by an Internet address
- 2.7.2 Opening a file by its identifier
- 2.7.3 Opening a file by its name
- 2.8 Downloading and Importing a CSV file
- 2.9 Adding a personalized menu
- 2.9.1 Searching a value in a data list
- 2.9.2 Deleting a record
- 2.9.3 Creating a new record
- 2.10 Managing variables
- 2.10.1 Simple variables
- 2.10.2 Passing parameters into a function
- 2.10.3 Returning values
- 2.10.4 Variables scope and global variables
- 2.11 Some control structures
- 2.11.1 for, while, do-while, for-in loops
- 2.11.2 Conditional operators if and switch
- Chapter 3Triggers
- 3.1 Running triggers
- 3.1.1 A trigger that empties cells
- 3.1.2 Modify a trigger
- 3.1.3 Different Triggers
- 3.1.4 Triggers and restrictions
- 3.1.5 A trigger that controls the entry of a date
- 3.1.6 Time triggers
- Chapter 4Object classes
- 4.1 The sheet class
- 4.1.1 Sheet information
- 4.1.2 The For In loop
- 4.1.3 Creating a table of contents
- 4.2 The spreadsheet class
- 4.2.1 Displaying a quick message
- 4.2.2 Hiding and displaying columns
- 4.3 The range class
- 4.3.1 Finding the end of an array
- 4.3.2 The offset method
- 4.4 Other classes
- Chapter 5From Sheets to Gmail
- 5.1 Copying information to Gmail
- 5.1.1 GmailApp class objects
- 5.1.2 Sending a mail without opening Gmail
- 5.1.3 Sending to several recipients
- 5.1.4 Sending a mail with an attachment
- 5.1.5 Adding a recipient to Cc or Cci
- 5.1.6 Limitations of Gmail free version
System requirements
File format: ePUB
Copy protection: Watermark-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Use a reading software that can process the file format ePUB: e.g., Adobe Digital Editions or FBReader – both free (see eBook Help).
- Tablet/Smartphone (Android; iOS): Before downloading, install the free app Adobe Digital Editions (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePUB works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Watermark-DRM, a „soft” copy protection. This means that there are no technical restrictions to prevent illegal distribution. However, there is a personalised watermark embedded in the eBook that can be used to identify the purchaser of the eBook in the event of misuse and to provide evidence for legal purposes.
For more information, see our eBook Help page.