[B! é€£æƒ³é…åˆ—] fukudamasa09ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

fukudamasa09 id:fukudamasa09

é€£æƒ³é…åˆ—ã«é–¢ã™ã‚‹fukudamasa09ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

${{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}}

Office TANAKA - Excel VBA Tips[é‡è¤‡ã—ãªã„ãƒªã‚¹ãƒˆã‚’ä½œã‚‹(1)]
ã€Œã‚ãƒ¼ã€ã¨ã€Œå€¤ã€ãŒã‚»ãƒƒãƒˆã«ãªã£ã¦ã„ã¦ã€ã€Œç¥žå¥ˆå·çœŒã€ã¨ã„ã†ã‚ãƒ¼ã§ã€Œæ¨ªæµœå¸‚ã€ã¨ã„ã†å€¤ã‚’æ¤œç´¢ã§ãã‚‹ã‚ˆã†ãªä»•çµ„ã¿ã§ã™ã€‚Dictionaryã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã§ã¯ã€ã“ã†ã—ãŸé€£æƒ³é…åˆ—ã«ãƒ‡ãƒ¼ã‚¿(ã‚ãƒ¼ã¨å€¤ã®ã‚»ãƒƒãƒˆ)ã‚’è¿½åŠ ã—ãŸã‚Šã€æ¤œç´¢ã—ãŸã‚Šã€ä»»æ„ã®ã‚ãƒ¼ãŒã™ã§ã«å˜åœ¨ã—ã¦ã„ã‚‹ã‹ã©ã†ã‹ã‚’èª¿ã¹ã“ã¨ãªã©ãŒã§ãã¾ã™ã€‚ãªãŠã€é€£æƒ³é…åˆ—ã§ã¯åŒã˜ã‚ãƒ¼ã‚’ç™»éŒ²ã§ãã¾ã›ã‚“ã€‚ Dictionaryã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä½¿ã£ã¦é‡è¤‡ã—ãªã„ãƒªã‚¹ãƒˆã‚’ä½œæˆã™ã‚‹ã«ã¯ã€æ¬¡ã®ã‚ˆã†ã«è€ƒãˆã¾ã™ã€‚ ã‚»ãƒ«A2ã‹ã‚‰ã‚»ãƒ«A8ã¾ã§é †ã«ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã—ã¾ã™ å–å¾—ã—ãŸãƒ‡ãƒ¼ã‚¿ãŒé€£æƒ³é…åˆ—ã«ç™»éŒ²ã•ã‚Œã¦ã„ãªã‹ã£ãŸã‚‰ç™»éŒ²ã—ã¾ã™ å–å¾—ã—ãŸãƒ‡ãƒ¼ã‚¿ãŒé€£æƒ³é…åˆ—ã«ç™»éŒ²ã•ã‚Œã¦ã„ãŸã‚‰ä½•ã‚‚ã—ã¾ã›ã‚“ æµã‚Œã¯ã“ã‚“ãªæ„Ÿã˜ã§ã™ã€‚ã•ã¦ç™»éŒ²ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã§ã™ãŒã€é€£æƒ³é…åˆ—ã§ã¯ã€Œã‚ãƒ¼ã€ã¨ã€Œå€¤ã€ã®äºŒã¤ãŒå¿…è¦ã§ã™ã€‚ä»Šå›žã®ã‚±ãƒ¼ã‚¹ã§ã¯ã€Œåå‰ã€ãƒ‡ãƒ¼ã‚¿ã—ã‹ã‚ã‚Šã¾ã›ã‚“ã€‚ã€Œåå‰ã€ã‚’ã€Œã‚ãƒ¼ã€ã«ã™ã‚‹ã¨ã—ã¦ã€ã€Œå€¤ã€ã«ã¯ä½•ã‚’ç™»éŒ²ã—ãŸã‚‰ã„ã„ã®ã§ã—ã‚‡ã†ã€‚
fukudamasa09 2014/05/01
AS

Microsoft

()

access

*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

Excel

VBA

Office

é€£æƒ³é…åˆ—

