|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-apps-script-code/
课程评论：没有评论
课程名称：Google Script Apps Fun with Spreadsheets Mini Projects 课程概述：本课程提供多种实用的代码片段，旨在帮助学员提升其Google Apps Script应用程序的功能。我们将探讨SpreadsheetApp类的一些优秀功能，并鼓励学生在此基础上构建和扩展迷你项目。课程内容强调如何应用Google Apps Script，前提是学员需具备基本的JavaScript经验。 课程主题包括： - 向Google Sheets中添加新行内容 - 为单元格设置字体大小等样式 - 在单元格中设置公式 - 动态更新值 - 使用UI对象创建自定义功能，例如查找和替换功能 - 获取和更新单元格数据，获取公式等 - 从电子表格创建HTML表格内容，随后进行邮件发送或在Web应用中使用 - 邮件服务：向活跃用户发送电子邮件 - 将电子表格复制为PDF，创建Blob并发送PDF - 选择并获取活动选择内容 - 在用户菜单中添加搜索选项，搜索Google Drive文件夹并将结果返回到电子表格 - 将文件夹搜索结果添加到电子表格 - 检查表格中的值并根据结果更新列值 - 复制和重复表格内容 此外，课程还包含用户界面（UI）的实例，以便脚本能够为Google App添加菜单、对话框和侧边栏等功能。脚本只能与当前开启的编辑器实例的UI交互，并且前提是脚本必须与该编辑器绑定。课程还提供源代码，便于学员复制并自行尝试。 该课程采用逐步学习的方法，快速友好的支持随时可在问答环节提供帮助。经验丰富的讲师拥有20年以上的教学经验，随时准备帮助学员学习。现在加入课程，开始创造您自己的实用应用程序吧！
Course included multiple useful code snippets to help you supercharge your Google Apps Script applications.The SpreadsheetApp Class has a lot of really great functionality in the course lessons we will be exploring how to make use of some of these functions, adding them to mini projects that students are encouraged to build upon and extend upon. Course covers APPLYING Google APPS SCRIPT - Prior JAVASCRIPT experience is REQUIRED for this course.Topics includeAppending new rows of content to Google sheetsSetting styling like font size to cellsSetting of formulas within cellsUpdating values dynamicallyUse of UI object within the spreadsheet Class Ui Creating custom functions find and replace for sheet menuGetting Cell data and updating cell data, getting formulas....Create content from spreadsheet as HTML tables- then email it or use in a web appEmail service sending emails to active userCopying spreadsheet as a PDF - creating a blob and emailing the PDF Selecting and getting active selected contentSearch option added to user menu - searching gDrive folders and returning results into SpreadsheetAdding folder search results to a spreadsheetChecking for values in sheet and updating column values depending on resultCopy and duplicate of sheet contentsUI - An instance of the user-interface environment for a Google App that allows the script to add features like menus, dialogs, and sidebars. A script can only interact with the UI for the current instance of an open editor, and only if the script is container-bound to the editor.Source code is included so you can copy and paste the code to try for yourself.Course is about applying Google Apps Script and JavaScript Step by step learningFast friendly support is always available within the Q & A sectionExperienced instructor with over 20 years of experience ready to help you learnYou have nothing to lose - Join now and start learning to create your own version of this helpful application today!!!
