دانلود کتاب Going GAS: from VBA to Google Apps Script – Going GAS: از VBA به Google Apps Script

توضیحات

Note continued: VBA FileSystemObject — Apps Script DriveApp Service — 10.HTML Service — Why Client Execution? — The Downside — The VBA Connection — HTML Service Varieties — Web Apps — Dialogs — Sidebars — jQuery — Event Handling — Templates — Structure — Controlling Apps Script from the Client — Using Namespaces in HtmlService — Multiple Menu Items — indexRun.html — mainRun.js — Client Namespace — Render.js — App.js — Dialog HtmlService — HtmlService Web Apps — VBA User Form — Create a User Form — Initialize the Combo Box — Listen for Changes — The Form — 11.Content Service — The Content Service — Where to Use the Content Service — Types of Content — Example — Request — Response — Details — doGet — The Settings — SheetOb — getFlight — getRegex — Initial Result — JSONP — XML — makeXml — Publishing — Script Files — The Publishing Process — Permissions — Delegation from VBA — Querying Apps Script — 12.Charts;Note continued: Copy/Paste Port — Native Port — Arguments to Custom Formulas — Performance — Documentation and Autocomplete — Adding Functions to Menus — Tables — Converting Values to an Object — Emulating Tables in Apps Script — ListObject — 7.The Document App — Opening Documents — Working with Elements — Traversing the Document — Traversing in VBA — Annotating the Document — Ranges — VBA Range — VBA Discontiguous Ranges — RangeElements — The showRange Utility — RangeBuilder — Named Ranges — Setting a Cursor Using a Named Range — Position — Position Within Element — Creating a Selection — Creating a VBA Selection — Inserting Text — Bookmarks — IDs — VBA Bookmark Insert — Bookmark Appearance — Traversing Bookmarks — Text Bookmarks — Creating Links — Setting a Cursor Position — Removing Bookmarks — Editing Text in Elements — Adding Elements — Containers — Element childIndex — VBA childIndex — Inserting Elements — Tables;Note continued: OneDrive Authentication — Other OAuth 2.0 Services — OAuth 2.0 with VBA — Developers Console — getGoogled — Content Service with OAuth2 — Other Kinds of Authentication — Basic Authentication — JWT (JSON Web Tokens) — What Is a JWT? — Firebase Authentication — JWT Format — FirebaseAuth Namespace — Standardized OAuth 2.0 Process — 16.External APIs and Integration — REST API — Code — Reuse — Databases — Firebase — Main Code — Permissions — Settings — Firebase Class — Reuse — Result — Databases and Apps Script — 17.Execution API — What Is Incremental Migration? — Migration Process — The Execution API — Inventory for Execution API — Authentication and Access — Credentials — Publishing — Scopes — Getting Googled — JSON — SheetExec — Example Workflow Migration from Office — Moving a Workbook to Sheets — VBA Code to Read a Sheet — Apps Script Code to Read a Sheet — VBA Code to Write Data to a Local Workbook;Machine generated contents note: 1.Introduction — What Is VBA? — Extending — Fragility — Security — Asynchronicity — Efficiency and Performance — Maintainability — What Is JavaScript? — A Quick History — Versions — JavaScript Is Not Java — Learning JavaScript — What Is Apps Script? — Versions — It Runs on a Server — Services — Fully Authenticated Environment — Quotas — Performance — Asynchronicity — Events — Triggers — Web Apps — Maintainability — IDE — What Is Apps Script Good For? — What Are Google Add-Ons? — Types of Add-Ons — Security — The Publishing Process — What Are Google Forms? — What Are Microsoft Add-Ins? — Comparison — 2.Language Basics — Style — Hungarian — Camel Case — Case Sensitivity — Copy/Paste Porting — Types — Operators — Mathematical Operators — Assignment Operators — String Operators — Comparison Operators — Logical Operators — Bitwise Operators — Variables — Variable Types — Functions;Note continued: Chart Data — VBA Charts — Code — Sheets Charts — EmbeddedChartBuilder — setPosition — Types of Chart — Visualization API — Google Visualization HtmlService App — Other Chart Formats — 13.Sites — Apps Script — Gadgets — Code Lockdown — Advertising — VBA — The Future of Sites — 14.Advanced Google Services — What Are Advanced Google Services? — Advanced Services Versus Google APIs — Developers Console — Enabling Advanced Services — Fusion Tables Example — Settings Namespace — Copy Sheet to Fusion — Fusion Namespace — Fusion Quotas — Scripts Structure — Currently Available Advanced Services — 15.Authentication and Security — OAuth 2.0 — Setup — Access — Refresh — Scopes — Limiting Scope to the Current Document — Listing Authorized Apps — Revoking Access — ScriptApp — Service Accounts — Libraries — OAuth 2.0 Example — Creating the Cloud Console Project — Scopes — Accessing Other Oauth 2.0 Services;Note continued: Container-Bound Versus Standalone Scripts — Getting Started with the Spreadsheet Service — A Note About Authorization — Opening the Active Sheet — The Range Class — Creating a Range — Returning the Data Range — Getting the Values of a Range — Writing Values to a Range — Returning Selected Data — Reading and Writing for Partial Ranges — Reading Attributes from a Range — Writing Attributes to a Range — Inserting and Deleting Rows and Columns — Opening Other Sheets — Iterating All Sheets — Getting a Sheet by Name or Index — Opening Other Workbooks — Creating a Standalone Script — Accessing Multiple Workbooks — Working with Multiple Workbooks — Updating Sheets — Showing Messages — Toast — Showing Messages with Buttons — Getting Input — Getting and Setting Properties — Document, User, or Script? — Setting Properties in the Registry — Setting Properties Using the Properties Service — Changing Settings — Custom Formulas;Note continued: Helper Functions — String Functions — Conversion Functions — Math Functions — Informational Functions and Constants — Date and Time Functions — Optional Arguments — Testing for undefined — Applying Default Values — Named Arguments — Handling Errors — VBA Exception Branching — JavaScript try/catch — Raising an Error — VBA Built-In Objects — Type — Key/Value Pairs — Collections — 4.Living with the Quotas — The Quotas — Daily Limits — Limitations — Triggers — Rate Limits — Throttling — Sleeping — Exponential Backoff — Splitting — Libraries — Batching — Parallel Running — Offloading — Avoiding Service Calls — Cache Service — 5.The Properties Service — APIs Versus Built-In Services — Getting Started with Properties Service — Uses and Types of Property Stores — Selecting a Property Store — The Registry Versus the Property Store — Comparisons — 6.The Spreadsheet Service — Custom Formulas;Note continued: List Items — VBA ListParagraph — Images — Docs Automation Example — Selecting the Target Area — Inserting the Table — Adding to Custom Menu — Attributes — Text Attributes — Attribute Equivalence — Partial Attributes — Attribute Indices — 8.Gmail, Calendar, and Contacts Apps — Email Automation Exercise — Scenario — Threads — Searching — Messages — Message Filtering — Regular Expression Searching — Name Lookup — Body Errors — Result Reduction — Generate a Regular Expression — Attachments — Organizing — Recipients — Organizing by Recipient — Sending — Labels — VBA Categories — Calendar — Events — The Courses Namespace — Advanced Calendar Service — Contacts — ContactGroups — Contacts Namespace — Organizing Courses — Setting Up the Example — The Settings — Triggers — Apps Script Main Function — VBA Main Function — Scheduling — 9.Drive and DriveApp — Microsoft OneDrive — Reading and Writing Files;Note continued: VBA Code to Write to a Sheet from a Local Workbook — Apps Script Code to Write to a Sheet from a Local Workbook — Migrating Logic — VBA Code to Initiate Logic on Apps Script — Logic Code Delegated to Apps Script — VBA Orchestration — VBA Process Orchestration Code — Apps Script Logging Code — Final Migration Steps — Testing JavaScript on the PC — VBA Code to Get Source Code from Apps Script — Apps Script Code to Return Source Code — Getting the Source and Testing Local Execution — Execution API Potential — 18.Office Add-Ins and Google Add-Ons — Add-Ons — Add-Ins — The Same… — … But Different — Add-On Example — The Dataset — Capabilities — Apps Script Add-On — What You Will Learn — The Namespaces — Sharing Code Between Client and Server — index.html — main.js — styles.css — App Namespace — Cors — Add-On Script — Reused Namespaces — Server Namespace — Client Namespace — Render Namespace — Testing an Add-On;Note continued: Office Add-In — What You Will Learn — The IDE — Structure — index.html — mainOffice.js — App.js — Client.js — Testing the Add-In — Result Comparison — Further Exercises.;Note continued: Assigning Functions to Variables — Anonymous Functions — Functional Programming — Loops and Iteration — Layout — Whitespace and Newlines — Semicolons — Curly Braces — Scope — Objects — JavaScript Object Notation — JSON Examples — Classes — Prototypes and Constructors — Inheritance — Methods — A Note on this — Getters and Setters — VBA Example — Using Object.create — Conclusion — Namespaces — Google Services — Libraries — Creating Your Own Namespace — Avoiding Namespace Collisions — The IDE — Container-Bound Scripts — Standalone Scripts — Code Examples — Accessing the IDE — Running a Function — Examining Results — Libraries — Libraries in the Cloud — Namespaces and Libraries — Managing Library Versions — Adding Libraries to a Project — Some Notes on Library Sprawl — 3.Translating VBA Functions — Conventions — Library and Namespace — JSDOC — JSDOC Example — VBA Built-Ins Translated to JavaScript

