# Excel & App Script --- ## 測試環境 [Google Sheet (Excel)](https://docs.google.com/spreadsheets/) [Google App Script (GAS)](https://script.google.com/home) [GAS dark theme extension](https://chrome.google.com/webstore/detail/appsscript-color/ciggahcpieccaejjdpkllokejakhkome) [webhook](https://webhook.site/) --- ## Excel基礎公式 =、<>、and、or、not sum、avgerage、max、min if、ifs、iferror [vlookup](https://support.google.com/docs/answer/3093318?hl=zh-Hant)、[hlookup](https://support.google.com/docs/answer/3093375?hl=zh-Hant) [row](https://support.google.com/docs/answer/3093316?hl=zh-Hant)、[column](https://support.google.com/docs/answer/3093373?hl=zh-Hant)、[index](https://support.google.com/docs/answer/3098242?hl=zh-Hant)、[match](https://support.google.com/docs/answer/3093378?hl=zh-Hant) [find](https://support.google.com/docs/answer/3094126?hl=zh-Hant)、[left](https://support.google.com/docs/answer/3094079?hl=zh-Hant)、[mid](https://support.google.com/docs/answer/3094129?hl=zh-Hant)、[right](https://support.google.com/docs/answer/3094087?hl=zh-Hant)、[substitute](https://support.google.com/docs/answer/3094215?hl=zh-hant) --- ## GAS基礎用法 [SpreadsheetApp](https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=zh-tw) ```javascript= SpreadsheetApp.openById Spreadsheet.getSheets、sheet.getSheetByName sheet.getRange range.getValue(s)、range.setValue(s) ``` [UrlFetch](https://developers.google.com/apps-script/reference/url-fetch?hl=zh-tw) [Services (Google API)](https://developers.google.com/apps-script/guides/services/advanced?hl=zh-tw) --- ## 實作時間 好了，你已經對Excel跟GAS的基礎用法有一定瞭解了 現在讓我們看一下這個簡單題目，把剛剛學到的知識實踐出來吧~ [~~梗圖連結~~](https://img.moegirl.org.cn/common/f/f0/%E7%BC%96%E7%A8%8B%E6%95%B0%E5%AD%A6%E4%B9%A6.jpg) ---- ## 今日目標 ### 1.整理成績資料 ### 2.透過GAS取得YT頻道新影片通知 [練習用資料 點我><](https://docs.google.com/spreadsheets/d/1cTKVDziMsUyKrqEQzeOOJ_1i8411Ayn5_bm-3rS-HZU) --- ## ~~參考資料(?)~~ [多條件lookup](https://zh-tw.extendoffice.com/documents/excel/2440-excel-vlookup-multiple-criteria.html) [GAS答案](https://script.google.com/d/1XaMW45sk1YXg7yHgpzwbfLk_hJaUxM6eko35OwjBn6B3ZiizjrbTVs-I/edit) ~~https://www.game735.com/thread-375300-1-1.html~~ --- # End