é‡è¤‡ãƒã‚§ãƒƒã‚¯
ãƒªãƒ³ã‚¯
JavaScriptã®ç¾Žã—ã•ï¼ˆå¤šæ¬¡å…ƒé…åˆ—ã‚½ãƒ¼ãƒˆï¼‰ | æ ªå¼ä¼šç¤¾ãƒ•ã‚©ãƒ¬ã‚¹ãƒˆãƒ»ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒ„
<?php $list = array( array("no"=>3, "cat"=>5, "body"=>"ãƒªãƒ³ã‚´"), array("no"=>2, "cat"=>4, "body"=>"ã¿ã‹ã‚“"), array("no"=>4, "cat"=>5, "body"=>"ãƒŠã‚·"), array("no"=>6, "cat"=>3, "body"=>"ãƒãƒŠãƒŠ"), array("no"=>1, "cat"=>4, "body"=>"ã‚ªãƒ¬ãƒ³ã‚¸") ); usort($list, create_function('$a, $b', 'return $a["cat"]-$b["cat"];')); print_r("<pre>"); print_r($list); print_r("</pre>"); ?>
fukudamasa09 2012/07/26
array

list

javascript

*hack

js

é€£æƒ³é…åˆ—

ã‚½ãƒ¼ãƒˆ

PHP

sample

Array
ãƒªãƒ³ã‚¯
Javascriptã«ãŠã‘ã‚‹é…åˆ—ã¨é€£æƒ³é…åˆ— prototype.jsç·¨ ãã®1 (Yak blog)
ITæˆ¦è¨˜ã•ã‚“ã§ã€ã€ŒJavascriptã®é…åˆ—ã¨é€£æƒ³é…åˆ—ã®é•ã„ã€ãŒè§£èª¬ã•ã‚Œã¦ã¾ã—ãŸã€‚ ã§ã€ãŠãªã˜ã¿ã® Javascriptç”¨ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã® prototype.js(ã„ã¤ã®ã¾ã«ã‹å…¬å¼ã‚µã‚¤ãƒˆãŒãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã•ã‚Œã¦ã€ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆç‰ãŒã‹ãªã‚Šå……å®Ÿã—ã¦ã¾ã™)ã‚’ä½¿ã£ã¦ã¦ ã¯ã¾ã£ãŸãƒã‚¤ãƒ³ãƒˆãŒä»¥å‰ã‚ã£ãŸã®ã‚’æ€ã„å‡ºã—ãŸã®ã§ã€ã¡ã‚‡ã£ã¨æ›¸ã„ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ã¨ã„ã†ã‹ã€ãªã‚“ã‹ prototype.jsã®åˆæ©çš„ãªè§£èª¬ã«ãªã£ã¦ã‚‹ã‹ã‚‚ã—ã‚Œãªã„ãƒ»ãƒ»ãƒ» ã¨ã„ã†ã‚ã‘ã§ã€ã‹ãªã‚Šä¹…ã€…ã®æŠ€è¡“ã‚¨ãƒ³ãƒˆãƒªã€‚ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã—ãªã„æ–¹ã«ã¯ã”ã‚ã‚“ãªã•ã²ã€‚ prototype.jsã«ãŠã‘ã‚‹é…åˆ— prototype.jsã§ã¯ã€é…åˆ— (Arrayã‚¯ãƒ©ã‚¹)ã¯ prototypeãŒæ‹¡å¼µã•ã‚Œã¦ã„ã¦ã€Enumerableã‚¯ãƒ©ã‚¹ã‚’ç¶™æ‰¿(Object.extend)ã—ã¦ã„ã¾ã™ã€‚ ãªã®ã§ã€for in æ§‹æ–‡ã‚’ä½¿ã†ã¨Enumerableã®ãƒ¡ãƒ³ãƒé–¢æ•°ã¾ã§åˆ—æŒ™ã—ã¦ã—ã¾ã„
fukudamasa09 2012/06/14
array

js

hoge

Ajax

javascript

prototype.js

é…åˆ—

é€£æƒ³é…åˆ—

