售 价：¥
6.2
温馨提示：数字商品不支持退换货，不提供源文件，不支持导出打印
为你推荐
Google Apps Script for Beginners
Table of Contents
Google Apps Script for Beginners
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers, and more
Why subscribe?
Free access for Packt account holders
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Errata
Piracy
Questions
1. Enhancing Spreadsheets
Spreadsheet functions versus Google Apps Script – how to choose?
An example
The spreadsheet-formula approach
The Google Apps Script approach – a few comments
The Google Apps Script approach – the code
Using the development environment – the script editor
The advantages of autocompletion
Reading the documentation
Custom spreadsheet functions
Formatting your spreadsheets automatically
Menus and custom buttons in spreadsheets
Reading and writing data from spreadsheets – best practices and performances
Example
Catching events
Who is doing what? Script authorizations
Protecting your data
Publishing your data on the Web
Printing and exporting the result
Summary
2. Create and Manipulate Forms
What tools do we have?
Forms' limitations
Handling answers
Forms' alternatives
A quick peek at the UiApp and HTML services
Summary
3. Managing an E-mail Account
Retrieving Gmail data
Creating labels
Counting, sorting, archiving, and deleting e-mails and threads
Execution time versus time limit
Creating e-mail messages
Automating a complete workflow
Summary
4. Embedding Scripts in Text Documents
What can be done
Generating a Google document from spreadsheet data using a script
Analyzing, duplicating, and modifying document elements
Using a script to insert an image into a document
Compiling and presenting data from other services
Summary
5. Embedding Scripts in Google Sites
Site gadget's limitations/restrictions/use cases
Creating and maintaining sites with Google Apps Script
Creating pages
Interactivity
Summary
6. Standalone Web Applications / User Interfaces
UI or not UI, that's the question
Common concepts to all web apps
Building an efficient UI
Building a good-looking UI
Building an amazing UI
Limiting user access
Protecting your data (and your script)
Summary
7. Using User Interfaces in Spreadsheets and Documents
Pop ups
Sidebars
Summary
8. How to Expand your Knowledge
JavaScript versus Google Apps Script
Infinite resources
Being a newbie is, by definition, temporary
Try to find your own best learning method
Summary
9. Conclusion
Development perspectives
Google's secrets
Personal point of view
Index
买过这本书的人还买过
读了这本书的人还在读
同类图书排行榜
购物车
个人中心
