[B! excel] atomicmapã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

atomicmap id:atomicmap

excelã«é–¢ã™ã‚‹atomicmapã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (20)

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

é …ç›®è»¸ã‚’2æ®µã«ã—ãŸã‚°ãƒ©ãƒ•ã‚’ä½œæˆã™ã‚‹ï¼šã‚¨ã‚¯ã‚»ãƒ« Q&A(Tips)
ãƒ”ãƒœãƒƒãƒˆã‚°ãƒ©ãƒ•ã§é …ç›®è»¸ã‚’2æ®µã«ã—ãŸã‚°ãƒ©ãƒ•ã‚’ä½œæˆã™ã‚‹ã€€ã€€ã€€ã€€topã¸ æ—¥ä»˜ã‚’ã‚°ãƒ«ãƒ¼ãƒ—åŒ–ã—ãŸãƒ”ãƒœãƒƒãƒˆã‚°ãƒ©ãƒ•ã‚’ä½œæˆã™ã‚‹ã¨ä¸‹å›³ã®ã‚ˆã†ã«ã€é …ç›®è»¸ã®é …ç›®åãŒ2æ®µã§è¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã€Œæ—¥ä»˜ã€ã‚’é¸æŠžã—ã¦ã€ãƒ”ãƒœãƒƒãƒˆãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚¿ãƒ–ã§[ã‚°ãƒ«ãƒ¼ãƒ—ã®é¸æŠž]ã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ å˜ä½ã§ã€Œå¹´ã€ã¨ã€Œæœˆã€ã‚’é¸æŠžã—ã¾ã™ã€‚ ä¸‹å›³ã®ã‚ˆã†ã«ã€æ—¥ä»˜ã‚’ã€Œå¹´ã€ã¨ã€Œæ—¥ä»˜ã€ãŒè»¸ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«é…ç½®ã•ã‚Œã¾ã—ãŸã€‚ ãƒ”ãƒœãƒƒãƒˆãƒ†ãƒ¼ãƒ–ãƒ« ãƒ„ãƒ¼ãƒ«ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚¿ãƒ–ã§[ãƒ”ãƒœãƒƒãƒˆã‚°ãƒ©ãƒ•]ã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ æŠ˜ã‚Œç·šã‚°ãƒ©ãƒ•ã‚’é¸æŠžã™ã‚‹ã¨ä¸‹å›³ã®ã‚ˆã†ã«ã€é …ç›®è»¸ãŒ2æ®µã«ãªã£ãŸã‚°ãƒ©ãƒ•ãŒä½œæˆã•ã‚Œã¾ã—ãŸã€‚ ç¸¦æ£’ã‚°ãƒ©ãƒ•ã§ã‚‚åŒã˜ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ é€šå¸¸ã®ã‚°ãƒ©ãƒ•ã§é …ç›®è»¸ã‚’2æ®µã«ã—ãŸã‚°ãƒ©ãƒ•ã‚’ä½œæˆã™ã‚‹ã€€ã€€ã€€ã€€topã¸ å…ƒã®ãƒ‡ãƒ¼ã‚¿ãƒªã‚¹ãƒˆã®ä½œæˆãŒä¸€å®šã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã«ãªã£ã¦ã„ã‚‹ã¨ã€é€šå¸¸ã®ã‚°ãƒ©ãƒ•ã§ã‚‚åŒã˜ã‚ˆã†ã«é …ç›®è»¸ã‚’2æ®µã§è¡¨ç¤ºã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ä¸‹å›³ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ãƒªã‚¹ãƒˆã‚’ä½œæˆã—ã¾ã™ã€‚ B3:N
atomicmap 2018/05/15
excel
ãƒªãƒ³ã‚¯
Excelç®¡ç†ã®åº§å¸è¡¨ã‚’Leafletã§WebåŒ–ã—ãŸè©± - LINE ENGINEERING
! This post is also available in the following languages. è‹±èªž, éŸ“å›½èªž, ãƒ™ãƒˆãƒŠãƒ èªž ã“ã‚“ã«ã¡ã¯ã€LINEã®ITæ”¯æ´å®¤ã§ç¤¾å†…ã‚·ã‚¹ãƒ†ãƒ ã®é–‹ç™ºã¨é‹ç”¨ã‚’ã—ã¦ã„ã‚‹å²©æœˆã§ã™ã€‚ã“ã®è¨˜äº‹ã¯LINE Advent Calendar 2017ã®6æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ äººå“¡ã®å¢—åŠ ã«å¯¾å¿œã™ã‚‹ãŸã‚ã«ã€ä»Šå¹´ã®4æœˆã€LINEã¯JRæ–°å®¿ãƒŸãƒ©ã‚¤ãƒŠã‚¿ãƒ¯ãƒ¼ã«ç§»è»¢ã—ã¾ã—ãŸã€‚ç§»è»¢ã«ä¼´ã„ã€ITæ”¯æ´å®¤ã§ã¯ã„ãã¤ã‹ã®æ–°ã—ã„ç¤¾å†…ã‚·ã‚¹ãƒ†ãƒ ã‚’å°Žå…¥ã—ã¾ã—ãŸãŒã€ä»Šæ—¥ã¯ãã®1ã¤ã§ã‚ã‚‹ã€Œåº§å¸è¡¨ã€ã«ã¤ã„ã¦ãŠè©±ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ é–‹ç™ºã®ãã£ã‹ã‘ ç§»è»¢å‰ã€åº§å¸ã®ç®¡ç†ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«Excelã§è¡Œã‚ã‚Œã¦ã„ã¾ã—ãŸï¼ˆåå‰ã¯æ¶ˆã—ã¦ã„ã¾ã™ï¼‰ã€‚ â—¯â—¯ã•ã‚“ã®åº§å¸ã‚’èª¿ã¹ãŸã„ã¨æ€ã£ãŸã‚‰ã€Excelã‚‚ã—ãã¯å¤‰æ›ã•ã‚ŒãŸPDFã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã€ãƒ“ãƒ¥ãƒ¼ã‚¢ãƒ¼ã®æ¤œç´¢æ©Ÿèƒ½ã§åå‰ã‚’èª¿ã¹ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã—ãŸã€‚æã‚‰ãã‚ˆãã‚ã‚‹é‹ç”¨ã¨ã„ã†ã“
atomicmap 2017/12/06
excel
ãƒªãƒ³ã‚¯
æ˜¨æ—¥ã¾ã§JavaJavaã—ã¦ãŸäººãŒã„ããªã‚ŠExcelã®VBAã‚’å®Ÿè£…ã™ã‚‹ç¾½ç›®ã«ãªã£ãŸã¨ãã®ãŸã‚ã®ãƒ¡ãƒ¢ - Qiita
Excel ã¯æ»…ã³ã¬ï¼ Excel ã®åŠ›ã“ãæ—¥æœ¬ä¼æ¥ã®å¤¢ã ã‹ã‚‰ã ï¼ VBA å®Ÿè£…ã—ã¦ã¦å¦ã‚“ã ã“ã¨ã¨ã‹ã®ãƒ¡ãƒ¢ã€‚ Java Java ã—ã¦ãŸã‹ã¯ã‚ã¾ã‚Šé–¢ä¿‚ãªã„ã‹ã‚‚ã€‚ #ã‚¨ãƒ‡ã‚£ã‚¿ã®ä½¿ã„æ–¹ ##ã‚¨ãƒ‡ã‚£ã‚¿ã‚’è¡¨ç¤ºã™ã‚‹ Alt + F11 ã§ VB ã‚¨ãƒ‡ã‚£ã‚¿ã‚’è¡¨ç¤ºã§ãã‚‹ã€‚ ##ç’°å¢ƒè¨å®š ###èƒŒæ™¯è‰²ãƒ»ãƒ•ã‚©ãƒ³ãƒˆã‚’èª¿æ•´ã™ã‚‹ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ç™½èƒŒæ™¯ã¨ã‹æ°—ãŒç‹‚ã†ã®ã§ã€æš—ã„è‰²ã«ã™ã‚‹ã€‚ ã€Œãƒ„ãƒ¼ãƒ«ã€â†’ã€Œã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€ã‚’é¸æŠžã—ã€ã€Œã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ã®è¨å®šã€ã‚¿ãƒ–ã‚’é–‹ãã€‚ ã€Œã‚³ãƒ¼ãƒ‰ã®è¡¨ç¤ºè‰²ã€ã‚’é¸æŠžã—ã¦ã€ã€ŒèƒŒæ™¯ã€ã®è‰²ã‚’é¸æŠžã™ã‚‹ã€‚ ã¤ã„ã§ã«ãƒ•ã‚©ãƒ³ãƒˆã‚‚è¦‹ã‚„ã™ã„ã‚„ã¤ã«å¤‰æ›´ã™ã‚‹ã€‚ ã“ã‚Œã ã‘ã§é–‹ç™ºåŠ¹çŽ‡ãŒï¼•å‰²å¢—ã—ã«ãªã‚‹ã€‚ ###ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ ####ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã‚’è¡¨ç¤ºã™ã‚‹ ã„ã‚ã‚†ã‚‹ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã«å½“ãŸã‚‹ã®ãŒã€__ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦__ã¨å‘¼ã°ã‚Œã‚‹ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã€‚ Ctrl + G ã§è¡¨ç¤ºã•ã‚Œã‚‹ã€‚ ####ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã«å‡º
atomicmap 2016/04/26
excel