ä¾¿åˆ©
ãƒªãƒ³ã‚¯
JavaScriptã®é…åˆ— vol.3 -é€£æƒ³é…åˆ— ï¼ˆ ãƒãƒƒã‚·ãƒ¥ ï¼‰ - - çœŸå¤œä¸ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°Tips
JavaScriptã®é…åˆ— vol.1 -é…åˆ—ã®å®£è¨€-, JavaScriptã®é…åˆ— vol.2 -é…åˆ—ã®å®£è¨€(ç¶š)- ã§ã¯ã€Javascript ã«ãŠã‘ã‚‹é…åˆ—ã®å®£è¨€ã«ã¤ã„ã¦ã§ã—ãŸã€‚ ã•ã¦ã€ä»Šå›žã¯é€£æƒ³é…åˆ—ï¼ˆãƒãƒƒã‚·ãƒ¥ï¼‰ã«ã¤ã„ã¦ã®å‚™å¿˜éŒ²ã§ã™ã€‚é€£æƒ³é…åˆ—ï¼ˆãƒãƒƒã‚·ãƒ¥ï¼‰ã«ã¤ã„ã¦ã‚‚ã‚„ã¯ã‚ŠJavaScript ã¯æ‘©è¨¶ä¸æ€è°ãªè¨€èªžã§ã™ã€‚ 1. é€£æƒ³é…åˆ—ï¼ˆãƒãƒƒã‚·ãƒ¥ï¼‰ã®å®£è¨€ ï¼ˆãµã¤ã†ã®ï¼‰é…åˆ—ã®å®šç¾©åŒæ§˜ã€é€£æƒ³é…åˆ—ã®å®šç¾©ã‚‚ã•ã¾ã–ã¾ãªãƒãƒªã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚ã‚Šã¾ã™ã€‚çµè«–ã‹ã‚‰è¨€ã†ã®ã¯ãŠã‚‚ã—ã‚ããªã„ã‚‚ã®ã§ã™ãŒã€ãƒãƒªã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã‚ã‚Œã© (1) ã‚’ç”¨ã„ã‚‹ã®ãŒé€£æƒ³é…åˆ—ã§ã‚ã‚‹ã¨ã‚ã‹ã‚Šã‚„ã™ãã¦ã‚ˆã„ã¨æ€ã„ã¾ã™ã€‚ (1) ã‚ªãƒ¼ã‚½ãƒ‰ãƒƒã‚¯ã‚¹ãªé€£æƒ³é…åˆ— var hash_sample_1 = new Array(); hash_sample_1['name'] = "çœŸå¤œä¸ãƒŠãƒ“ æ·±å¤œå–¶æ¥ã®ãŠåº—æŽ¢ã—"; hash_sample_1['url'] =
fukudamasa09 2012/06/08
javascript

é€£æƒ³é…åˆ—

object

array

JSON

!__JavaScript

js

ãƒãƒƒã‚·ãƒ¥

hash

tips
ãƒªãƒ³ã‚¯
é…åˆ—ã¨ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨é€£æƒ³é…åˆ— - Ajaxå°‚
Javascriptã§çŸ¥ã£ã¦ãŠãã¹ãçŸ¥è˜ ï¼žã€€é…åˆ—ã¨ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨é€£æƒ³é…åˆ— 2006å¹´09æœˆ21æ—¥ é…åˆ—ã¨ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ç•¥å¼ï¼ˆå‰æçŸ¥è˜ï¼‰ é…åˆ—åž‹(Array)ã¨ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆåž‹(Object)ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆä½œæˆã¯é€šå¸¸æ›¸ãå ´åˆã€ var array = new Array(); var object = new Object(); â€»å®£è¨€æ™‚ã® ( ) ã¯çœç•¥ã§ãã¾ã™ãŒã€ã€ŒAjaxå°‚ã€ã§ã¯ä»˜ã‘ã‚‹æ–¹å‘ã§çµ±ä¸€ã—ã¾ã™ã€‚
fukudamasa09 2012/06/08
object

programming

array

Ajax

!__JavaScript

javascript

é€£æƒ³é…åˆ—

é…åˆ—

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

