This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import datetime | |
import os | |
import fnmatch | |
import re | |
import time | |
import urllib.parse | |
from pathlib import Path | |
from winreg import HKEY_CURRENT_USER, HKEY_CLASSES_ROOT, OpenKey, QueryValueEx | |
import pyauto |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
' 参照設定 Microsoft VBScript Regular Expressions | |
' 参照設定 Microsoft Scripting Runtime | |
Function Variation(myRng As Range) As Long | |
' 引数内の範囲に何種類のデータが有るかカウント | |
'連想配列を利用 | |
Dim myDict As New Scripting.Dictionary | |
Dim cl As Variant | |
For Each cl In myRng.Cells | |
If cl.Value <> "" And myDict.Exists(cl.Value) = False Then |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
slack の特定チャンネルで古くなったファイルを自動的に削除する | |
http://lyncs.hateblo.jp/entry/2017/06/04/191421 を参考に見よう見まねで実装中 | |
*/ | |
// スクリプトのプロパティからトークンの値をグローバル変数として取得 | |
var SLACK_ACCESS_TOKEN = PropertiesService.getScriptProperties().getProperty("TOKEN_PERSONAL"); | |
// チャンネルIDを取得する関数 | |
// mode : public(パブリックチャンネル) or private (プライベートチャンネル) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
今日のトレーニングを slack で確認してカレンダーに登録 | |
*/ | |
/////////////////////////////////////////////////////// | |
// グローバル変数 | |
/////////////////////////////////////////////////////// | |
// シート | |
var SHEET_ID = PropertiesService.getScriptProperties().getProperty("SHEET_ID"); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Wifiから切断された時点のタイムスタンプを IFTTT でシートに取得して定時からの差分で残業時間を google カレンダーに自動登録する。 | |
時刻トリガーで深夜に定期実行。 | |
使用ライブラリ: Moment | |
*/ | |
/////////////////////////////////////////////////////// | |
// グローバル変数 | |
/////////////////////////////////////////////////////// |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
slack 経由で家計簿を登録して集計する。 | |
- interactive components | |
- Bot token scopes | |
- chat:write | |
- reactions:write | |
- User token scopes | |
- channels:history | |
*/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
slack 経由で辞典のデータを参照 | |
*/ | |
///////////////////////////////////////////// | |
// グローバル変数 | |
///////////////////////////////////////////// | |
// シート | |
var SHEET_ID = PropertiesService.getScriptProperties().getProperty("SHEET_ID"); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
1日前のツイートをエゴサーチして集約・報告 | |
使用ライブラリ: Moment | |
*/ | |
//////////////////////////////////////////////////////// | |
// グローバル変数 | |
//////////////////////////////////////////////////////// | |
// token |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
slash command | |
言いたいことをロボットに代弁してもらう | |
scope | |
chat:write:bot | |
interactive components | |
*/ | |
///////////////////////////////////////////////////////////////////////// | |
// グローバル変数 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
line 経由で google シートに家計簿を記録する | |
*/ | |
///////////////////////////////////////////////////////////////////////// | |
// グローバル変数・汎用関数 | |
///////////////////////////////////////////////////////////////////////// | |
// スクリプトのプロパティ | |
const PROPS = PropertiesService.getScriptProperties(); |
OlderNewer