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

JHashimoto id:JHashimoto

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

${{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ã«PythonãŒæè¼‰ï¼Ÿãã®å¾Œ - xlwings ã‚’ä½¿ãŠã† - Qiita
ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆãŒ Excel ã« Python ã‚’æè¼‰ã™ã‚‹ã“ã¨ã‚’æ¤œè¨Žã—ã¦ã„ã‚‹ã¨ã„ã†ãƒ‹ãƒ¥ãƒ¼ã‚¹ãŒæµã‚ŒãŸã®ã¯ï¼‘å¹´å‰ã®ã“ã¨ã§ã€çµæ§‹è©±é¡Œã«ãªã‚Šã¾ã—ãŸã€‚æ˜¨å¹´ã® Python Advent Calendar 2017 ã§ã¯ã€Excelã«PythonãŒæè¼‰ã•ã‚Œã‚‹ã“ã¨ã‚’æœŸå¾…ã—ã¦ã€ŒExcelã«PythonãŒæè¼‰ï¼Ÿã€ã¨ã„ã†è¨˜äº‹ã‚’æ›¸ãã¾ã—ãŸãŒã€ä»Šå›žã¯ã€ãã®ç¶šç·¨ã‚’æ›¸ãã¾ã™ã€‚ ãã®ãƒ‹ãƒ¥ãƒ¼ã‚¹ã¨ã„ã†ã®ã¯ã€ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆãŒ Excel ã« Python ã‚’æè¼‰ã™ã‚‹ã‹ã©ã†ã‹ã‚’æ¤œè¨Žã™ã‚‹ãŸã‚ã‚¢ãƒ³ã‚±ãƒ¼ãƒˆã‚’å®Ÿæ–½ã—ãŸã¨ã„ã†ã“ã¨ãªã®ã§ã™ãŒã€è©³ã—ãçŸ¥ã‚ŠãŸã„æ–¹ã¯ã€Publickeyã®ã€ŒExcelã«Pythonæè¼‰ã€ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆãŒæ¤œè¨Žã€‚ã‚¢ãƒ³ã‚±ãƒ¼ãƒˆã‚’å®Ÿæ–½ä¸ã€ã¨ã„ã†è¨˜äº‹ãŒã‚ã‹ã‚Šã‚„ã™ã„ã®ã§ã€ãã¡ã‚‰ã‚’ã¿ã¦ãã ã•ã„ã€‚ ãã®å¾Œã©ã†ãªã£ãŸã‹ã¨ã„ã†ã¨ã€ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆãŒé‹å–¶ã—ã¦ã„ã‚‹ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã‚µã‚¤ãƒˆã€ŒExcelâ€™s Suggestion Boxã€ã«æŠ•ç¨¿ã•ã‚Œã¦
JHashimoto 2019/05/14
"è¦ã™ã‚‹ã«ã€ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆãŒ Excel ã«æè¼‰ã™ã‚‹ã®ã¯ JavaScript ã§ã‚ã£ã¦ã€Python ã‚’ä½¿ã„ãŸã„ã®ã§ã‚ã‚Œã° PyXLL ã‹ xlwings ã‚’ä½¿ãˆã¨ã„ã†ã“ã¨ã®ã‚ˆã†ã§ã™ã€‚"

Excel

Python

JavaScript
ãƒªãƒ³ã‚¯
ã€ŒMicrosoft Excelã€ã¯ãƒªã‚¢ãƒ«â€œæ–¹çœ¼ç´™â€ã‚‚ãƒ—ãƒªãƒ³ãƒˆã‚¢ã‚¦ãƒˆã§ãã‚‹ï¼MicrosoftãŒå…¬å¼æä¾›ã—ã¦ã„ã‚‹â€œGraph paperâ€ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãŒä¾¿åˆ©ã€ã‚„ã˜ã†ã¾ã®æœã€‘
JHashimoto 2019/04/30
Excel

æ–¹çœ¼ç´™
ãƒªãƒ³ã‚¯
Linuxã®æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã‹ã‚‰ã€Œã“ã®Excelã‚·ãƒ¼ãƒˆã¨åŒã˜ãƒ¬ã‚¤ã‚¢ã‚¦ãƒˆã§å¸³ç¥¨ã‚’å°åˆ·ã—ã¦ãã ã•ã„ã€ã«å¯¾å¿œã§ãã‚‹Javaãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒç™»å ´ï¼»PRï¼½
Linuxã®æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã‹ã‚‰ã€Œã“ã®Excelã‚·ãƒ¼ãƒˆã¨åŒã˜ãƒ¬ã‚¤ã‚¢ã‚¦ãƒˆã§å¸³ç¥¨ã‚’å°åˆ·ã—ã¦ãã ã•ã„ã€ã«å¯¾å¿œã§ãã‚‹Javaãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒç™»å ´ï¼»PRï¼½ ç¾åœ¨ã§ã¯Linux OSã®ã†ãˆã§å¤šãã®æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ãŒé–‹ç™ºã•ã‚Œã€ç¨¼åƒã—ã¦ã„ã¾ã™ã€‚ ä¸€æ–¹ã€çµŒç†éƒ¨é–€ã‚„å–¶æ¥éƒ¨é–€ãªã©ã®ç¾å ´ã§ã¯ã•ã¾ã–ã¾ãªæ•°å—ãŒWindowsä¸Šã®Excelã§å‡¦ç†ã•ã‚Œã€ãŠå®¢æ§˜ã¸æå‡ºã™ã‚‹è¦‹ç©æ›¸ã‚„è«‹æ±‚æ›¸ãªã©å¤šæ•°ã®å¸³ç¥¨ã‚‚Excelãƒ™ãƒ¼ã‚¹ã§ä½œæˆã€æ´»ç”¨ã•ã‚Œã¦ã„ã‚‹ã®ãŒç¾å®Ÿã§ã™ã€‚ ãã‚Œã‚†ãˆã«ã€æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã®å¸³ç¥¨å°åˆ·ã«å¯¾ã—ã¦ç¾å ´ã®ã‚¹ã‚¿ãƒƒãƒ•ã‹ã‚‰ã€Œã“ã®Excelã‚·ãƒ¼ãƒˆã¨åŒã˜ãƒ¬ã‚¤ã‚¢ã‚¦ãƒˆã«ã—ã¦ã»ã—ã„ã€ã¨è¦æœ›ãŒå¯„ã›ã‚‰ã‚Œã‚‹ã“ã¨ã¯ã€ã—ã°ã—ã°ã‚ã‚‹ã“ã¨ã§ã—ã‚‡ã†ã€‚ ã—ã‹ã—Linux OSã‚’ç”¨ã„ã¦é–‹ç™ºã€é‹ç”¨ã•ã‚Œã¦ã„ã‚‹æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã§ã€ã©ã†ã™ã‚Œã°Excelã‚·ãƒ¼ãƒˆã¨åŒæ§˜ã®ãƒ¬ã‚¤ã‚¢ã‚¦ãƒˆã‚’æŒã¤å¸³ç¥¨å°åˆ·ã‚’å®Ÿç¾ã§ãã‚‹ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãã‚Œã‚’ç°¡å˜ã«å®Ÿç¾ã™ã‚‹ã®ãŒã€ã‚¢ãƒ‰ãƒãƒ³ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãŒæä¾›ã™ã‚‹Javaãƒ©ã‚¤ãƒ–
JHashimoto 2019/03/18
Excel

Linux

Java

å°åˆ·
ãƒªãƒ³ã‚¯
Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ¯”è¼ƒã™ã‚‹ãƒ„ãƒ¼ãƒ«ã‚’ä½œã£ã¦ã¿ãŸ - Qiita
ã¯ã˜ã‚ã« Excelãƒ•ã‚¡ã‚¤ãƒ«ã®æ¯”è¼ƒã«ã¯___WinMerge___ã«___xdocdiff___ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’å…¥ã‚Œã¦ä½¿ã£ã¦ã„ãŸã®ã§ã™ãŒã€ åˆ—ãŒæƒã£ã¦ãªã‹ã£ãŸã‚Šã€ãƒ˜ãƒƒãƒ€ã‚’å›ºå®šã§ããªã‹ã£ãŸã‚Šã¨å°‘ã—ä¸ä¾¿ã«æ„Ÿã˜ã¦ã„ã¾ã—ãŸã€‚ ãã‚“ãªã‚ã‘ã§Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ¯”è¼ƒã™ã‚‹ãƒ„ãƒ¼ãƒ«ã‚’è‡ªä½œã—ã¦ã¿ãŸã®ã§ã€ç´¹ä»‹ã¨ä½¿ã„æ–¹ã‚’æ›¸ã„ã¦ã„ã“ã†ã¨æ€ã„ã¾ã™ã€‚ æ³¨æ„ ã“ã®ãƒ„ãƒ¼ãƒ«ã¯ç†è€…ã®ä»•äº‹ç’°å¢ƒã«ãŠã„ã¦å¿…è¦æœ€ä½Žé™ã®è¦ä»¶ã§ä½œæˆã—ã¦ã„ã¾ã™ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã“ã“ ã‹ã‚‰æœ€æ–°ã®.msiã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ãƒ¼ã‚’å®Ÿè¡Œã™ã‚‹ â€»é›»åç½²åã‚’ã—ã¦ã„ãªã„ã®ã§ã€ä»¥ä¸‹ã®ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã¨æ€ã„ã¾ã™ã€‚ã€Œè©³ç´°ã€â†’ã€Œå®Ÿè¡Œã€ã§å®Ÿè¡Œã§ãã¾ã™ã€‚ Nextã‚’é¸æŠž ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã¨ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’é¸æŠž (ç‰¹ã«æŒ‡å®šãŒãªã‘ã‚Œã°ãã®ã¾ã¾Next) Nextã‚’é¸æŠž èµ·å‹•æ–¹æ³• ###ã€€ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚¢ã‚¤ã‚³ãƒ³ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒå®Œäº†ã™ã‚‹ã¨ã€ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—
JHashimoto 2019/02/25
Excel

å·®åˆ†
ãƒªãƒ³ã‚¯
Microsoft Excel ã‚’ä½¿ç”¨ã—ãŸ AWS DMS ã‚¿ã‚¹ã‚¯ã®ãŸã‚ã® AWS CloudFormation ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã®ä½œæˆ | Amazon Web Services
Amazon Web Services ãƒ–ãƒã‚° Microsoft Excel ã‚’ä½¿ç”¨ã—ãŸ AWS DMS ã‚¿ã‚¹ã‚¯ã®ãŸã‚ã® AWS CloudFormation ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã®ä½œæˆ ã“ã®ãƒ–ãƒã‚°è¨˜äº‹ã§ã¯ã€AWS Database Migration Service (AWS DMS) ã‚¿ã‚¹ã‚¯ã®ãŸã‚ã® AWS CloudFormation ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã®ä½œæˆã‚’è‡ªå‹•åŒ–ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã«ã¤ã„ã¦ãŠè©±ã—ã¾ã™ã€‚DMS ã‚¿ã‚¹ã‚¯ã®ãŸã‚ã® CloudFormation ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã®ä½œæˆæ–¹æ³•ã‚’ãŠæŽ¢ã—ã§ã€CloudFormation ã«é–¢ã™ã‚‹çŸ¥è˜ã‚’ãŠæŒã¡ã§ãªã„å ´åˆã¯ã€ãœã²ã“ã®è¨˜äº‹ã‚’ãŠèªã¿ãã ã•ã„ã€‚ AWS DMS ãŒé–¢ä¸Žã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç§»è¡Œã‚¢ã‚¯ãƒ†ã‚£ãƒ“ãƒ†ã‚£ã§ã¯ã€DMS ã‚¿ã‚¹ã‚¯ã‚’ãƒ—ãƒãƒ“ã‚¸ãƒ§ãƒ‹ãƒ³ã‚°ã™ã‚‹ãŸã‚ã« AWS CloudFormation ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚’ä½œæˆã™ã‚‹å…±é€šã®ã‚¿ã‚¹ã‚¯ã«ä½•åº¦ã‚‚éé‡ã—ã¾ã™ã€‚AWS CloudFor
JHashimoto 2019/01/29
CloudFormation

Excel
ãƒªãƒ³ã‚¯
Excelæ”¹é€ ã®è¨˜äº‹ä¸€è¦§ | DevelopersIO
Excelæ”¹é€ ã®è¨˜äº‹ä¸€è¦§ã§ã™
JHashimoto 2018/08/06
Excel

AWS
ãƒªãƒ³ã‚¯
ã€Excelã€‘å°åˆ·ã›ãšã«è³‡æ–™ã®ä¿®æ£ç®‡æ‰€ã‚’æ‰‹æ›¸ãã§æŒ‡æ‘˜ã—ãŸã„ï¼ã‚¨ã‚¯ã‚»ãƒ«æ–‡æ›¸ã‚’ã‚¤ãƒ³ã‚¯ãƒ„ãƒ¼ãƒ«ã§æ ¡æ£ã™ã‚‹ãƒ†ã‚¯ã€ã„ã¾ã•ã‚‰èžã‘ãªã„Excelã®ä½¿ã„æ–¹è¬›åº§ã€‘
JHashimoto 2018/06/25
Excel

æ ¡æ£
ãƒªãƒ³ã‚¯
Excelã®è¡¨ã‚’Markdownå½¢å¼ã«å¤‰æ›ã™ã‚‹Excelã‚¢ãƒ‰ã‚ªãƒ³ã€Webã‚µãƒ¼ãƒ“ã‚¹ã®ãƒªãƒ³ã‚¯ - ãƒ—ãƒã‚°ãƒ©ãƒžã®æ€ç´¢
å°å· æ˜Žå½¦, é˜ªäº• èª : ãƒã‚±ãƒƒãƒˆé§†å‹•é–‹ç™º æ—¥æœ¬ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºã®ç¾å ´ã§ç”Ÿã¿å‡ºã•ã‚ŒãŸã€Œãƒã‚±ãƒƒãƒˆé§†å‹•é–‹ç™ºã€ã¨ã„ã†æ¦‚å¿µã‚’ã€æ•°å¤šãã®å®Ÿä¾‹ã‚’å…ƒã«ãƒ¢ãƒ‡ãƒ«åŒ–ãƒ»ä½“ç³»åŒ–ã‚’è©¦ã¿ãŸæœ€åˆã®æœ¬ã€‚ å°å· æ˜Žå½¦, é˜ªäº• èª : Redmineã«ã‚ˆã‚‹ã‚¿ã‚¹ã‚¯ãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆå®Ÿè·µæŠ€æ³• Redmineã«ã‚ˆã‚‹ãƒã‚±ãƒƒãƒˆé§†å‹•é–‹ç™ºã®å®Ÿè·µæŠ€æ³•ã«é–¢ã™ã‚‹æœ€åˆã®æœ¬ã€‚ã‚¢ã‚¸ãƒ£ã‚¤ãƒ«ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºã¸ã®é©ç”¨æ–¹æ³•ã€TestLinkã«ã‚ˆã‚‹ãƒ†ã‚¹ãƒˆç®¡ç†æ‰‹æ³•ã«ã¤ã„ã¦ã‚‚è¨€åŠã€‚ æ¸…æ°´ å‰ç”·: ã€Œæ´¾ç”Ÿé–‹ç™ºã€ã‚’æˆåŠŸã•ã›ã‚‹ãƒ—ãƒã‚»ã‚¹æ”¹å–„ã®æŠ€è¡“ã¨æ¥µæ„ çµ„è¾¼ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã€ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºç‰¹æœ‰ã®ã‚¹ã‚¿ã‚¤ãƒ«ã§ã‚ã‚‹æ´¾ç”Ÿé–‹ç™ºã€ç‰¹ã«XDDPã«ã¤ã„ã¦è§£èª¬ã—ãŸä¸–ç•Œã§ã‚‚ç¨€ãªæœ¬ã€‚æ—¢å˜è£½å“ã‚’ä¿å®ˆã™ã‚‹ã®ã§ã¯ãªãç¶™ç¶šçš„ã«æ©Ÿèƒ½è¿½åŠ ã—ã¦ã„ãæ˜¨ä»Šã®é–‹ç™ºã§ã¯ã€æ´¾ç”Ÿé–‹ç™ºç‰¹æœ‰ã®å•é¡Œã‚’æ„è˜ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚XDDPã¯ãƒ—ãƒã‚»ã‚¹è«–ã ã‘ã§ãªãã€è¦ä»¶å®šç¾©ãªã©ã®ä¸Šæµå·¥ç¨‹ã®å“è³ªæ”¹å–„ã«ã‚‚å½¹ç«‹ã¤ã®ã§æ³¨æ„ã€‚ Le
JHashimoto 2018/06/25
Excel

Markdown

ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
Excel2007(ã‚¨ã‚¯ã‚»ãƒ«2007)åŸºæœ¬è¬›åº§:ãƒ”ãƒœãƒƒãƒˆãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½¿ã„æ–¹
ãƒ”ãƒœãƒƒãƒˆãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆã€€ã€€ã€€ã€€Topã¸ ãƒ‡ãƒ¼ã‚¿ãƒªã‚¹ãƒˆå†…ã®ã‚»ãƒ«ã‚’é¸æŠžã—ãŸçŠ¶æ…‹ã«ã—ã¾ã™ã€‚(Excelã«ãƒ‡ãƒ¼ã‚¿ç¯„å›²ã‚’è‡ªå‹•ã§èªè˜ã•ã›ã‚‹ãŸã‚) [æŒ¿å…¥]ã‚¿ãƒ–ã®[ãƒ”ãƒœãƒƒãƒˆãƒ†ãƒ¼ãƒ–ãƒ«ã®æŒ¿å…¥]ã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ [ãƒ”ãƒœãƒƒãƒˆãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆ]ãƒ€ã‚¤ã‚¢ãƒã‚°ã§ãƒ‡ãƒ¼ã‚¿ç¯„å›²ãŠã‚ˆã³ãƒ†ãƒ¼ãƒ–ãƒ«ã®é…ç½®ã™ã‚‹å ´æ‰€ã‚’è¨å®šã—ã¾ã™ã€‚ ã‚·ãƒ¼ãƒˆä¸Šã«ä½œæˆã®ãƒ’ãƒ³ãƒˆãŒè¡¨ç¤ºã•ã‚Œã€ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãƒªã‚¹ãƒˆãŒä½œæ¥ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã«è¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ ä½œæ¥ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã§ã¯å¤§ãã„ã®ã§ã‚·ãƒ¼ãƒˆä¸Šã¸å¼•ã£å¼µã‚Šå‡ºã—ãŸçŠ¶æ…‹ã§èª¬æ˜Žã—ã¾ã™ã€‚ (ã‚¿ã‚¤ãƒˆãƒ«ãƒãƒ¼ã‚’ãƒ‰ãƒ©ãƒƒã‚°ã—ã¦ã‚·ãƒ¼ãƒˆä¸Šã¸å¼•ã£å¼µã‚Šå‡ºã—ã¦ã„ã¾ã™ã€‚å…ƒã«æˆ»ã™ã«ã¯ã‚·ãƒ¼ãƒˆã®å³ç«¯ã¸ãƒ‰ãƒ©ãƒƒã‚°ã—ã¾ã™ã€‚) ãƒ”ãƒœãƒƒãƒˆãƒ†ãƒ¼ãƒ–ãƒ«ã®æ“ä½œã€€ã€€ã€€ã€€Topã¸ ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’å„ãƒœãƒƒã‚¯ã‚¹å†…ã¸ãƒ‰ãƒ©ãƒƒã‚°ã—ã¾ã™ã€‚ å¹´æœˆã§ãƒ‡ãƒ¼ã‚¿ã®çµžã‚Šè¾¼ã¿ã‚’è¡Œã„ãŸã„ã®ã§ã€ã€Œå¹´æœˆæ—¥ã€ã‚’ã€Œå¹´ã€ã€Œæœˆã€ã«ã‚°ãƒ«ãƒ¼ãƒ—åŒ–ã—ã¾ã™ã€‚ åˆ—ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’é¸æŠžã—ã¾ã™ã€‚ [ãƒ”ãƒœãƒƒãƒˆãƒ†ãƒ¼ãƒ–ãƒ«ã€€ãƒ„ãƒ¼ãƒ«]ãƒªãƒœãƒ³ã®[ã‚ªãƒ—ã‚·ãƒ§ãƒ³]ã‚¿ãƒ–ã§[ã‚°
JHashimoto 2017/02/14
Excel

ãƒ”ãƒœãƒƒãƒˆãƒ†ãƒ¼ãƒ–ãƒ«
ãƒªãƒ³ã‚¯
Excelã§ã‚‚mermaidã—ãŸã„ - Qiita
æ–°ã—ãä½œã‚Šç›´ã—ãŸã€‚ãƒªãƒ³ã‚¯ ãã‚ãã‚Excelã§è³‡æ–™ä½œã‚‹ã®ã‚„ã‚ãŸã„ mermaid.jsãŒç´ æ™´ã‚‰ã—ã„ã‘ã©ãªã‹ãªã‹ãƒ»ãƒ»ãƒ» Markdownã¨ã‹ã§ã‚µã‚¯ãƒƒã¨æ›¸ããŸã„ã€‚ ã§ã‚‚è³‡æ–™ã¯Excelã§æå‡ºã—ãªã„ã¨ã„ã‘ãªã„ã€‚ ã ã‹ã‚‰Excelã§mermaidã—ã¦ã¿ãŸã€‚ mermaidã‚’ã‚¨ã‚¯ã‚»ãƒ«é–¢æ•°ã«çªã£è¾¼ã‚€ã¨ã€ ãƒ–ãƒ©ã‚¦ã‚¶ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚é©å½“ã«ã‚µã‚¤ã‚ºèª¿æ•´ã—ã¦ é–‰ã˜ã‚‹ã¨ã‚ãƒ£ãƒ—ãƒãƒ£ç”»åƒã‚’è²¼ã£ã¦ãã‚Œã‚‹ã€‚ Usage xll 32bitâ€» ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦xllã‚’é–‹ã(ExcelãŒé–‹ã) â€»ExcelãŒ64bitãªã‚‰xll 64bit ã‚»ãƒ«A1ã« graph LR ã‚»ãƒ«A2ã« HelloWorld åˆ¥ã®ã‚»ãƒ«ã«=mermaid(A1:A2) ãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ ã‚½ãƒ¼ã‚¹ã¯GitHub .Net4.6 C#ã§ä½œã£ã¦é€”ä¸ã‹ã‚‰.Net4.5ã«ä¸‹ã’ãŸãŒ4.6ã®æ§‹æ–‡ã®ã¾ã¾ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã§ããŸãƒ»ãƒ»ãƒ» 4.5ã§å‹•ãã®ã ã‚ã†ã‹ãƒ»ãƒ»ãƒ»ï¼Ÿ ãƒ–ãƒ©ã‚¦
JHashimoto 2016/10/25
"mermaidã‚’ã‚¨ã‚¯ã‚»ãƒ«é–¢æ•°ã«çªã£è¾¼ã‚€ã¨ã€ãƒ–ãƒ©ã‚¦ã‚¶ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚é©å½“ã«ã‚µã‚¤ã‚ºèª¿æ•´ã—ã¦é–‰ã˜ã‚‹ã¨ã‚ãƒ£ãƒ—ãƒãƒ£ç”»åƒã‚’è²¼ã£ã¦ãã‚Œã‚‹ã€‚"

Excel

mermaid
ãƒªãƒ³ã‚¯
Microsoft â€“ ã‚¯ãƒ©ã‚¦ãƒ‰ã€ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãƒ¼ã€ã‚¢ãƒ—ãƒª & ã‚²ãƒ¼ãƒ
6 æœˆ 10 æ—¥åˆå‰ 2 æ™‚ (æ—¥æœ¬æ™‚é–“) ã«ã€ã€ŒXbox Games Showcaseã€ã€Call of DutyÂ®: Black Ops 6 Direct ã®é †ã«é–‹å‚¬ã•ã‚Œã‚‹ 2 æœ¬ç«‹ã¦ã‚¤ãƒ™ãƒ³ãƒˆã«å‚åŠ ã—ã¾ã—ã‚‡ã†ã€‚
JHashimoto 2016/07/30
â€œHow do I deliver an Excel file in ASP.NET?â€

ASP.NET

Excel

ClosedXML
ãƒªãƒ³ã‚¯
Excelã‚’ä½¿ã‚ãš.xlsã§é–‹ã‘ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’HTMLã¨CSSã§ä½œã‚‹ - Qiita
WEBã‚µãƒ¼ãƒãªã©ã€ExcelãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ãªã„ç’°å¢ƒã§Excelå½¢å¼ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œã‚‹å ´åˆã€ Javaã ã£ãŸã‚‰Apache POIã¨ã‹ä½¿ã£ãŸã‚Šã™ã‚‹ã€‚ ã“ã“ã«ã„ã‚ã„ã‚ãªã‚„ã‚Šæ–¹ãŒè¼‰ã£ã¦ã„ãŸãƒ» ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã§Excelãƒ–ãƒƒã‚¯ã‚’ç”Ÿæˆã™ã‚‹ã„ãã¤ã‹ã®æ–¹æ³• ãã“ã¾ã§ã¡ã‚ƒã‚“ã¨Excelå½¢å¼ã®ãƒ•ã‚¡ã‚¤ãƒ«ã˜ã‚ƒãªãã¦ã‚‚ã€ Excelã§é–‹ã‘ã¦ç½«ç·šã¨ã‹è‰²ã¨ã‹è¨å®šã§ãã‚‹ã ã‘ã§ã„ã„ã ã‘ã¨ã¨ã„ã†å ´åˆã¯ã€ HTMLå½¢å¼ã§ä½œã£ã¦ãã‚Œã‚’æ‹¡å¼µåã€Œ.xlsã€ã§ä¿å˜ã™ã‚‹ã ã‘ã§ã‚‚è¡¨çµ„ã¿ãŒä½¿ãˆã‚‹ã€‚ â€»ãŸã ã—ã€å†…å®¹ã¨æ‹¡å¼µåãŒä¸€è‡´ã—ã¦ã„ãªã„ã®ã§å£Šã‚Œã¦ã„ã‚‹ã€‚ã€‚ã®è¦å‘Šãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã¯å‡ºã¦ã—ã¾ã†ã€‚ ã“ã‚ŒãŒ <html> <body> <tableã€€border="1" > <tr> <th style="color:white;background-color:gray" >é …ç›®ï¼‘</th> <th>é …ç›®ï¼’</th> <th>é …ç›®ï¼“</th> </
JHashimoto 2016/07/11
â€œãã“ã¾ã§ã¡ã‚ƒã‚“ã¨Excelå½¢å¼ã®ãƒ•ã‚¡ã‚¤ãƒ«ã˜ã‚ƒãªãã¦ã‚‚ã€ Excelã§é–‹ã‘ã¦ç½«ç·šã¨ã‹è‰²ã¨ã‹è¨å®šã§ãã‚‹ã ã‘ã§ã„ã„ã ã‘ã¨ã¨ã„ã†å ´åˆã¯ã€ HTMLå½¢å¼ã§ä½œã£ã¦ãã‚Œã‚’æ‹¡å¼µåã€Œ.xlsã€ã§ä¿å˜ã™ã‚‹ã ã‘ã§ã‚‚è¡¨çµ„ã¿ãŒä½¿ãˆã‚‹ã€‚â€

Excel
ãƒªãƒ³ã‚¯
ã€ŒEXCELä»•æ§˜æ›¸ã‹ã‚‰ã‚³ãƒ¼ãƒ‰ç”Ÿæˆã€ã®ã‚¢ãƒ³ãƒãƒ©ãƒ³ã‚¹ - è¨è¨ˆè€…ã®ç™ºè¨€
EXCELã§æ›¸ã‹ã‚ŒãŸä»•æ§˜æ›¸ã¯ã€ãã®è¦‹ã‹ã‘ã‹ã‚‰ã€ŒEXCELæ–¹çœ¼ç´™ã€ã¨æ¶æ„ã•ã‚Œã¦ã„ã‚‹ãŒã€ä»Šã§ã¯ãã‚Œãªã‚Šã«é€²æ©ã—ã¦ã€ãã“ã‹ã‚‰DDLã‚„ã‚¯ãƒ©ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’å‡ºåŠ›ã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ãŸã‚Šã™ã‚‹ã€‚ã—ã‹ã—ã€ãã®ã‚ˆã†ãªã€Œæ°—ã®åˆ©ã„ãŸæ©Ÿèƒ½ã€ã‚’æè¼‰ã™ã‚Œã°ã€EXCELä»•æ§˜æ›¸ã¯ã¾ã™ã¾ã™å¥‡å¦™ãªã‚‚ã®ã«ãªã£ã¦ã‚†ãã€‚ ã¾ãšã€ç”Ÿæˆã•ã‚ŒãŸã‚³ãƒ¼ãƒ‰ãŒæ¡ˆå¤–å½¹ã«ç«‹ãŸãªã„ã¨ã„ã†å•é¡ŒãŒã‚ã‚‹ã€‚ãŸã¨ãˆã°CREATE TABLEæ–‡ã¯æ–‡å—é€šã‚Šãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹ãŸã‚ã®ã‚‚ã®ã ãŒã€ç¾å®Ÿã®é–‹ç™ºã§ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ä½•åº¦ã‚‚ä½œã‚Šå¤‰ãˆã‚‰ã‚Œã‚‹ã€‚ãã‚Œã‚†ãˆã«ã€CREATE TABLEæ–‡ã ã‘ã§ãªãALTER TABLEæ–‡ã‚‚ç”Ÿæˆã§ãã‚‹ã‚ˆã†ã§ã‚ã£ã¦ã»ã—ã„ã€‚ã¨ã“ã‚ãŒã€EXCELä»•æ§˜æ›¸ã®ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‹ã‚‰CREATE TABLEæ–‡ã‚’ç”Ÿæˆã™ã‚‹ã®ã¯ç°¡å˜ã ãŒã€å®šç¾©ä¿®æ£å¾Œã®å·®åˆ†ã‹ã‚‰ALTER TABLEæ–‡ã‚’ç”Ÿæˆã™ã‚‹ã®ã¯ç°¡å˜ã§ã¯ãªã„ã€‚ æ‰‹æ®µãŒãªã„ã‚ã‘ã§ã¯ãªã„ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿å‡ºã›ã°ã‚ˆ
JHashimoto 2016/05/31
Excel

è¨è¨ˆ
ãƒªãƒ³ã‚¯
EPPlus-Create advanced Excel 2007 spreadsheets on the server
ã™ã¹ã¦ã® Microsoft è£½å“ Global Microsoft 365 Teams Copilot Windows Surface Xbox ã‚»ãƒ¼ãƒ« æ³•äººå‘ã‘ ã‚µãƒãƒ¼ãƒˆ ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ Windows ã‚¢ãƒ—ãƒª AI OneDrive Outlook Skype OneNote Microsoft Teams PC ã¨ãƒ‡ãƒã‚¤ã‚¹ Xbox ã‚’è³¼å…¥ã™ã‚‹ ã‚¢ã‚¯ã‚»ã‚µãƒª VR & è¤‡åˆç¾å®Ÿ ã‚¨ãƒ³ã‚¿ãƒ¡ Xbox Game Pass Ultimate Xbox ã¨ã‚²ãƒ¼ãƒ PC ã‚²ãƒ¼ãƒ Windows ã‚²ãƒ¼ãƒ æ˜ ç”»ã¨ãƒ†ãƒ¬ãƒ“ç•ªçµ„ æ³•äººå‘ã‘ Microsoft Cloud Microsoft Security Azure Dynamics 365 ä¸€èˆ¬æ³•äººå‘ã‘ Microsoft 365 Microsoft Industry Microsoft Power Platform Windows 365 é–‹ç™ºè€…
JHashimoto 2016/05/30
"EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx). "

.NET

Excel

Open XML
ãƒªãƒ³ã‚¯
Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’ C# ã¨ VB.NET ã§èªã¿è¾¼ã‚€ "æ£ã—ã„" æ–¹æ³• - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? #ã¯ã˜ã‚ã« "Excel C#" ã‚„ "Excel VB.NET" ã§ã‚°ã‚°ã£ãŸæ–°äººãƒ—ãƒã‚°ãƒ©ãƒžãŒã€å¤ã„æƒ…å ±ã‚„é–“é•ã£ãŸæƒ…å ±ã§èŒ¨ã®é“ã‚’é¸ã°ãšã«æ¸ˆã‚€ã‚ˆã†ã«ã¨æ€ã£ã¦æ›¸ãã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã¯ã€Windows ã§ Visual Studio ã‚’ä½¿ç”¨ã—ãŸãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã‚’æƒ³å®šã—ã¦ã„ã¾ã™ã€‚ VB.NET ã§ã‚‚ä½œæˆå¯èƒ½ã§ã™ãŒã€ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ã§ã¯ C# 6.0 ã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ã€‚ã©ã¡ã‚‰ã§ã‚‚ã„ã„ãªã‚‰ C# ã‚’ä½¿ã„ã¾ã—ã‚‡ã†ã€‚ #C# ã¾ãŸã¯ VB.NET ã§Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿è¾¼ã‚€ã«ã¯ ##Googleæ¤œç´¢ã®ç½ 2016/4/11ç¾åœ¨ã€æ—¥æœ¬ç‰ˆ
JHashimoto 2016/04/20
Excel

.NET
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
JHashimoto 2015/11/09
â€œWindows Server 2003 ã¨ Windows Server 2012 R2 ã®é•ã„ã¨ã„ãˆã°ã€Windows Server 2008 ã‹ã‚‰ Session 0 åˆ†é›¢ã¨ã„ã†ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¯¾ç–ãŒå–ã‚‰ã‚ŒãŸã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚â€

ASP

Excel

COM
ãƒªãƒ³ã‚¯
Excelã®æœ¬æ°—ï¼ä½œæ¥åŠ¹çŽ‡ã‚’ã‚¢ãƒƒãƒ—ã™ã‚‹è¡æ’ƒã®ã‚¢ãƒ‰ã‚¤ãƒ³ã¨ãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚ - ãƒªã‚¯ãƒŠãƒ“NEXTã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
ãã‚‚ãã‚‚ã‚¢ãƒ‰ã‚¤ãƒ³ã£ã¦ä½•ï¼Ÿã©ã†ã‚„ã£ã¦ä½¿ã†ã®ï¼Ÿ ã‚¢ãƒ‰ã‚¤ãƒ³ï¼ˆAdd-inï¼‰ã¨ã¯ã€Excelãªã©å„ç¨®Officeè£½å“ã«ã€Žã‚ã¨ã‹ã‚‰ã„ã‚ã„ã‚ãªä¾¿åˆ©æ©Ÿèƒ½ã‚’ã¤ã‘ã‚‹ã€ãŸã‚ã«ä½œæˆã•ã‚ŒãŸæ‹¡å¼µãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®ã“ã¨ã€‚ ã‚¤ãƒžã‚¤ãƒæ—¥æœ¬ã§ã¯æµè¡Œã‚‰ãªã‹ã£ãŸã“ã¨ã‚‚ã‚ã‚Šã€åˆ©ç”¨æ–¹æ³•ã™ã‚‰ã‚ˆãã‚ã‹ã‚‰ãªã„â€¦ã¨ã„ã†äººã‚‚å¤šã„ã‹ã¨æ€ã„ã¾ã™ã®ã§ã€ã¾ãšã¯ç°¡å˜ã«ç™»éŒ²æ–¹æ³•ã‚’ä¸‹è¨˜ã«è¨˜è¼‰ã—ã¦ãŠãã¾ã™ã€‚ ã‚¢ãƒ‰ã‚¤ãƒ³ãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆ.xla .xlam .xllï¼‰ã‚’ã€Œã‚¢ãƒ‰ã‚¤ãƒ³ãƒ•ã‚©ãƒ«ãƒ€ã€ã«ä¿å˜ â€»æ—¢å®šã¯ï¼»C:Programm FilesMicrosoft OfficeOffice15Libraryï¼½ãƒ‘ã‚¹ã¯ç’°å¢ƒã«ã‚ˆã£ã¦å¤šå°‘ç•°ãªã‚Šã¾ã™ãŒã€ã‚ã‹ã‚‰ãªã„å ´åˆã¯ã€Œãƒ•ã‚¡ã‚¤ãƒ«ã®æ¤œç´¢ã€ã§ã€Excel.exeã€‘ãŒã‚ã‚‹ãƒ•ã‚©ãƒ«ãƒ€ã‚’å‚ç…§ Excelã‚’èµ·å‹•ã—ã¦ã€Œãƒ•ã‚¡ã‚¤ãƒ«ã€â‡’ã€Œã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€â‡’ã€Œã‚¢ãƒ‰ã‚¤ãƒ³ã€ã¨é¸æŠž ã‚¢ãƒ‰ã‚¤ãƒ³ãƒ€ã‚¤ã‚¢ãƒã‚°ã§ã€Œå‚ç…§ã€â‡’ä¸Šè¿°ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’é¸æŠžã—ã¦ã€ŒOKã€ ã“ã‚Œã§OKã§ã™ã€‚ãã†ã™ã‚‹ã¨
JHashimoto 2015/10/31
Excel

æ‹¡å¼µæ©Ÿèƒ½
ãƒªãƒ³ã‚¯
ASP.NET MVC ã§ Excel ãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡ºåŠ› - present
Open XML SDK ã‚’ä½¿ãˆã° C# ã§ Excel ãƒ•ã‚¡ã‚¤ãƒ« (.xlsx) ã‚’å‡ºåŠ›ã§ããŸã€‚ tnakamura.hatena blog.com å…ˆæ—¥ã®ã‚µãƒ³ãƒ—ãƒ«ã§ã¯ãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã—ãŸã‘ã©ã€ SpreadsheetDocument ã¯ã‚¹ãƒˆãƒªãƒ¼ãƒ ã¸ã®å‡ºåŠ›ã«ã‚‚å¯¾å¿œã—ã¦ã„ã‚‹ã€‚ ä»Šåº¦ã¯ Excel ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ ASP.NET MVC ã‚µãƒ³ãƒ—ãƒ«ã‚’æ›¸ã„ã¦ã¿ãŸã€‚ ãƒ¬ãƒãƒ¼ãƒˆã‚’ Excel ãƒ•ã‚¡ã‚¤ãƒ«ã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹æ©Ÿèƒ½ãŒå®Ÿç¾ã§ããã†ã ã€‚ using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using DocumentFormat.OpenXml; using DocumentFormat.OpenXml.Packaging;
JHashimoto 2015/10/31
ASP.NET MVC

Excel
ãƒªãƒ³ã‚¯
2ã¤ã®Excelãƒ•ã‚¡ã‚¤ãƒ«ã®å·®åˆ†ã‚’æ¯”è¼ƒã™ã‚‹ãƒ„ãƒ¼ãƒ« - è’¼ã®çŽ‹åº§ãƒ»è£å£
Excel 2013ã§ã¯ã€æ¨™æº–ã§2ã¤ã®Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ¯”è¼ƒã—ã¦ã€å·®åˆ†ã‚’è¡¨ç¤ºã™ã‚‹ãƒ„ãƒ¼ãƒ«ãŒåŒæ¢±ã•ã‚Œã¦ã„ã¾ã™ã®ã§ã€ä½¿ç”¨æ–¹æ³•ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ ï¼‘ï¼Žãƒ•ã‚¡ã‚¤ãƒ«ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚’é¸æŠžã—ã¾ã™ã€‚ ï¼’ï¼Žã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’é¸æŠžã—ã¾ã™ã€‚ ï¼“ï¼Žã‚¢ãƒ‰ã‚¤ãƒ³ã‚’é¸æŠžã—ã¾ã™ã€‚ ï¼”ï¼Žç®¡ç†ã‹ã‚‰ã€ŒCOMã‚¢ãƒ‰ã‚¤ãƒ³ã€ã‚’é¸æŠžã—ã¾ã™ã€‚ ï¼•ï¼Žè¨å®šãƒœã‚¿ãƒ³ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ ï¼–ï¼ŽInquireã«ãƒã‚§ãƒƒã‚¯ã‚’å…¥ã‚Œã€OKãƒœã‚¿ãƒ³ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ ï¼—ï¼ŽINQUIREã‚¿ãƒ–ã‚’é¸æŠžã—ã¾ã™ã€‚ ï¼˜ï¼Žæ¯”è¼ƒã—ãŸã„Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚ã‚‰ã‹ã˜ã‚ï¼’ã¤é–‹ã„ã¦ãŠãã¾ã™ã€‚ ï¼™ï¼Žãƒ•ã‚¡ã‚¤ãƒ«ã®æ¯”è¼ƒã‚’é¸æŠžã—ã¾ã™ã€‚ ï¼‘ï¼ï¼Žãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ¯”è¼ƒã—ã¾ã™ã€‚æ¯”è¼ƒãƒœã‚¿ãƒ³ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ ï¼‘ï¼‘ï¼ŽçµæžœãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚
JHashimoto 2015/10/14
â€œExcel 2013ã§ã¯ã€æ¨™æº–ã§2ã¤ã®Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ¯”è¼ƒã—ã¦ã€å·®åˆ†ã‚’è¡¨ç¤ºã™ã‚‹ãƒ„ãƒ¼ãƒ«ãŒåŒæ¢±ã•ã‚Œã¦ã„ã¾ã™ã®ã§ã€ä½¿ç”¨æ–¹æ³•ã‚’èª¬æ˜Žã—ã¾ã™ã€‚â€

Excel
ãƒªãƒ³ã‚¯
ã¾ã APIã§æ¶ˆè€—ã—ã¦ã‚‹ã®ï¼Ÿã€€ã‚µã‚¯ãƒƒã¨ãƒ‡ãƒ¼ã‚¿ãŒæ¬²ã—ã„ãªã‚‰ã€ŒBlockspringã€ã‚’ä½¿ãŠã†ï¼ â€“ GUNMA GIS GEEK
å„ã‚µãƒ¼ãƒ“ã‚¹ã®APIã®ä»•æ§˜ãªã‚“ã¦è¦šãˆã¦ã‚‰ã‚“ãã‡ï¼ã¨ã„ã†äººã¯æ˜¯éžã€‚ Blockspringã¨ã¯ Blockspringã¯ã€Twitterã‚„Facebookãªã©ã®ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ¡ãƒ‡ã‚£ã‚¢ã‚’ã¯ã˜ã‚ã€Amazonã€Youtubeãªã©æ§˜ã€…ãªã‚µãƒ¼ãƒ“ã‚¹ã‹ã‚‰ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã€ãƒ—ãƒã‚°ãƒ©ãƒžãŒAPIã‚’ç›´æŽ¥è§¦ã‚‹ã“ã¨ãªãè¡¨ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦å–å¾—ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ã‚µãƒ¼ãƒ“ã‚¹ã”ã¨ã«è¦æ ¼ã®ç•°ãªã‚‹WebAPIã‚’åˆ©ç”¨ã™ã‚‹ã«ã¯å¦ç¿’ã‚³ã‚¹ãƒˆãŒçµæ§‹ã‹ã‹ã‚‹ã‚ã‘ã§ã™ãŒã€Blockspringã¯ãã†ã„ã£ãŸã‚µãƒ¼ãƒ“ã‚¹ã¨ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã®é–“ã«ç«‹ã¡ã€ãƒ‡ãƒ¼ã‚¿å–å¾—ã®ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã‚’æŠ½è±¡åŒ–ã—ã¦ãã‚Œã¾ã™ã€‚ éžå¸¸ã«æ²¢å±±ã®ã‚µãƒ¼ãƒ“ã‚¹ã«å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚ ã€Œã¡ã‚‡ã“ã£ã¨ãƒ‡ãƒ¼ã‚¿ãŒæ¬²ã—ã„ã ã‘ãªã®ã«ã€ã‚µãƒ¼ãƒ“ã‚¹æ¯Žã®WebAPIã‚’å‹‰å¼·ã™ã‚‹ã®ã‚‚ã†ç–²ã‚ŒãŸã€ ãã‚“ãªæ™‚ã¯Blockspringã‚’åˆ©ç”¨ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Blockspringã¯Google ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã¨ã‚¨ã‚¯ã‚»ãƒ«
JHashimoto 2015/09/21
â€œBlockspringã¯ã€Twitterã‚„Facebookãªã©ã®ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ¡ãƒ‡ã‚£ã‚¢ã‚’ã¯ã˜ã‚ã€Amazonã€Youtubeãªã©æ§˜ã€…ãªã‚µãƒ¼ãƒ“ã‚¹ã‹ã‚‰ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã€ãƒ—ãƒã‚°ãƒ©ãƒžãŒAPIã‚’ç›´æŽ¥è§¦ã‚‹ã“ã¨ãªãè¡¨ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦å–å¾—ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚â€

Web API

Excel
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 æ¬¡ã®ãƒšãƒ¼ã‚¸