ajax
ãƒªãƒ³ã‚¯
JavaScriptè¬›åº§ : é€£æƒ³é…åˆ—ï¼ˆãƒãƒƒã‚·ãƒ¥ï¼‰
JavaScriptã§ã¯é€£æƒ³é…åˆ—ï¼ˆãƒãƒƒã‚·ãƒ¥ï¼‰ã‚’æ‰±ã†ã“ã¨ãŒã§ãã¾ã™ã€‚åå‰ã®é€šã‚Šé…åˆ—ãªã®ã§é€šå¸¸ã®é…åˆ—ã¨åŒæ§˜ã«new Array()ã¾ãŸã¯[]ã§ç”¨æ„ã—å€¤ã‚’ä»£å…¥ã—ã¾ã™ã€‚é€šå¸¸ã®é…åˆ—ã§ã¯æ·»å—ã«æ•°å€¤ã‚’æŒ‡å®šã—ã¾ã™ãŒã€ã“ã“ã«æ–‡å—åˆ—ã‚’æŒ‡å®šã™ã‚‹ã¨é€£æƒ³é…åˆ—ï¼ˆãƒãƒƒã‚·ãƒ¥ï¼‰ã¨ãªã‚Šã¾ã™ã€‚ä»¥ä¸‹ã®ã‚µãƒ³ãƒ—ãƒ«ã§ã¯é€£æƒ³é…åˆ—ï¼ˆãƒãƒƒã‚·ãƒ¥ï¼‰ã®ã‚ãƒ¼ã‚’é•·é‡ŽçœŒã€ãã®å€¤ã‚’å¡©å°»å¸‚ã¨ã—ã¦ã„ã¾ã™ã€‚å€¤ã®å¤‰ã‚ã‚Šã«æ·»å—ã«æ–‡å—åˆ—ã‚’æŒ‡å®šã™ã‚Œã°é€£æƒ³é…åˆ—ï¼ˆãƒãƒƒã‚·ãƒ¥ï¼‰ã®ã‚ãƒ¼ã«å¯¾å¿œã—ãŸå†…å®¹ã‚’å‚ç…§ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ä»¥ä¸‹ã®ã‚µãƒ³ãƒ—ãƒ«ã§ã¯ç”»é¢ã«ã¯å¡©å°»å¸‚ã¨è¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ï¼ˆã‚µãƒ³ãƒ—ãƒ«01ã‚’å®Ÿè¡Œã™ã‚‹ï¼‰ a = new Array(); a["é•·é‡ŽçœŒ"] = "å¡©å°»å¸‚"; document.write(a["é•·é‡ŽçœŒ"]); é€£æƒ³é…åˆ—ï¼ˆãƒãƒƒã‚·ãƒ¥ï¼‰ã¯é…åˆ—ãªã®ã§ã€ã»ã¼ç„¡åˆ¶é™ã«ã‚ãƒ¼ã‚’æŒ‡å®šã—å€¤ã‚’è¨å®šï¼å‚ç…§ã™ã‚‹äº‹ãŒã§ãã¾ã™ã€‚ä»¥ä¸‹ã®ã‚µãƒ³ãƒ—ãƒ«ã§ã¯2ã¤ã®ã‚ãƒ¼ã€å€¤ã‚’è¨å®šã—ã¦ã„ã¾ã™ã€‚ï¼ˆã‚µãƒ³ãƒ—ãƒ«02ã‚’å®Ÿè¡Œã™
fukudamasa09 2012/06/08
document

array

javaScript

é€£æƒ³é…åˆ—

ã¦ã¤ã¥ã|æŠ€è¡“

ï¼‘ã‚‚ã®ã”ã¨ç³»
ãƒªãƒ³ã‚¯
JavaScript ã®é…åˆ—ã¨é€£æƒ³é…åˆ—ã®é•ã„ - ITæˆ¦è¨˜
id:cheesepie:20070131:1170172709 æœ€è¿‘ã¯ã€ã“ã†ã„ã†é¢¨ã« JavaScript ã‚’å‹‰å¼·ã™ã‚‹äººãŒå¢—ãˆã¦ã„ã¦ã¨ã¦ã‚‚å¬‰ã—ã„ã§ã™ ï¼¾ï¼¾ id:cheesepie ã•ã‚“é ‘å¼µã£ã¦ãã ã•ã„ï¼ ã§ã€ã¡ã‚‡ã£ã¨é…åˆ—ã¨é€£æƒ³é…åˆ—ã®ä½¿ã„ã‹ãŸãŒé•ã†ã‚ˆã†ãªã®ã§ã€ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’æ›¸ã“ã†ã¨æ€ã„ã¾ã—ãŸã€‚ãŠã›ã£ã‹ã„ã ã£ãŸã‚‰ã™ã¿ã¾ã›ã‚“ï¼žï¼œ ï¼ ã‚„ã£ã±ã‚Šã€ã“ã®ã¸ã‚“ãŒ JavaScript ã®é›£ã—ã„ã¨ã“ã‚ã®ã²ã¨ã¤ãªã®ã ã‚ã†ã‹ã€‚ ã¨ã„ã†ã“ã¨ã§ã€ JavaScript ã®é…åˆ—ã¨é€£æƒ³é…åˆ—ã®é•ã„ ã„ã£ã¦ã¿ã‚ˆãŠãƒ¼ é€£æƒ³é…åˆ—ã¨ã¯ JavaScript ã§ã¯é€£æƒ³é…åˆ—ã¯ä¸€ç•ªã‚·ãƒ³ãƒ—ãƒ«ãªã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ã“ã¨ã§ã‚ã‚‹ã€‚ã¤ã¾ã‚Šã€ã™ã¹ã¦ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¯é€£æƒ³é…åˆ—ã§ã‚ã‚‹ã€‚ ä»¥ä¸‹ã®ã™ã¹ã¦ã®é€£æƒ³é…åˆ—ã¯ã¾ã£ãŸãåŒã˜ã‚‚ã®ã§ã‚ã‚‹ã€‚ // 1 var obj = { hoge: 'hoge' }; // 2 var obj = { 'hoge': 'h
fukudamasa09 2012/05/23
hoge