VBA
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«ï¼’ï¼ï¼‘ï¼ã®å›³ã®æ›¸å¼è¨å®šã§ã€Œå¡—ã‚Šã¤ã¶ã—ï¼ˆãƒ‘ã‚¿ãƒ¼ãƒ³ï¼‰ã€ã®é€éŽæ€§ã®æ©Ÿèƒ½ã¯ç„¡ããªã£ãŸã®ã§ã—ã‚‡ã†ã‹ï¼Ÿã€Œå¡—ã‚Šã¤ã¶ã—ï¼ˆå˜è‰²ï¼‰ã€ã®é€éŽæ€§ã¯ã§... - Yahoo!çŸ¥æµè¢‹
ã‚¨ã‚¯ã‚»ãƒ«ï¼’ï¼ï¼‘ï¼ã®å›³ã®æ›¸å¼è¨å®šã§ã€Œå¡—ã‚Šã¤ã¶ã—ï¼ˆãƒ‘ã‚¿ãƒ¼ãƒ³ï¼‰ã€ã®é€éŽæ€§ã®æ©Ÿèƒ½ã¯ç„¡ããªã£ãŸã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã€Œå¡—ã‚Šã¤ã¶ã—ï¼ˆå˜è‰²ï¼‰ã€ã®é€éŽæ€§ã¯ã§ãã‚‹ã®ã§ã™ãŒãƒ»ãƒ»ãƒ» ã‚¨ã‚¯ã‚»ãƒ«ï¼’ï¼ï¼‘ï¼ã®å›³ã®æ›¸å¼è¨å®šã§ã€Œå¡—ã‚Šã¤ã¶ã—ï¼ˆãƒ‘ã‚¿ãƒ¼ãƒ³ï¼‰ã€ã®é€éŽæ€§ã®æ©Ÿèƒ½ã¯ç„¡ããªã£ãŸã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã€Œå¡—ã‚Šã¤ã¶ã—ï¼ˆå˜è‰²ï¼‰ã€ã®é€éŽæ€§ã¯ã§ãã‚‹ã®ã§ã™ãŒãƒ»ãƒ»ãƒ» è¡Œã„ãŸã„ä½œæ¥ã¨ã—ã¦ã¯ã€å›³ï¼ˆå†™çœŸï¼‰ãªã©ã®ä¸Šã«ã€ãƒ•ãƒªãƒ¼ãƒ•ã‚©ãƒ¼ãƒ ã§ãƒ‘ã‚¿ãƒ¼ãƒ³ã®æ–œç·šã‚’é¸æŠžã—ã€èƒŒæ™¯ã‚’åŠé€ã«è¨å®šã—ãŸã„ã€‚
atomicmap 2015/12/01
excel
ãƒªãƒ³ã‚¯
ï¼‘å¹´å‰ã«è»¢è·ã—ã¾ã—ãŸ
é€€è·ã—ã¾ã—ãŸã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã„ã¦ã‹ã‚‰ã€æ—©ãã‚‚ï¼‘å¹´ãŒçµŒéŽã—ã¾ã—ãŸã€‚ã›ã£ã‹ããªã®ã§ã‚†ã‚‹ãƒ¼ãï¼‘å¹´ã‚’æŒ¯ã‚Šè¿”ã£ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã„ã¾ã¾ã§ã‚ã‚‰ã™ã˜ ï¼‘å¹´å‰ã€ã”ãå°è¦æ¨¡ã® WEB å—è¨—é–‹ç™ºä¼šç¤¾ã‹ã‚‰ã€ä¸è¦æ¨¡ã®åºƒå‘Šä»£ç†åº—ã¸è»¢è·ã—ã¾ã—ãŸã€‚ è»¢è·å…ˆã§ã¯ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç¤¾å“¡ã¯ã‚ã—ã ã‘ã§ã™ã€‚ è»¢è·ã—ã¦å¤‰ã‚ã£ãŸã“ã¨ è¤‡æ•°ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’æŽ›ã‘æŒã¡ã—ãªãã¦æ¸ˆã‚€ã‚ˆã†ã«ãªã£ãŸã®ã§ã€æ¯”è¼ƒçš„ã€ç›®ã®å‰ã®ä»•äº‹ã«é›†ä¸ã—ã‚„ã™ããªã‚Šã¾ã—ãŸã€‚ é›»è©±ã‚’å–ã‚‰ãªãã¦è‰¯ããªã£ãŸã®ã§ã€æ¯”è¼ƒçš„ã€ç›®ã®å‰ã®ä»•äº‹ã«é›†ä¸ã—ã‚„ã™ããªã‚Šã¾ã—ãŸã€‚ è·å ´ãŒåºƒãã¦æ¸…æ½”ã«ãªã‚Šã¾ã—ãŸã€‚ã—ã‹ã‚‚ï¼–æœˆã«æ–°ç¯‰ãƒ“ãƒ«ã«å¼•ã£è¶Šã—ã¦ã•ã‚‰ã«å¿«é©ã«ãªã£ãŸã®ã§ã€æ¯”è¼ƒçš„ã€ç›®ã®å‰ã®ä»•äº‹ã«é›†ä¸ã—ã‚„ã™ããªã‚Šã¾ã—ãŸã€‚ ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«é–¢ã™ã‚‹ã—ãŒã‚‰ã¿ãŒï¼ãªã®ã§ã€å”¯ä¸€ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹ã‚ã—ã®è£é‡ã§å¤§ä½“ã®ã“ã¨ã¯æ±ºã‚ã‚‰ã‚Œã¾ã™ã€‚æ¯”è¼ƒçš„ã€ç›®ã®å‰ã®ä»•äº‹ã«é›†ä¸ã—ã‚„ã™ããªã‚Šã¾ã—ãŸã€‚ ä½•ã‹æ–°ã—ã„æ©Ÿèƒ½ã‚’ä½œã‚‹ã¨ãã«ã€(æ‰“ç®—çš„ãª
atomicmap 2014/08/02
rails

github

excel

è»¢è·

ä»•äº‹

it
ãƒªãƒ³ã‚¯
axlsx (gem) ã§ xlsx ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ - Rails ã¤ã¾ã¿ãã„
Ruby on Rails v3.2.11 axlsx v1.3.4 ã„ã„åŠ æ¸›ãã‚ãã‚ Excel2003 å½¢å¼ (.xls) ã§å‡ºåŠ›ã—ç¶šã‘ã‚‹ç†ç”±ãŒãªããªã£ã¦ãã¦ã—ã¾ã£ãŸã®ã§(^_^;ã€ã‚ˆã†ã‚„ãé‡ã„è…°ã‚’ã‚ã’ã¦ Excel2007 å½¢å¼ (.xlsx) ã§å‡ºåŠ›ã«ç§»è¡Œã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ä½¿ãˆãã†ãªãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¯ãªã„ã‹ã¨ gem ã‚’æŽ¢ã—ã¦ã¿ã¾ã—ãŸã€‚ã¨ã‚Šã‚ãˆãšç›®ã«ã¤ã„ãŸä»¥ä¸‹ã®3ã¤ã‚’ã•ã‚ã£ã¦ã¿ã¾ã—ãŸã€‚ roo acts_as_xlsx axlsx 3ã¤ã‚’è©¦ã—ã¦ã¿ãŸå°è±¡ roo ã¯ xls ã¨ xlsx ã®ä¸¡å¯¾å¿œã¨ã„ã†è§¦ã‚Œè¾¼ã¿ã§ã€No.1å€™è£œã‹ï¼ï¼Ÿã¨æ€ã£ãŸã‚“ã§ã™ãŒã€xlséƒ¨ã¯ spreadsheet ã«ä¸¸æŠ•ã’ã®ã‚ˆã†ã§ã€xlséƒ¨ã¨xlsxéƒ¨ã¨ã§æ›¸ãæ–¹ã®ä½œæ³•ãŒã¾ã‚‹ã§é•ã£ã¦ã€åˆ¥ã€…ã®ã‚‚ã®ã‚’ä½¿ã£ã¦ã‚‚å¤§ã—ã¦å¤‰ã‚ã‚‰ãªã„â€¦ ã•ã‚‰ã«ç‹¬è‡ªã«ä½œæˆã•ã‚ŒãŸxlsxéƒ¨ã¯ã€cell, row, column ã¨ã„ã£ãŸã‚¯ãƒ©ã‚¹ãŒãªãå¸¸ã«
atomicmap 2013/05/26
excel

ruby
ãƒªãƒ³ã‚¯
è¤‡æ•°ã®å ´æ‰€ã‚’åœ°å›³ã«è¡¨ç¤º | BatchGeo
ï¼ˆè¦‹å‡ºã—éƒ¨åˆ†ã‚’å«ã‚ã‚‹ã“ã¨ã‚’å¿˜ã‚Œãšã« - ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆãƒ»ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚‚ãŠè©¦ã—ã„ãŸã ã‘ã¾ã™ã€‚ã¾ãŸã€Œä»Šã™ããƒžãƒƒãƒ—ã‚’ä½œæˆã™ã‚‹ã€ã‚’æŠ¼ã—ã¦ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ã‚’ä½¿ã£ã¦è©¦ã™ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ï¼‰ Done: columns, rows - scroll down to Validate & Set Options
atomicmap 2012/11/10
excel

google_maps

geo
ãƒªãƒ³ã‚¯
Excelã¨PowerPointã®ç¶ºéº—ãªã‚°ãƒ©ãƒ•ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãŒç„¡æ–™ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã‚µã‚¤ãƒˆã€ŒChart Chooserã€ | ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚«ãƒ¼ãƒ»ã‚¸ãƒ£ãƒ‘ãƒ³
ã€ŒChart Chooserã€ã¯Excelã¨PowerPointï¼ˆãƒ‘ãƒ¯ãƒï¼‰ã®ã‚ãƒ¬ã‚¤ãªã‚°ãƒ©ãƒ•ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãŒç„¡æ–™ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã‚µã‚¤ãƒˆã§ã™ã€‚Excelã®ã‚ãƒ¬ã‚¤ãªãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãŒç„¡æ–™ã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã‚ˆï¼ ç›®çš„åˆ¥ã«æŽ¢ã™ã“ã¨ãŒã§ãã¾ã™ã€‚ ä»¥ä¸‹ã«ä½¿ã£ã¦ã¿ãŸæ§˜åã‚’è¼‰ã›ã¦ãŠãã¾ã™ã€‚ ã¾ãšChart Chooserã¸ã‚¢ã‚¯ã‚»ã‚¹ã—ã¾ã—ã‚‡ã†ã€‚ ã“ã®ã‚ˆã†ã«ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚Excelã¨ãƒ‘ãƒ¯ãƒã§åˆ‡ã‚Šæ›¿ãˆã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãŒã“ã¡ã‚‰ã€‚ã‚ã¨ã¯è‡ªç”±ã«ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã™ã‚Œã°OKã§ã™ã€‚Excelã‚„ãƒ‘ãƒ¯ãƒã®ã‚°ãƒ©ãƒ•ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚’ãŠæŽ¢ã—ã®æ–¹ã¯ãœã²ãŠè©¦ã—ãã ã•ã„ã€‚
atomicmap 2012/08/04
è‰²ã¨ã‹ã€ç½«ç·šã‚’ç¶ºéº—ã«æŠœã„ãŸã‚Šã ã‚ã†ã‹

excel
ãƒªãƒ³ã‚¯
rubyã‹ã‚‰Excelã®ã€Œ.xlsxã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã‚€ | rakkyooã®å‚™å¿˜éŒ²
rubyã§ï¼Œexcel2007ä»¥é™ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã©ã†ã—ã¦ã‚‚èªã¿è¾¼ã¿ãŸã‹ã£ãŸã®ã§æŽ¢ã—ã¦ã„ãŸã®ã§ã™ãŒï¼Œã€Œrooã€ã§ã§ãã‚‹ã¿ãŸã„ã§ã™ãï¼Ž RubyForge: roo â€“ parse spreadsheets with Ruby: Project Info ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯gemçµŒç”±ã§ç°¡å˜ï¼Ž
atomicmap 2012/07/03
excel

ruby
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ã‚¹ãƒˆãƒ©ã‚¯ã‚¿ãƒ¼ã®ãƒã‚¿å¸³
atomicmap 2012/06/01
excel
ãƒªãƒ³ã‚¯
æŽ²è¼‰çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› : å¯Œå£«é€š
ã”åˆ©ç”¨ã„ãŸã ãã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚æœ¬ãƒšãƒ¼ã‚¸ã¯æŽ²è¼‰ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ PCã‚¯ãƒ©ã‚¹ã‚¿ ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ Excelé«˜é€ŸåŒ–ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ é–¢é€£æƒ…å ±ã«ã¤ã„ã¦ã¯ã€ä»¥ä¸‹ã®ãƒšãƒ¼ã‚¸ã‚’ã”å‚ç…§ãã ã•ã„ã€‚ FUJITSU Server PRIMERGY PCã‚¯ãƒ©ã‚¹ã‚¿
atomicmap 2012/03/16
excel

hpc

parallel_computing
ãƒªãƒ³ã‚¯
ä½æ‰€ã®å…¥åŠ›ã§è¤‡æ•°ã®å ´æ‰€ã‚’åœ°å›³ã«è¡¨ç¤ºã€€-ã€€batchgeocode.com
ï¼ˆè¦‹å‡ºã—éƒ¨åˆ†ã‚’å«ã‚ã‚‹ã“ã¨ã‚’å¿˜ã‚Œãšã« - ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆãƒ»ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚‚ãŠè©¦ã—ã„ãŸã ã‘ã¾ã™ã€‚ã¾ãŸã€Œä»Šã™ããƒžãƒƒãƒ—ã‚’ä½œæˆã™ã‚‹ã€ã‚’æŠ¼ã—ã¦ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ã‚’ä½¿ã£ã¦è©¦ã™ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ï¼‰ Done: columns, rows - scroll down to Validate & Set Options
atomicmap 2010/12/07
excel

google_maps
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
atomicmap 2009/06/14
excel
ãƒªãƒ³ã‚¯
ç¬¬97å›ž ã“ã‚Œã ã‘ã¯æŠ¼ã•ãˆã¦ãŠããŸã„ã‚¨ã‚¯ã‚»ãƒ«ã®çŸ¥è˜ã€€ã€€å‰ç·¨ - bingo_nakanishiã®ä»–è¨€èªžå‡ºèº«è€…ã®ãŸã‚ã®Perlå…¥é–€
æ–°ç¤¾ä¼šäººã«ãªã£ã¦ã€æ¥å‹™ã‚’ä¸Žãˆã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã¨ ã‚¨ã‚¯ã‚»ãƒ«ã‚’ã‚¬ã‚·ã‚¬ã‚·ä½¿ã£ã¦ã„ãã“ã¨ã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã¯ã€ã“ã‚Œã ã‘ã¯æŠ¼ã•ãˆã¦ãŠããŸã„ã‚¨ã‚¯ã‚»ãƒ«ã®çŸ¥è˜ã§ã™ã€‚ ãã®1.ã€€çµ¶å¯¾å‚ç…§ã€€ã¨ã€€ç›¸å¯¾å‚ç…§ çµ¶å¯¾å‚ç…§ã¨ç›¸å¯¾å‚ç…§ã‚’ç†è§£ã™ã‚‹ã«ã¯ã€ ä¹ä¹ã®è¡¨ã‚’ã¤ãã£ã¦ã¿ã‚‹ã¨è‰¯ã„ã§ã—ã‚‡ã†ã€‚ 1*1 = 1 ... 9*9 = 81ã¨å°å¦ç”Ÿã®ã¨ãã«å¿…æ»ã«è¦šãˆãŸã‚¢ãƒ¬ã§ã™ã€‚ å³ä¸Šã®ã€æ•°å¼ãƒãƒ¼ã«æ³¨ç›®ã—ã¦ãã ã•ã„ã€‚ =C$2*$B3ã¨ãªã£ã¦ã„ã¾ã™ã€‚$ã¯ã€å›ºå®šã‚’ã‚ã‚‰ã‚ã—ã¦ã„ã¾ã™ã€‚ ãªã‚“ã§ã€€$ ãªã®?? ã€ŒSã«ç¸¦æ£’ãŒåˆºã•ã£ã¦ã€å›ºå®šã—ã¦ã„ã‚‹ã¿ãŸã„ã«è¦‹ãˆã‚‹ã‹ã‚‰$ã€ ã¨ã€ç§ã¯å¼·å¼•ã«è¦šãˆã¦ã¿ã¾ã—ãŸã€‚ ã“ã®$ãŒä½¿ã„ã“ãªã›ã‚‹ã¨ã‚¨ã‚¯ã‚»ãƒ«ã‚’ä½¿ã†ã®ãŒæ¥½ã«ãªã‚Šã¾ã™ã€‚ çµ¶å¯¾å‚ç…§ã¨ã¯ ã‚»ãƒ«ã‚’ãƒ•ã‚£ãƒ«ã§é¸æŠžã—ã¦ã‚³ãƒ”ãƒ¼ã—ã¦ã‚‚ã€åŒã˜å ´æ‰€ã‚’æŒ‡ã—ã¦ã„ã‚‹ã“ã¨ ç›¸å¯¾å‚ç…§ã¨ã¯ ã‚»ãƒ«ã‚’ãƒ•ã‚£ãƒ«ã§é¸æŠžã—ã¦ã‚³ãƒ”ãƒ¼ã™ã‚‹ã¨ã€æŒ‡ã—ã¦ã„ã‚‹ã¨ã“ã‚ãŒå¤‰ã‚ã£ã¡ã‚ƒã†ã“ã¨ï¼ˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ã‚¿ãƒ«ã€ãƒ‡ã‚¯
atomicmap 2009/05/21
excel
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹5ã¤ã®ç°¡å˜ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ | ã‚³ãƒªã‚¹
Chandoo.orgã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‹ã‚‰ã€æ¡ä»¶ä»˜ãæ›¸å¼ã‚’åˆ©ç”¨ã—ã¦ã€ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹5ã¤ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ Learn Cool Microsoft Excel Conditional Formatting Tricks ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’ãƒã‚¤ãƒ©ã‚¤ãƒˆ æ¡ä»¶ä»˜ãæ›¸å¼ã‚’ä½¿ç”¨ã—ãŸã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆ ã‚»ãƒ«å†…ã«é…ç½®ã™ã‚‹ã‚°ãƒ©ãƒ• ãƒŸã‚¹ã‚„ã‚¨ãƒ©ãƒ¼ãƒ»ãƒ‡ãƒ¼ã‚¿æ¬ è½ãªã©ã®ãƒã‚¤ãƒ©ã‚¤ãƒˆè¡¨ç¤º ç›´æ„Ÿçš„ã«æŠŠæ¡ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ†ãƒ¼ãƒ–ãƒ« [ad#ad-2] ã‚¨ã‚¯ã‚»ãƒ«ãƒ‡ãƒ¼ã‚¿ã¯ã€Chandoo.orgã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®ä¸€ç•ªä¸‹ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’ãƒã‚¤ãƒ©ã‚¤ãƒˆ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹ãŸã‚ã«ã€æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’äº¤äº’ã«ãƒã‚¤ãƒ©ã‚¤ãƒˆè¡¨ç¤ºã«ã—ã¾ã™ã€‚ ãƒã‚¤ãƒ©ã‚¤ãƒˆã«ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«å…¨ä½“ã‚’é¸æŠžã—ã¾ã™ã€‚ ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚ˆã‚Šã€[æ›¸å¼] - [æ¡ä»¶ä»˜ãæ›¸å¼] ã‚’é¸æŠžã€‚ ã€Œæ•°å¼ã€ã‚’é¸æŠžã—ã€ã€Œ=MOD(ROW(),2)=0ã€ã‚’å…¥åŠ›ã—
atomicmap 2008/10/24
excel
ãƒªãƒ³ã‚¯
Excelãƒ¬ã‚¬ã‚·ãƒ¼å†ç”Ÿè¨ˆç”»ï¼š1ä¸‡äººãŒä½¿ã£ãŸâ€œExcelã®ãŠåŒ–ã‘â€ï¼šITpro
Excelã®æ´»ç”¨ã§ã€å¤šãã®ç¾å ´ã¯ç”Ÿç”£æ€§ã®å‘ä¸Šã¨ã„ã†æžœå®Ÿã‚’æ‰‹ã«ã—ãŸã€‚ã—ã‹ã—ãƒ‡ãƒ¼ã‚¿é‡ã‚„ãƒ¦ãƒ¼ã‚¶ãƒ¼æ•°ã®å¢—å¤§ãªã©ã€å–ã‚Šçµ„ã¿å§‹ã‚ãŸå½“åˆã¨å‰ææ¡ä»¶ãŒå¤§ããå¤‰ã‚ã‚‹ã¨é‹ç”¨é¢ã§å£ã«çªãå½“ãŸã£ã¦ã—ã¾ã†ã€‚æ—¥ç”£è‡ªå‹•è»Šã¨ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã¯ãƒ¦ãƒ¼ã‚¶ãƒ¼ç’°å¢ƒã®å¤‰åŒ–ã‚’æœ€å°é™ã«æŠ‘ãˆãªãŒã‚‰ã€ãã†ã—ãŸå£ã‚’å–ã‚Šé™¤ã„ãŸã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã¿ã‚Œã° â€œæ¥½â€ã«åŠ‡çš„ãªç”Ÿç”£æ€§å‘ä¸Šã‚’æžœãŸã—ãŸã‚ã‘ã ã€‚ Excelã®â€œåŒ–ã‘ç‰©â€ãŒé™ç•Œã« ã€Œã‚‚ã¯ã‚„é™ç•Œã€‚Excelã®åŒ–ã‘ç‰©ã«æˆé•·ã—ã¦ã—ã¾ã£ãŸã€ã€‚æ—¥ç”£ ã‚°ãƒãƒ¼ãƒãƒ«æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ æœ¬éƒ¨ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã‚·ã‚¹ãƒ†ãƒ éƒ¨ã®ç¥žæˆ¸æ”¿ä¸€éƒŽä¸»æ‹…ã¯ã“ã†èªžã‚‹ã€‚ åŒç¤¾ã®è¨è¨ˆã‹ã‚‰é–‹ç™ºè©¦ä½œå·¥ç¨‹ã§ã¯ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒExcelã‚’ä¸€æ–‰ã«æ“ä½œã™ã‚‹ã€‚è¨è¨ˆãŒæ±ºã¾ã£ã¦ã‹ã‚‰å¸‚å ´æŠ•å…¥ã¾ã§ã®æœŸé–“ã‚’å¤§å¹…ã«çŸç¸®ã™ã‚‹å…¨ç¤¾ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã€ŒV-3Pã€ã®ãŸã‚ã ã€‚ ã¾ãšãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãƒžãƒã‚¸ãƒ£ãŒå·¨å¤§ãªãƒžã‚¹ã‚¿ãƒ¼ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ™ãƒ¼ã‚¹ã«é¨’éŸ³ãƒ»æŒ¯å‹•ã‚„è¡çªã€å‹•åŠ›ã¨ã„ã£ãŸæ€§èƒ½å˜ä½ã«Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã€‚æ€§èƒ½è¨
atomicmap 2008/08/26
excel
ãƒªãƒ³ã‚¯
L'eclat des jours(2007-12-28)
_ Ruby on Windows ä»¥å‰æ›¸å½±ã ã‘å¼µã£ãŸRuby on Windowsã§ã™ãŒã€cuzicã•ã‚“ã‹ã‚‰ã€çŒ®æœ¬ã—ã¦ã„ãŸã ãã¾ã—ãŸã€‚ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ Rubyist Magazineå‡ºå¼µç‰ˆ Ruby on Windows(cuzic) ã“ã‚Œã¯è‰¯ã„ã§ã™ã€‚ ã”å˜çŸ¥ã¨ã„ã†ã‹ã€ä½¿ã£ã¦ã„ã‚‹ã¨æ€ã„ã¾ã™ãŒã€Excelã¯ç›¸å¤‰ã‚ã‚‰ãšç¾å½¹ã§ã€OLEã¨ã„ã†ã‹COMã‚’ä½¿ã£ã¦å¤–éƒ¨ãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰æ“ä½œã§ãã‚‹ã‚ã‘ã§ã™ã€‚ ã§ã€å‰¯é¡Œã®ã€ŒRubyã§ä¸¸æŠ•ã’ï¼ ãƒ«ãƒ¼ãƒãƒ³ãƒ¯ãƒ¼ã‚¯ã€ãŒåŠ¹ã„ã¦ãã‚‹ã¨ã€‚ï¼ˆã€ŒRubyã«ã€ã˜ã‚ƒãªãã¦ã€Rubyã®ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ä½œã‚‹ã®ã¯ã“ã£ã¡ãªã®ã§ã€ã€ŒRubyã§ã€ãªã‚ã‘ã§ã™ãï¼‰ COMï¼ˆWin32OLEï¼‰ã®èª¬æ˜Žã¨ã—ã¦Excelã€ADOã€Outlookã€IEã€WSHã€WMIã€iTunesãŒå–ã‚Šä¸Šã’ã‚‰ã‚Œã¦ã„ã¦ã€ã‚ˆãã¾ã¨ã¾ã£ã¦ã„ã¾ã™ã€‚å„ç« ã¯ã€èª²é¡ŒãŒã‚ã£ã¦ã€ãã®è§£æ±ºç–ã¨ã—ã¦Rubyã‚’åˆ©ç”¨ã—ãŸãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ä½œæˆã—
atomicmap 2007/12/28
ruby

excel
ãƒªãƒ³ã‚¯
RubyScriptTemplate
ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ãã¨ãã®æœ€åˆã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚’ã„ãã¤ã‹ãƒ¡ãƒ¢ ã‚¹ã‚¯ãƒªãƒ—ãƒˆã®å®Ÿè¡Œ if $0 == __FILE__ # å®Ÿè¡Œ end ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ›´æ–°ã™ã‚‹ require 'fileutils' require 'tempfile' def update(name) tf = Tempfile.new("foo") File.open(name, 'r').each do |line| # tf.puts(line) end tf.close File.rename(name, name + '.bak') FileUtils.copy_file(tf.path, name) end Excelã‚·ãƒ¼ãƒˆã‚’å·¡å›žã™ã‚‹ require 'win32ole' def read_sheets(file) begin excel = WIN32OLE.new('Excel.Application') excel
atomicmap 2007/12/28
ruby

excel
ãƒªãƒ³ã‚¯
Excel ãƒ•ã‚¡ã‚¤ãƒ«ã®å†…å®¹ã‚’ Ruby ã‚’ä½¿ã£ã¦é«˜é€Ÿå–å¾—ã™ã‚‹ - Rails ã§è¡Œã“ã†ï¼ - Ruby on Rails ã‚’å¦ã¶
Rails ã«ã¯ç›´æŽ¥é–¢ä¿‚ãªã„å°ãƒã‚¿ã‚’ã²ã¨ã¤ã€‚ Excel ã®ä¸èº«ã‚’ Ruby ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰å‚ç…§ã—ãŸã„ã“ã¨ãŒã‚ã‚‹ã€‚ã“ã‚Œã¯ã€æ¬¡ã®ã‚ˆã†ã«å®Ÿç¾ã§ãã‚‹ã€‚win32/clipboard ã¨ win32ole ã¨ã„ã†2ã¤ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä½¿ã†ã€‚ require 'rubygems' require "win32/clipboard" require 'win32ole' excel = WIN32OLE.new('Excel.Application') excel.visible = false excel.displayAlerts = false excel.workbooks.open 'filename' => 'C:\test1.xls' workbook = excel.workbooks(1) sheet = workbook.sheets(1) sheet.select excel.ce
atomicmap 2007/10/06
ruby

excel
ãƒªãƒ³ã‚¯
i d e a * i d e a - Excelã§ã‚¦ãƒ«ãƒˆãƒ©ã‚·ãƒ³ãƒ—ãƒ«ãªã‚°ãƒ©ãƒ•ã‚’ä½œæˆã™ã‚‹æ–¹æ³•
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
atomicmap 2006/08/13
excel
ãƒªãƒ³ã‚¯
1