[B! spread sheets] Kazabanaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Kazabana id:Kazabana

spread sheetsã«é–¢ã™ã‚‹Kazabanaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ã€ŒExcelã€ã«æ£è¦è¡¨ç¾ã®æ–°é–¢æ•°ãŒ3ã¤å°Žå…¥ã¸ ï½žã€ŒXLOOKUPã€ã€ŒXMATCHã€ã«ã‚‚å¯¾å¿œäºˆå®šï¼ã¾ãšã¯ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ç‰ˆã€ŒExcelã€ã§è©¦é¨“å°Žå…¥
Kazabana 2024/05/22
REGEXTESTã¯Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®REGEXMATCHã¨æ©Ÿèƒ½åŒã˜ï¼Ÿ

excel

microsoft

spread sheets

æ£è¦è¡¨ç¾
ãƒªãƒ³ã‚¯
Google Spreadsheetsã‹ã‚‰githubã¸ã®æ›¸ãå‡ºã— - æŠ€èŠ¸ã®ãŠã¼ãˆãŒã
Google Apps Script (ä»¥ä¸‹Apps Script)ã‚’ç”¨ã„ã‚‹ã¨ã€Google Appsã®å„ç¨®ã‚µãƒ¼ãƒ“ã‚¹ã¨ä»–ã‚µãƒ¼ãƒ“ã‚¹ã®é€£æºã‚’è¡Œã†ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ä»Šå›žã¯ã€ãŠå®¢æ§˜ã‹ã‚‰Googleã®ãƒ•ã‚©ãƒ¼ãƒ ã‚’ä»‹ã—ã¦ãƒã‚°ãƒ¬ãƒãƒ¼ãƒˆãŒé€ä¿¡ã•ã‚Œã‚‹ã¨ã„ã†ã“ã¨ã‚’æƒ³å®šã—ã¦ã€é€ã‚‰ã‚Œã¦ããŸãƒ‡ãƒ¼ã‚¿ã‚’githubã«ç™»éŒ²ã—ã¦é–‹ç™ºè€…ã«å‚ç…§ã•ã›ã‚‹ã¨ã„ã†ä»•çµ„ã¿ã‚’ä½œã£ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ å…·ä½“çš„ã«ã¯ã€ãƒ•ã‚©ãƒ¼ãƒ ã®å†…å®¹ãŒGoogle Docsã®ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆä¸Šã«æ›¸ãè¾¼ã¾ã‚Œã€ãã‚Œã‚’Apps Scriptã‚’ç”¨ã„ã¦githubã®ãƒ¬ãƒã‚¸ãƒˆãƒªã®issuesã«ç™»éŒ²ã™ã‚‹ã¨ã„ã†æµã‚Œã§ã™ã€‚ æ‰‹é †ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’æ–°è¦ã«ä½œæˆã—ã€ãã“ã‹ã‚‰ãƒã‚°ãƒ¬ãƒãƒ¼ãƒˆã¨ãªã‚‹ãƒ•ã‚©ãƒ¼ãƒ ã‚’ä½œæˆã™ã‚‹ã€‚ ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ä¸Šéƒ¨ã«ã‚ã‚‹ãƒ¡ãƒ‹ãƒ¥ãƒ¼ãƒãƒ¼ã«githubã®issuesã«ç™»éŒ²ã™ã‚‹ãŸã‚ã®æ–°ãŸãªãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚’ä½œæˆã™ã‚‹ã€‚ ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆä¸Šã‹ã‚‰ã€issuesã«
Kazabana 2011/09/03
Googleã®ãƒ•ã‚©ãƒ¼ãƒ ã‚’ä»‹ã—ã¦ãƒã‚°ãƒ¬ãƒãƒ¼ãƒˆãŒé€ä¿¡ã•ã‚Œã‚‹ã“ã¨ã‚’æƒ³å®šã—ã¦ã€é€ã‚‰ã‚Œã¦ããŸãƒ‡ãƒ¼ã‚¿ã‚’githubã«ç™»éŒ²ã—ã¦é–‹ç™ºè€…ã«å‚ç…§ã•ã›ã‚‹ä»•çµ„ã¿ã€‚

Google Apps Script

spread sheets

github

tips