————————————————————–

ترجمه ماشینی :

توجه ادامه داد: VBA FileSystemObject — Apps Script DriveApp Service — سرویس 10.HTML — چرا Client Execution؟ — نکات منفی — اتصال VBA — انواع سرویس های HTML — برنامه های وب — گفتگوها — نوارهای جانبی — jQuery — مدیریت رویداد — الگوها — ساختار — کنترل اسکریپت برنامه ها از مشتری — استفاده از فضاهای نام در HtmlService — آیتم های چندگانه منو — indexRun.html — mainRun.js — فضای نام کلاینت — Render.js — App.js — گفتگوی HtmlService — برنامه های وب HtmlService — فرم کاربر VBA — ایجاد یک فرم کاربر — اولیه سازی جعبه ترکیبی — گوش دادن به تغییرات — فرم — 11. سرویس محتوا — سرویس محتوا — محل استفاده از سرویس محتوا — انواع محتوا — مثال — درخواست — پاسخ — جزئیات — doGet — تنظیمات — SheetOb — getFlight — getRegex — نتیجه اولیه — JSONP — XML — makeXml — انتشار — فایلهای اسکریپت — فرآیند انتشار — مجوزها — تفویض اختیار از VBA — Querying Apps Script — 12.Charts; توجه ادامه داد: پورت کپی/پیست — پورت بومی — استدلال برای فرمول های سفارشی — عملکرد — مستندسازی و تکمیل خودکار — افزودن توابع به منوها — جداول — تبدیل مقادیر به یک شی — شبیه سازی جداول در اسکریپت برنامه — ListObject — 7. برنامه سند — باز کردن اسناد — کار با عناصر — عبور از سند — پیمایش در VBA — حاشیه نویسی سند — محدوده — محدوده VBA – محدوده‌های ناپیوسته VBA – RangeElements – ابزار showRange – RangeBuilder – محدوده‌های نام‌گذاری شده – تنظیم مکان‌نما با استفاده از محدوده نام‌گذاری شده – موقعیت – موقعیت در عنصر – ایجاد یک انتخاب – ایجاد یک انتخاب VBA – درج متن — نشانکها — شناسهها — درج نشانک VBA — ظاهر نشانک — عبور از نشانکها — نشانکهای نوشتاری — ایجاد پیوندها — تنظیم موقعیت مکاننما — حذف نشانکها — ویرایش متن در عناصر — افزودن عناصر — – کانتینرها — Element childIndex — VBA childIndex — درج عناصر — جداول؛ توجه ادامه دارد: تأیید اعتبار OneDrive — سایر خدمات OAuth 2.0 — OAuth 2.0 با VBA — Developers Console — getGoogled — خدمات محتوا با OAuth2 — انواع دیگر احراز هویت — احراز هویت اولیه — JWT (JSON Web Tokens) — JWT چیست؟ — احراز هویت Firebase — فرمت JWT — فضای نام FirebaseAuth — فرآیند استاندارد OAuth 2.0 — 16. APIهای خارجی و یکپارچه سازی — REST API — کد — استفاده مجدد — پایگاه های داده — Firebase — کد اصلی — مجوزها — – تنظیمات – کلاس Firebase – استفاده مجدد – نتیجه – پایگاه‌های داده و اسکریپت برنامه‌ها – 17. Execution API – مهاجرت افزایشی چیست؟ — فرآیند انتقال — API اجرا — موجودی برای اجرای API — احراز هویت و دسترسی — اعتبارنامه ها — انتشار — حوزه ها — جستجو در گوگل — JSON — SheetExec — نمونه مهاجرت گردش کار از Office — انتقال یک Workbook به Sheets — کد VBA برای خواندن یک برگه — برنامه ها کد اسکریپت برای خواندن یک برگه — کد VBA برای نوشتن داده ها در یک کتاب کار محلی؛ محتویات تولید شده توسط

tag : دانلود کتاب Going GAS: از VBA به Google Apps Script , Download Going GAS: از VBA به Google Apps Script , دانلود Going GAS: از VBA به Google Apps Script , Download Going GAS: from VBA to Google Apps Script Book , Going GAS: از VBA به Google Apps Script دانلود , buy Going GAS: از VBA به Google Apps Script , خرید کتاب Going GAS: از VBA به Google Apps Script , دانلود کتاب Going GAS: from VBA to Google Apps Script , کتاب Going GAS: from VBA to Google Apps Script , دانلود Going GAS: from VBA to Google Apps Script , خرید Going GAS: from VBA to Google Apps Script , خرید کتاب Going GAS: from VBA to Google Apps Script ,