é…åˆ—

tips

array

è³‡æ–™

amachang

JavaScript

é€£æƒ³é…åˆ—

programming

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
No.17 VBAã§é€£æƒ³é…åˆ— ï½ž Scripting.Dictionary
VBAãªæ–¹ã«ã¯é€£æƒ³é…åˆ—ã¨ã„ã†ã®ã¯ãªã˜ã¿ã®ãªã„è¨€è‘‰ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚awkã«ã¯ã˜ã¾ã‚ŠPerlã‚„Javaã€ãƒŽãƒ¼ãƒ„(LotusScript)ã§ã‚‚ãƒªã‚¹ãƒˆã¨ã—ã¦å®Ÿè£…ã•ã‚Œã¦ã„ã‚‹ã‚‚ã®ã§ã™ã€‚é€šå¸¸ã®é…åˆ—ã®å ´åˆã¯æ•°å—ã‚’ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã—ã¦å€¤ã‚’æ ¼ç´ã—ã¾ã™ãŒã€é€£æƒ³é…åˆ—ã®å ´åˆã¯æ–‡å—åˆ—ã‚’ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ç®±ã‚’é…åˆ—ã¨ã™ã‚‹ã¨å€¤ã¯ä¸èº«ã€ãã‚Œãžã‚Œã®ç®±ã«åæœï¼ˆãƒ©ãƒ™ãƒ«ï¼‰ã‚’ä»˜ã‘ã‚‹ã“ã¨ãŒã§ãã‚‹ã®ã§å€¤ã‚’å–ã‚Šå‡ºã™ã¨ãã‚‚æ„Ÿè¦šçš„ã«ã‚ã‹ã‚Šã‚„ã™ã„ã§ã™ã‚ˆãã€‚ãã‚Œä»¥å¤–ã«ã‚‚ãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚Šã¾ã™ã€‚é€šå¸¸ã®é…åˆ—ã®å ´åˆã‚ã‚‰ã‹ã˜ã‚é ˜åŸŸã‚’ç¢ºä¿ã—ã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã™ãŒã€é€£æƒ³é…åˆ—ã®å ´åˆã¯ä¸è¦ã§é…åˆ—ãŒæº¢ã‚Œã‚‹ã“ã¨ã‚’æ°—ã«ã™ã‚‹å¿…è¦ãŒãªã„ã®ã§ã™ã€‚ Perlã§ã®è¨˜è¿°ä¾‹ $Result{'å±±ç”°å¤ªéƒŽ'} = 95; $Result{'éˆ´æœ¨æ¬¡éƒŽ'} = 78; $Result{'ç”°ä¸ä¸‰éƒŽ'} = 83; print $Result{'å±±ç”°å¤ªéƒŽ'}; Dictionaryã‚ªãƒ–
fukudamasa09 2011/11/15
VBA

perl

é€£æƒ³é…åˆ—

ãƒ‡ãƒ¼ã‚¿

ã‚µãƒ³ãƒ—ãƒ«

ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°

programming

excel

vba
ãƒªãƒ³ã‚¯
1