[B! Excel] THALã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

THAL id:THAL

Excelã«é–¢ã™ã‚‹THALã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{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ã€ã®æ”¹å–„æ¡ˆãŒå…¬é–‹ ï½žã‚ã‹ã‚“ãƒ¤ãƒ„â†’ãˆãˆãƒ¤ãƒ„ã®ä¾‹ãŒã‚ã‹ã‚Šã‚„ã™ãã€ä¸€èˆ¬å¸‚æ°‘ã«ã‚‚çµæ§‹å‚è€ƒã«ãªã‚‹ï¼â€œæ©Ÿæ¢°ã«ã‚‚èªã‚ã‚‹ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆâ€ã‚’å¿ƒæŽ›ã‘ã‚ˆã†ã€ã‚„ã˜ã†ã¾ã®æœã€‘
THAL 2020/11/26
è‰¯ã„

Excel

ãƒ“ã‚¸ãƒã‚¹
ãƒªãƒ³ã‚¯
ã€ŒExcelä¸Šã§å‹•ããƒ‰ãƒ©ãƒ ãƒžã‚·ãƒ³ã€ã‚’ä½œæˆã—ãŸçŒ›è€…ãŒç™»å ´ã™ã‚‹
MicrosoftãŒé–‹ç™ºãƒ»è²©å£²ã™ã‚‹å®šç•ªã®è¡¨è¨ˆç®—ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã‚ã‚‹Excelã¯ã€é€šå¸¸ã®è¡¨è¨ˆç®—ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¨ã—ã¦ä½¿ã‚ã‚Œã‚‹ã ã‘ã§ãªãã€æ™‚ã«ã¯ãŠçµµã‹ãã‚„ã‚²ãƒ¼ãƒ ãªã©ã«ã‚‚åˆ©ç”¨ã•ã‚Œã¾ã™ã€‚ãã‚“ãªExcelã‚’ä½¿ã£ã¦ã€Œãƒ‰ãƒ©ãƒ ãƒžã‚·ãƒ³ã€ã‚’ä½œæˆã—ãŸçŒ›è€…ãŒç™»å ´ã€å®Ÿéš›ã«Excelã§ãƒªã‚ºãƒ ã‚’åˆ»ã‚€æ§˜åã‚’ãƒ ãƒ¼ãƒ“ãƒ¼ã§å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ I made an actual Drum Machine in Excel - YouTube ç”»é¢ã«è¡¨ç¤ºã•ã‚ŒãŸExcelã‚·ãƒ¼ãƒˆã«ã¯ã€è¡¨ã®ã‚ˆã†ãªã‚‚ã®ãŒä½œæˆã•ã‚Œã¦ã„ã¾ã™ã€‚ è¡¨ã®ä¸Šéƒ¨ã«ã‚ã‚‹ã€ŒPlay Sequenceã€ã‚’ã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨â€¦â€¦ ãƒªã‚ºãƒŸã‚«ãƒ«ãªæ‰“ã¡è¾¼ã¿ã®ãƒ‰ãƒ©ãƒ ãŒæµã‚Œå§‹ã‚ã¾ã—ãŸã€‚ã‚ˆãè¦‹ã‚‹ã¨ã€è¡¨ã®ä¸Šéƒ¨ã§é’ã„ãƒ–ãƒãƒƒã‚¯ãŒå·¦ã‹ã‚‰å³ã¸æµã‚Œã¦ãŠã‚Šã€ãƒ–ãƒãƒƒã‚¯ç›´ä¸‹ã®è¡¨ã«ç¤ºã•ã‚Œã¦ã„ã‚‹é€šã‚Šã«éŸ³ãŒé³´ã£ã¦ã„ã‚‹æ¨¡æ§˜ã€‚ ãƒ‰ãƒ©ãƒ ã®éŸ³ã ã‘ã§ã¯ãªãã€åŒã˜ãƒªã‚ºãƒ éšŠã¨ã—ã¦ãƒ™ãƒ¼ã‚¹ã®éŸ³ã‚‚æ¼”å¥ã§ãã‚‹ã‚ˆã†ã§ã™ã€‚ ã“ã®ã€ŒExcelä¸Šã§æ“ä½œã§
THAL 2019/11/08
Excelã¯ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ

Excel

DTM
ãƒªãƒ³ã‚¯
Excelã§ä¸€ç•ªã€Œãˆã€ãã‚“ãªã“ã¨ã§ãã‚‹ã®!?ã€ã£ã¦è£æŠ€æ›¸ã„ãŸã‚„ã¤ãŒå„ªå‹ : BIPãƒ–ãƒã‚°
1 ä»¥ä¸‹ã€5ã¡ã‚ƒã‚“ãã‚‹ã‹ã‚‰VIPãŒãŠé€ã‚Šã—ã¾ã™ 2019/04/05(é‡‘) 21:42:28.036 ID:2VnTE0fLa æ•°å¼ã®ä¸€éƒ¨ã‚’ã‚»ãƒ«å‚ç…§ã™ã‚‹ ä¾‹ãˆã°ã€VLOOKUP(æ¤œç´¢å€¤,æ¤œç´¢ç¯„å›²,åˆ—ç•ªå·)ã®æ¤œç´¢ç¯„å›²ã‚’ ã©ã“ã‹åˆ¥ã®ã‚»ãƒ«ã«ã€Œ$A$2:$K$110ã€ã¿ãŸã„ã«å…¥åŠ›ã—ã¨ã„ã¦å‚ç…§ã•ã›ã‚‹ æ¤œç´¢ç¯„å›²ãŒå¤‰ã‚ã£ãŸã‚‰ã€ãã®ã‚»ãƒ«ã‚’æ‰“ã¡å¤‰ãˆã‚‹ã ã‘ã§ã€ ç›´æŽ¥ã€æ•°å¼ã‚’æ›¸ãæ›ãˆã‚‹æ‰‹é–“ã‚’æ¸›ã‚‰ã›ã‚‹
THAL 2019/04/07
ã‚¨ã‚¯ã‚»ãƒ«ã§ä»•æ§˜æ›¸ã‚’æ›¸ãã®ã¯ã¾ã ãƒžã‚·ã§ã€VBAã§ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã™ã‚‹ã¾ã§ã‚ã‚‹ãžã€‚ã¤ã¾ã‚Šã€ä½•ã§ã‚‚ã§ãã‚‹ã€‚

Excel
ãƒªãƒ³ã‚¯
Markdown ã§æ›¸ã„ãŸè©¦é¨“ä»•æ§˜æ›¸ã‚’ Excel ã«å¤‰æ›ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã‚’ä½œã£ãŸ | ç”°èˆŽã‹ã‚‰Geekã‚’ç›®æŒ‡ã™
ã ã„ãŸã„ã®è©¦é¨“é …ç›®æ›¸ã¯ Excel ã§ä½œã‚‰ã‚Œã¦ã„ã‚‹äº‹ãŒå¤šã„ã¨æ€ã„ã¾ã™ãŒã€è©¦é¨“æ‰‹é †ã®ä¿®æ£ã‚„é …ç›®è¿½åŠ ãªã©ã§ã¡ã‚‡ã„ã¡ã‚‡ã„å¤‰æ›´ã™ã‚‹ã“ã¨ãŒã‚ã£ã¦ã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã—ã¦ã„ã‚‹ã¨è¡çªã—ãŸã‚Šå·®åˆ†ãŒã‚ã‹ã‚‰ãªããªã£ãŸã‚Šã—ãŒã¡ã ã£ãŸã‚Šã—ã¾ã›ã‚“ã‹ï¼Ÿ ãã‚“ãªç¾çŠ¶ã‚’ãªã‚“ã¨ã‹ã™ã¹ãã€è©¦é¨“ä»•æ§˜æ›¸ã‚’ Markdown ã§æ›¸ãã¨ã„ã†è©¦ã¿ã‚’ã—ã¦ã¿ã¾ã—ãŸã€‚(ä¸€å¿œã€å®Ÿãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã‚‚é‹ç”¨æ¸ˆã¿) Github ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã¨ã—ã¦å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ ä»¥å‰ Java ã§æ›¸ã„ã¦ãŸã®ã§ã™ãŒã€ä»Šã ã¨ Kotlin ã®æ–¹ãŒç®¡ç†ã—ã‚„ã™ãã†ã ã£ãŸã®ã§ Kotlin ã§æ›¸ãç›´ã—ã¾ã—ãŸã€‚Kotlinã¯æœ¬å½“ã«æ›¸ã„ã¦ã¦æ°—æŒã¡è‰¯ã„è¨€èªžã€‚ ä½¿ã„æ–¹ Github ã® README ã«ã‚‚æ›¸ã„ã¦ã¾ã™ãŒã€ã“ã“ã§ã¯æ—¥æœ¬èªžã§èª¬æ˜Žæ›¸ãã¾ã™ã€‚ 1. è©¦é¨“ä»•æ§˜æ›¸ã® Markdown ã‚’æ›¸ã ä¸‹è¨˜ã®ã‚ˆã†ãª Markdown ã‚’ä½œæˆã—ã¾ã™ã€‚ # è©¦é¨“ã‚«ãƒ†ã‚´ãƒª ## å¤§é …ç›®ã‚µãƒ³ãƒ—ãƒ« ##
THAL 2017/09/12
markdown

Excel
ãƒªãƒ³ã‚¯
excel2js - Excelã‚·ãƒ¼ãƒˆã‚’WebåŒ–
MOONGIFTã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’ç´¹ä»‹ã™ã‚‹ãƒ–ãƒã‚°ã§ã™ã€‚2021å¹´07æœˆ16æ—¥ã§æ›´æ–°åœæ¢ã—ã¾ã—ãŸ æ—¥æœ¬ã«ã¯Excelè·äººã¨å‘¼ã°ã‚Œã‚‹äººãŸã¡ãŒãŸãã•ã‚“ã„ã¾ã™ã€‚å½¼ã‚‰ã«ã‹ã‹ã‚Œã°ã©ã‚“ãªãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã§ã‚ã£ã¦ã‚‚Excelã§ä½œã‚‰ã‚Œã€å¤šãã®æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ãŒExcel VBAã‚’é§†ä½¿ã—ã¦ä½œã‚‰ã‚Œã¾ã™ã€‚ ä»Šå›žã¯ãã®æœ€é«˜å³°ã¨ã‚‚è¨€ãˆã‚‹ã€Excelã§ä½œã‚‹Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ãã‚ŒãŒexcel2jsã§ã™ã€‚ excel2jsã®ä½¿ã„æ–¹ excel2jsã¯Excelã§ä½œã‚‰ã‚ŒãŸã‚·ãƒ¼ãƒˆã‚’HTML/JavaScriptã«ã—ã¦ãã‚Œã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ä¸‹ã®ç”»åƒã¯å…ƒãƒ•ã‚¡ã‚¤ãƒ«ã«ãªã‚‹Excelãƒ•ã‚¡ã‚¤ãƒ«ã§ã™ã€‚å¼ã‚‚åŸ‹ã‚è¾¼ã¾ã‚Œã¦ã„ã¾ã™ã€‚ ãã‚ŒãŒã“ã‚“ãªæ„Ÿã˜ã«Webãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§å‹•ãã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ Excelã§å‹•ãã‚‚ã®ã«ãªã‚Šã¾ã™ã®ã§ã€ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã¨é€£æºã™ã‚‹ãªã©ã¨ã„ã†ã®ã¯é›£ã—ã„ã§ã—ã‚‡ã†ã€‚ã—ã‹ã—ã¡ã‚‡ã£ã¨ã—ãŸè¨ˆç®—å‡¦ç†ã‚’è¡Œã†ã‚‚ã®ã§ã‚ã‚Œã°e
THAL 2016/01/30
Excel
ãƒªãƒ³ã‚¯
Excelæ–¹çœ¼ç´™ã‚’æ”¯ãˆã‚‹æŠ€è¡“2016 - Qiita
POIã‚’ä½¿ã£ãŸExcelå¸³ç¥¨ã®å‡ºåŠ›ã¯ã€ã‚·ã‚¹ãƒ†ãƒ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¨ã£ã¦ã¯æ—¥å¸¸èŒ¶é£¯äº‹ã€ãŠã¡ã‚ƒã®ã“ã‚µã‚¤ã‚µã‚¤ã§ã‚ã‚Šã¾ã™ã€‚ Excelæ–¹çœ¼ç´™ã‚’æ”¯ãˆã‚‹æŠ€è¡“ takezoenå…ˆç”Ÿã«ã‚ˆã‚‹2015å¹´ç‰ˆã¯ã“ã¡ã‚‰ã«ãªã‚Šã¾ã™ã€‚ [] (http://www.slideshare.net/takezoe/excel java2015) ã“ã“ã§ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ã€Så¼ã‹ã‚‰Excelæ–¹çœ¼ç´™ã‚’å‡ºåŠ›ã™ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªaxebomber-cljã¯ã€ã“ã¡ã‚‰ã‚’ã”è¦§ãã ã•ã„ã€‚ ç‰¹ç†ã™ã¹ãã¯axebomber-cljã§ã¯ã€Excelã«ã‚ã‚ŠãŒã¡ãªæ–‡å—åˆ‡ã‚ŒãŒèµ·ã“ã‚‰ãªã„ã¨ã„ã†ã¨ã“ã‚ã§ã™ã€‚ãã‚‚ãã‚‚Excelæ–¹çœ¼ç´™ã¯ã€å…¥åŠ›æ–‡å—åˆ—ãŒè‡ªå‹•æ”¹è¡Œã•ã‚Œãªã„åˆ¶ç´„ã‚’è¨ã‘ã¦ã€åˆ©ç”¨è€…ãŒæ„å›³çš„ãªä½ç½®ã§æ”¹è¡Œã‚’ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã™ã‚‹ãŸã‚ã«ç™ºæ˜Žã•ã‚ŒãŸãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã§ã‚ã‚Šã¾ã™ã€‚ã—ã‹ã—ã€ãã®ç‰¹ç•°ãªè¦‹ãŸç›®ãŒç½ã„ã—ã€å˜ã«æ•¬é ã•ã‚Œã‚‹å˜åœ¨ã«ã¨ã©ã¾ã£ã¦ãŠã‚Šã¾ã™ã€‚axebomber-cljã¯ã€æ–‡å—å¹…ã¨ã‚»ãƒ«
THAL 2015/12/19
Excel

POI

markdown
ãƒªãƒ³ã‚¯
Excelã‹ã‚‰ãƒã‚±ãƒƒãƒˆã‚’ä½œæˆãƒ»æ›´æ–°ã§ãã‚‹ã€ŒRedmineãƒã‚±ãƒƒãƒˆâ˜…ä¸€æ‹¬â˜…ã€
Redmine.JP Blog ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢Redmineã«é–¢ã™ã‚‹ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚„ã€ã‚ˆã‚Šæ´»ç”¨ã™ã‚‹ãŸã‚ã®tipsãªã©ã‚’æŽ²è¼‰ã—ã¾ã™ Redmineã«ã¯CSVãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆãªã©å¤šæ•°ã®ãƒã‚±ãƒƒãƒˆã‚’ã¾ã¨ã‚ã¦ä½œæˆã™ã‚‹æ©Ÿèƒ½ã¯å‚™ã‚ã£ã¦ã„ã¾ã›ã‚“ãŒã€Windowsç”¨ã®ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€ŒRedmineãƒã‚±ãƒƒãƒˆâ˜…ä¸€æ‹¬â˜…ã€ã‚’ä½¿ãˆã°Excelã«è¨˜è¿°ã—ãŸæƒ…å ±ã‚’ã‚‚ã¨ã«è¤‡æ•°ã®ãƒã‚±ãƒƒãƒˆã®ä½œæˆãƒ»æ›´æ–°ãŒè¡Œãˆã¾ã™ã€‚ ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãªã©Redmineã«å¯¾ã™ã‚‹å¤‰æ›´ãŒä¸è¦ãªã®ã§ã€å¹…åºƒã„ç’°å¢ƒã§æ°—è»½ã«åˆ©ç”¨ã§ãã¾ã™ã€‚ ã€ŒRedmineãƒã‚±ãƒƒãƒˆâ˜…ä¸€æ‹¬â˜…ã€ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ä¸‹è¨˜ãƒšãƒ¼ã‚¸ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ http://www.vector.co.jp/soft/winnt/util/se503347.html ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸzipãƒ•ã‚¡ã‚¤ãƒ«ã‚’å±•é–‹ã—ä»»æ„ã®ãƒ•ã‚©ãƒ«ãƒ€ã«é…ç½®ã—ã¦ãã ã•ã„ã€‚ Redmineå´ã®
THAL 2015/07/08
Excel

RedMine
ãƒªãƒ³ã‚¯
1