development
ãƒªãƒ³ã‚¯
ç°¡å˜ã«å…¬é–‹ã•ã‚Œã¦ã„ã‚‹HTMLï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ï¼‰ã‹ã‚‰ã‚°ãƒ©ãƒ•ã‚’ç”Ÿæˆã™ã‚‹æ–¹æ³• - When itâ€™s ready.
åŽŸç™ºå¤§ä¸ˆå¤«ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã ã‚Œã‚‚æ£ç¢ºãªã“ã¨ã‚’ç”ãˆã‚‰ã‚Œãªã„ã‹ã‚‚çŸ¥ã‚Œã¾ã›ã‚“ãŒã€åŽŸç™ºã®å»ºç‰©è‡ªä½“ã¯å¤§å¤‰ãªçŠ¶æ…‹ã«ãªã£ã¦ã„ã¾ã™ã€‚ã•ã‚‰ã«ã€å´©å£Šç†±ã‚’å†·å´ã—ã‚ˆã†ã¨ç¾åœ°ã§ã¯å¤šãã®äººãŒæœ¬å½“ã«å‘½ãŒã‘ã§ä½œæ¥ã‚’ã•ã‚Œã¦ã„ã¾ã™ã€‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãƒ‘ãƒ‹ãƒƒã‚¯ã«ãªã‚‰ãªã„ãŸã‚ã«ã¯ã€æ£ã—ãåˆ¤æ–ã—ã¦ã„ãã“ã¨ãŒå¤§åˆ‡ã§ã™ã€‚æ„Ÿæƒ…ã«æ”¯é…ã•ã‚ŒãŸã¾ã¾ã€å†·é™ãªåˆ¤æ–ã‚’ãã ã™ã“ã¨ãŒé›£ã—ã„ã§ã™ã€‚æ™‚ã«ã¯æ„Ÿæƒ…ã«å¾“ã†ã“ã¨ãŒã„ã„æ™‚ã‚‚ã‚ã‚‹ã®ã§ã—ã‚‡ã†ãŒã€ä»Šã¯ãã®æ™‚ã§ã¯ãªã„ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ç‰¹ã«æ”¾å°„ç·šã«é–¢ã—ã¦ã¯ãƒ»ãƒ»ãƒ» å…¨å›½å„åœ°ã§æ”¾å°„ç·šã®ç¶™ç¶šç›£è¦–ãŒè¡Œã‚ã‚Œå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚å¤§æŠµã®å ´åˆãã‚Œã‚‰ã¯æ•°å€¤ã§å…¬è¡¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ï¼ˆå‚è€ƒï¼šhttp://113.35.73.180/report/report_table.doï¼‰ ã“ã®ã‚ˆã†ãªæ•°å—ã®ç¾…åˆ—ã‚’è¦‹ã¦ã€å¢—ãˆã¦ã„ã‚‹æ¸›ã£ã¦ã„ã‚‹ã¨å³åº§ã«åˆ¤æ–ã™ã‚‹ã®ã¯é›£ã—ã„ã§ã™ã‚ˆãã€‚éŽåŽ»ã®å‰äººãŒã‚°ãƒ©ãƒ•ã‚’ç™ºæ˜Žã—ã¦ãã‚Œã¦å±…ã‚‹ã®ã§ãã‚Œã‚’æ´»ç”¨ã—ãŸã„ã®ã§ã™ãŒã€ã‚°ãƒ©ãƒ•ã‚’
Kazabana 2011/08/06
Google Apps Scriptã§å€¤ã®ã¿ã‚’åˆ¥ã‚·ãƒ¼ãƒˆã«ã‚³ãƒ”ãƒ¼ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ã€‚

google

google apps

Google Apps Script

javascript

spread sheets

tips
ãƒªãƒ³ã‚¯
Twitteræ—¥æœ¬èªžãƒãƒƒã‚·ãƒ¥ã‚¿ã‚°ã ã£ã¦ã„ã†ã‚“ã§SpreadSheetã«ãƒã‚°ä¿å˜ã—ã‚ˆã†ãœ - YAMAGUCHI::weblog
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€Pythonç•Œã®æƒ…å¼±ã§ã™ã€‚æœ€è¿‘ã¯Google Apps ScriptãŒä¾¿åˆ©ã™ãŽã‚‹ã ã‚ã£ã¦ã“ã¨ã§ã¡ã‚‡ã£ã¨è«¸ç”¨ã‹ã‚‰Twitterã®ç™ºè¨€ã‚’é›†ã‚ã¦ãã¦Google Docsã®SpreadSheetã«ãƒã‚°ã‚’æ®‹ã™ã£ã¦ã„ã†æ„Ÿã˜ã®GASã‚’æ›¸ã„ã¦ã¿ã¾ã—ãŸã€‚JavaScriptã‚‚æƒ…å¼±ã™ãŽã¦ã‚„ã¹ãˆ... ã“ã‚“ãªæ„Ÿã˜ Google ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ ã¸ã‚ˆã†ã“ã ã¨ã‚Šã‚ãˆãšãƒãƒƒã‚·ãƒ¥ã‚¿ã‚°ã€Œ#ã—ã¿ãšã‹ã‚ã€ã§å¼•ã£å¼µã£ã¦ããŸç™ºè¨€ã‚’ã²ãŸã™ã‚‰ä¿å˜ã—ã¦ã¾ã™ã€‚5åˆ†ã”ã¨ã«cronå›žã—ã¦ã¾ã™ã€‚ã„ã˜ã‚ŠãŸã„ã¨æ€ã£ãŸå¥‡ç‰¹ãªæ–¹ã¯ã€Œãƒ•ã‚¡ã‚¤ãƒ« > ã‚³ãƒ”ãƒ¼ã‚’ä½œæˆ...ã€ã§ã©ã†ãžã€‚ ã‚¹ã‚¯ãƒªãƒ—ãƒˆ JSONã®æ‰±ã„ã¯æ™®é€šã«JSæ›¸ãã¨ãã¨é•ã£ã¦GASã®ä¸ã«ã‚ã‚‹Utilities.jsonParse()ä½¿ã£ãŸã»ã†ãŒã‚ˆã•ã’ã€‚ var TWITTER_BASE_URL = "http://search.twitter.com/search.jso
Kazabana 2011/07/15
cronä½¿ã†ã€‚

Google Apps Script

twitter

spread sheets

google

javascript
ãƒªãƒ³ã‚¯
Google Apps API Japan Group #1ã§LTã—ã¾ã—ãŸ - YAMAGUCHI::weblog
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€Pythonç•Œã®æƒ…å¼±é¸æ‰‹æ¨©æ—¥æœ¬ä»£è¡¨ã§ã™ã€‚æ˜¨æ—¥Google Apps API Japan Group #1ã¨ã„ã†ã‚ãƒƒã‚¯ã‚ªãƒ•ã‚¤ãƒ™ãƒ³ãƒˆãŒã‚ã£ãŸã‚“ã§ã™ãŒã€ãã“ã§Google Apps Scriptã«ã¯ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ãŒãŸãã•ã‚“ç”¨æ„ã—ã¦ã‚ã‚Šã¾ã™ã‚ˆã€ã¨ã„ã†ç´¹ä»‹ã‚’ã—ã¦ãã¾ã—ãŸã€‚ãã®ä¾‹ã¨ã—ã¦ç°¡å˜ãªTwitterã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚’ä½œã£ãŸã®ã§ç´¹ä»‹ã—ã¾ã™ã€‚ å‚è€ƒ Tutorial: Twitter Approval Manager - Google Apps Script â€” Google Developers ã“ã®ã‚µãƒ³ãƒ—ãƒ«ã‚’ä½¿ã†ã¨ç°¡å˜ã«Twitterã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚’ä½œã£ã¦ã¿ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ï¼ˆãã¡ã‚“ã¨ç†è§£ã™ã‚‹ã®ã§ã‚ã‚Œã°ä»–ã®ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã‚‚æ˜¯éžã”è¦§ãã ã•ã„ï¼‰ Google Apps API Japan | Google ã‚°ãƒ«ãƒ¼ãƒ— Google Apps API Japanã®Google Group
Kazabana 2011/07/15
å½“æ—¥ã«å‚åŠ ã—ãŸã®ã§ãƒ¡ãƒ¢ã€‚

google

google apps

Google Apps Script

javascript

spread sheets

api
ãƒªãƒ³ã‚¯
1