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

nakaji999 id:nakaji999

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

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

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 é–‹ç™ºè€…
nakaji999 2013/02/01
.NET

Excel

library
ãƒªãƒ³ã‚¯
ã€ŒExcelã€ã‹ã‚‰ã€ŒLibreOfficeã€ã¸ãƒžã‚¯ãƒã‚’ç§»è¡Œã™ã‚‹ãŸã‚ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ãŒç„¡å„Ÿå…¬é–‹
nakaji999 2012/05/15
Excel
ãƒªãƒ³ã‚¯
æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã«çµ„ã¿è¾¼ã¿ãŸã„ã€‚PHPã‹ã‚‰Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿æ›¸ãã™ã‚‹Â·PHPExcel MOONGIFT
PHP Excelã¯Excelãƒ•ã‚¡ã‚¤ãƒ«ã®èªã¿æ›¸ãã‚’è¡Œã†PHPãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€‚PDF/HTMLå‡ºåŠ›ã«ã‚‚å¯¾å¿œã€‚ PHP Excelã¯PHPè£½ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€‚æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã‚’é–‹ç™ºã—ã¦ã„ã¦å¿…ãšç™ºç”Ÿã™ã‚‹ã®ãŒExcelã®ã‚ˆã†ãªè¡¨å½¢å¼ãƒ•ã‚¡ã‚¤ãƒ«ã®å–ã‚Šè¾¼ã¿ã ã€‚å¤§æŠµã¯CSVã«å¤‰æ›ã—ã¦ã‚‚ã‚‰ã£ã¦å–ã‚Šè¾¼ã‚€ã ã‚ã†ã€‚ã ãŒãƒ¦ãƒ¼ã‚¶ãŒå¤‰æ›ã‚’å¿˜ã‚Œã¦Excelã‚’èªã¿è¾¼ã¾ã›ã¦ã—ã¾ã†ã“ã¨ã‚‚åº¦ã€…ã ã€‚ PHPã§å‡ºåŠ›ã§ãã‚‹ ã•ã‚‰ã«ã‚·ã‚¹ãƒ†ãƒ ã‹ã‚‰è³‡æ–™ã‚’å‡ºåŠ›ã™ã‚‹éš›ã«ã‚‚CSVã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦æ‰‹ä½œæ¥ã§ä¿®æ£ã—ã¦â€¦ã¨ã„ã†æ‰‹é–“ã‚’ãƒ¦ãƒ¼ã‚¶ã«ã¨ã‚‰ã›ã‚‹ã“ã¨ã«ãªã£ã¦ã—ã¾ã†ã€‚ãã‚“ãªæ™‚ä»£ã¯ã‚‚ã†å¤ã„ã€PHP Excelã‚’ä½¿ã£ã¦ãƒªãƒƒãƒãªExcelãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãã®ã¾ã¾ã‚„ã‚Šå–ã‚Šã—ã‚ˆã†ã€‚ PHP Excelã¯Excel 2007ã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ã€5.0/95/97ä»¥é™ã®ãƒ•ã‚¡ã‚¤ãƒ«å½¢å¼ã®èªã¿è¾¼ã¿ã«ã‚‚å¯¾å¿œã—ã¦ã„ã‚‹ã€‚Excel 2003ã®XMLãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã‚‚æ‰±ãˆã‚‹ã€‚ã•ã‚‰ã«OpenOffi
nakaji999 2011/09/20
Excel

php
ãƒªãƒ³ã‚¯
Excelã®è¡¨ï¼ˆQAè¡¨, ä¸å…·åˆè¡¨... etcï¼‰ã‚’ã€ã™ã”ãæ¤œç´¢ã—ã‚„ã™ãã™ã‚‹ãƒ„ãƒ¼ãƒ«ã‚’ä½œã‚Šã¾ã—ãŸã€‚ - åœ°å¹³ç·šã«è¡Œã
æœ€è¿‘ã€ä»•äº‹ã§ã‚„ãŸã‚‰Excelã‚’ä½¿ã†ã‚ˆã†ã«ãªã£ãŸã®ã§ã€ã“ã†ã„ã†ãƒ„ãƒ¼ãƒ«ã‚’ä½œã£ã¦ã¿ã¾ã—ãŸã€‚ Excelã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒ Excelã®è¡¨ã‚’ã€ã™ã”ãæ¤œç´¢ã—ã‚„ã™ãã™ã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ ï¼ˆQAè¡¨, ä¸å…·åˆè¡¨... etcï¼‰ ã‚µãƒ³ãƒ—ãƒ«ã¯ã“ã¡ã‚‰ï¼ ã“ã®ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ã¨ã€Excelã®è¡¨ã‚’ãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§ç´ æ—©ãã€ã‚ã‹ã‚Šã‚„ã™ãæ¤œç´¢ã§ãã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã®è‡ªå‹•å¤‰æ›ã‚¹ã‚¯ãƒªãƒ—ãƒˆãŒã¤ã„ã¦ã„ã‚‹ã®ã§æ‰‹é–“ã¯ã»ã¨ã‚“ã©ã‹ã‹ã‚Šã¾ã›ã‚“ã€‚ ã¾ãŸã€è¤‡æ•°ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¾ãŸãŒã‚‹ã‚ˆã†ãªå ´åˆã§ã‚‚ã€ç°¡å˜ã«æ¤œç´¢ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ æ—¥é ƒã€Excelã§ãƒãƒªãƒãƒªä»•äº‹ã‚’ã“ãªã•ãªãã‚ƒã„ã‘ãªã„SIerã®æ–¹ã«ã†ã£ã¦ã¤ã‘ã®ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ ãœã²ã€ã”åˆ©ç”¨ãã ã•ã„ï¼ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ï¼šãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ - åœ°å¹³ç·šã«è¡Œã ç´¹ä»‹ãƒšãƒ¼ã‚¸ï¼šExcelã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒ - åœ°å¹³ç·šã«è¡Œã çµŒç·¯ ãŠå®¢æ§˜ã¨ã®ã‚„ã‚Šå–ã‚Šã¯ã€ã©ã†ã—ã¦ã‚‚Excelã§æƒ…å ±ã‚’ã‚„ã‚Šã¨ã‚Šã—ãªãã¦ã¯ã„ã‘ã¾ã›ã‚“ã€‚ ã—ã‹ã—ã€Excel
nakaji999 2011/08/22
Excel
ãƒªãƒ³ã‚¯
Groovyã§Excelã®æ“ä½œãã®3 - ushidayã®æ—¥è¨˜
å‰å›žã®ã€ŒGroovyã§Excelã®æ“ä½œãã®2ã€ã®è¨˜äº‹ã§ã€nobusueã•ã‚“ã«ã€ŒApache POIã‚‚ã‚ã‚‹ã‚ˆã€ã¨ã€ã‚³ãƒ¡ãƒ³ãƒˆã‚’é ‚ãã¾ã—ãŸã€‚ ã›ã£ã‹ãæ•™ãˆã¦é ‚ã„ãŸã®ã§ã€ã“ã¡ã‚‰ã‚’å‚è€ƒã«ã€POIã§åŒã˜äº‹ã‚’ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚ â– å®Ÿè¡Œç’°å¢ƒ Groovy Version: 1.6.3 JVM: 1.6.0_12 PC OS: Windows XP SP3 Apache POI: 3.2 OS/400: V5R4M0 JDBCãƒ‰ãƒ©ã‚¤ãƒãƒ¼ï¼šAS/400ä»˜å±žã®jt400.jar â– ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Apache POIã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¾ã™ã€‚ ã‚µã‚¤ãƒˆã‚’é¸ã‚“ã§ã€â€release/bin/poi-bin-3.2-FINAL-20081019.zip â€ã‹ã‚‰å–å¾—ã—ã¾ã™ poi-bin-3.2-FINAL-20081019.zipã‚’è§£å‡ã—ã¾ã™ã€‚ è§£å‡ã—ãŸãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã®â€poi-3.2-FINAL-20081019.jarâ€ã¨â€
nakaji999 2011/08/12
Groovy

Excel

POI
ãƒªãƒ³ã‚¯
Excel-DNA ã‚’ä½¿ã†ãƒ¡ãƒªãƒƒãƒˆ - ãã‚‹ãã‚‹ï½ž
VBA ã‚’ä½¿ã†ã“ã¨ã«å¯¾ã—ã¦ã€Excel-DNA ã‚’ä½¿ã†ã“ã¨ã®ãƒ¡ãƒªãƒƒãƒˆã¯å¤§ä½“ã“ã‚“ãªæ„Ÿã˜ã§ã™ã€‚ ãƒ†ã‚¹ãƒˆãŒå®¹æ˜“ ã‚³ãƒ¼ãƒ‰ã®ç®¡ç†ãŒã§ãã‚‹ æŠ½è±¡åº¦ã®é«˜ã„ã‚³ãƒ¼ãƒ‰ãŒæ›¸ã‘ã‚‹ ä¿å®ˆã—ã‚„ã™ã„ ä¸€ã¤ãšã¤è¦‹ã¦ã„ãã¾ã—ã‚‡ã†ã€‚ ãƒ†ã‚¹ãƒˆãŒå®¹æ˜“ VBA ã«ã‚‚ä¸€å¿œã€VBAUnit ãªã©ã®ãƒ†ã‚¹ãƒ†ã‚£ãƒ³ã‚°ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã¯ã‚ã‚Šã¾ã™*1ã€‚ ã—ã‹ã—ã€VBA ã®è¨€èªžè‡ªä½“ã®è²§å¼±ã•ã‚‚ã‚ã£ã¦ã€ã‚ã¾ã‚Šä½¿ã„ã‚„ã™ã„ã‚‚ã®ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã•ã‚‰ã«ã€ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®ã‚ˆã†ãªå½¢ã§æä¾›ã•ã‚Œã‚‹ãŸã‚ã€ãƒ„ãƒ¼ãƒ«é€£æºãªã©ã¯çµ¶æœ›çš„ã§ã™ã€‚ å¯¾ã—ã¦ã€Excel-DNA ã§ã¯é€šå¸¸ã® dll ã‚’ä½œã‚‹ã ã‘ã§ã™ã®ã§ã€æ™®é€šã«ãƒ†ã‚¹ãƒˆã‚’æ›¸ãã“ã¨ãŒã§ãã¾ã™ã€‚ å…ˆã»ã©ã®çµ„ã¿åˆã‚ã›ã®ä¾‹ã«ã‚‚ã€NaturalSpec ã¨ã„ã†ãƒ†ã‚¹ãƒ†ã‚£ãƒ³ã‚°ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’ä½¿ã£ã¦ãƒ†ã‚¹ãƒˆã‚’æ›¸ã„ã¦ã„ã¾ã™ã€‚ ã‚³ãƒ¼ãƒ‰ã®ç®¡ç†ãŒã§ãã‚‹ VBA ã§ã‚‚é ‘å¼µã‚Œã°ã§ããªãã¯ãªã„ã§ã™ãŒã€Excel-DNA ã§ã¯ä½•ã‚‚é ‘å¼µã‚‹å¿…è¦ã¯ãªãã€ã”ãæ™®é€šã«ã‚³ãƒ¼ãƒ‰ã‚’
nakaji999 2011/07/18
Excel

.NET

library
ãƒªãƒ³ã‚¯
ã•ãã€æ–¹çœ¼ç´™ã‚’å©ã„ã¦ã¿ã‚ˆã†ã‹ã€‚ï¼š101å›žæ»ã‚“ã ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ï¼šã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ©ã‚¤ãƒ•
ã„ã‚ã„ã‚ãªä»•äº‹ã‚’æ¸¡ã‚Šæ©ãã€ä»Šã¯ã‚¤ãƒ³ãƒ•ãƒ©ç³»ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ã‚„ã£ã¦ã„ã‚‹ã€‚ã„ã‚ã‚“ãªæ¥ç¨®ã‹ã‚‰ã®è¦–ç‚¹ã‚‚äº¤ãˆã¦ã‚³ãƒ©ãƒ ã‚’ç¶´ã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ â– ã‚ãˆã¦è¨€ãŠã†ã€ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ä»¥ä¸‹ã ã¨ï¼ æ–¹çœ¼ç´™ã¨è¨€ã£ã¦æ€ã„å‡ºã™ã®ã¯ã€Excelæ–¹çœ¼ç´™ã€‚ã‚ã‚Œã‚’ä½¿ã‚ã‚Œã¦è‹¦åŠ´ã—ã¦ã‚‹äººã¯å¤šã„ã¿ãŸã„ã ã€‚ç§ã®ç¾å ´ã‚‚ã‚ã‚Œã‚’ä½¿ã£ã¦ã„ã‚‹ã®ãŒæ‚©ã¿ã©ã“ã‚ã§ã™ã€‚ ã“ã®éš›ã ã‹ã‚‰è¨€ã£ã¦ãŠã“ã†ã€‚ã‚ã‚Œã¯Excelã®æ©Ÿèƒ½ã‚’æœ€å¤§é™åŠ¹çŽ‡æ‚ªãä½¿ã†æ–¹æ³•ã ã€‚å€‹äººçš„ã«ã¯ã€ TeX > Word > Powerpoint >ã€€Excel >Textãƒ•ã‚¡ã‚¤ãƒ«ï¼‹JPEGãƒ•ã‚¡ã‚¤ãƒ« >>> Excelæ–¹çœ¼ç´™ã€€> æ‰‹æ›¸ã ãã‚‰ã„ãªæ„Ÿè¦šã§ã™ã€‚ Excelæ–¹çœ¼ç´™ãªã‚“ã¦ã€è‚‰æŠœãã®è‚‰ã¾ã‚“ã¿ãŸã„ãªã‚‚ã‚“ã ã€‚ãƒ‘ã‚½ã‚³ãƒ³ã§ä½œæ¥ã™ã‚‹ãƒ¡ãƒªãƒƒãƒˆã®å¤§åŠãŒæãªã‚ã‚Œã‚‹ã€‚ â– æ–¹çœ¼ç´™ã‚’ä½¿ã£ãŸæ™‚ç‚¹ã§æ—¢ã«å¤§ãã2ã¤é–“é•ãˆã¦ã„ã‚‹ ã¾ãš1ã¤ã€Excelã¯ãƒ¯ãƒ¼ãƒ‰ãƒ—ãƒã‚»ãƒƒã‚µãƒ¼ã§ã¯ãªã„ã€‚ç”¨é€”ã‚’é–“é•ãˆã¦ã„ã‚‹ã€‚ã‚‚ã†1ã¤ã€Excelã®
nakaji999 2011/06/21
ã€ŒåŸºç¤Žã ã‹ã‚‰ã“ãã€ã‚€ã—ã‚ã—ã£ã‹ã‚Šã¨ç©ã¿é‡ãã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ã€ç¢ºã‹ã«ãã†ï¼

Excel
ãƒªãƒ³ã‚¯
ã¤ã„ã«Excel VBAã¨ãŠã•ã‚‰ã°ã™ã‚‹æ™‚ãŒããŸã‹ã‚‚ã—ã‚Œã‚“ - ã‹ãšãã®Blog@hatena
.NETç³»ã®è¨€èªžã‚’Excelã§å®Ÿè¡Œã§ãã‚‹Excel-DNAã‚’ãƒ†ãƒ©ã‚¤ã‚±ãƒ¡ãƒ³ã®id:bleis-tiftã®å‘Ÿãã‹ã‚‰æ•™ãˆã¦ã‚‚ã‚‰ãˆã¾ã—ãŸã€‚ Samplesã‚‚çµæ§‹å……å®Ÿã—ã¦ã‚‹ã®ã§ã„ã„ã‹ã‚“ã˜ã€‚ãƒ•ã‚¡ã‚¤ãƒ«ã‚’Excelã«ãƒ‰ãƒãƒƒãƒ—ã™ã‚‹ã ã‘ã§ã„ã„ã®ã§ã€ãŠæ‰‹è»½ã«ä½¿ãˆã¾ã™ãï¼ï¼ å€‹äººçš„ã«ã‚¤ã‚±ã¦ã‚‹ã¨æ€ã£ãŸã®ã¯ä»¥ä¸‹ã®ç‚¹ã€‚ Excelã®ãƒªãƒœãƒ³ã«ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚’è¿½åŠ ã§ãã‚‹ Excelã®ä»»æ„ã®ã‚»ãƒ«ã®å€¤ã®å–å¾—ã€è¨å®šãŒå‡ºæ¥ã‚‹ VB, C#, F#ãŒä½¿ãˆã‚‹ ã‚‚ã†ã‚ˆã ã‚Œã‚‚ã®ã§ã™ã€‚
nakaji999 2011/06/16
Excel

.NET
ãƒªãƒ³ã‚¯
æœ¬å½“ã«ã‚ã£ãŸã‚³ãƒ¯ã‚¤Excel
å½“ãƒ–ãƒã‚°ã¯amazon.co.jpã‚’å®£ä¼ã—ãƒªãƒ³ã‚¯ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã‚µã‚¤ãƒˆãŒç´¹ä»‹æ–™ã‚’ç²å¾—ã§ãã‚‹æ‰‹æ®µã‚’æä¾›ã™ã‚‹ã“ã¨ã‚’ç›®çš„ã«è¨å®šã•ã‚ŒãŸã‚¢ãƒ•ã‚£ãƒªã‚¨ã‚¤ãƒˆå®£ä¼ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã‚ã‚‹ã€ Amazonã‚¢ã‚½ã‚·ã‚¨ã‚¤ãƒˆãƒ»ãƒ—ãƒã‚°ãƒ©ãƒ ã®å‚åŠ è€…ã§ã™ã€‚ æˆ‘ã€…SEã¨ã„ã†è·ç¨®ã¯ã€ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã®ç¾å ´ã§å®Ÿã«æ§˜ã€…ãªãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ä½œã‚‰ã•ã‚Œã‚‹ã€‚ Wordã ã£ãŸã‚Šã€Excelã ã£ãŸã‚Šã€è¥¿æš¦2000å¹´ä»£ã¨ã„ã†æ™‚ä»£ã«ãŠã„ã¦å¯Œå£«é€šã®OASYSã§è¨è¨ˆæ›¸ã‚’æ›¸ã‹ã•ã‚ŒãŸã“ã¨ã‚‚ã‚ã‚‹ã€‚ ãã‚“ãªä¸ã€ã‚‚ã£ã¨ã‚‚å¥‡ã£æ€ªãªã®ã¯ã€ã‚„ã¯ã‚ŠExcelã§è¨˜è¿°ã•ã‚ŒãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã§ã‚ã‚ã†ã€‚ æœ¬æ¥ã€è¡¨è¨ˆç®—ã‚½ãƒ•ãƒˆã§ã‚ã‚‹ã¯ãšã®ExcelãŒã€ç¾å ´ã§ã©ã®ã‚ˆã†ãªä½¿ã‚ã‚Œæ–¹ã‚’ã•ã‚Œã¦ã„ã‚‹ã®ã‹ã€‚ç†è€…ã®çµŒé¨“ã—ãŸã€å¥‡å¦™ãªExcelãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®ã„ãã¤ã‹ã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã†ã€‚ â– Excelæ–¹çœ¼ç´™ ã„ã‚ãšã¨ã—ã‚ŒãŸã€SIæ¥ç•Œã®ä¼çµ±çš„æ‰‹æ³•ã€‚Excelæ–¹çœ¼ç´™ã§ã‚ã‚‹ã€‚ ã„ã¾ã‚„ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã®å…¬å¼Tipsã«ã‚‚ç™»å ´ã—ã€M
nakaji999 2011/05/31
æ–¹çœ¼ç´™ã€åŽŸç¨¿ç”¨ç´™ã¯è¦‹ãŸã“ã¨ã‚ã‚‹ã‘ã©â€¦ä¸–ç•Œã¯åºƒã„

Excel

ãƒã‚¿
ãƒªãƒ³ã‚¯
Windowsã®ã‚ãƒ©ãƒ¼ã‚¢ãƒ—ãƒªExcel - ãƒ—ãƒã‚°ãƒ©ãƒžã®æ€ç´¢
ãƒã‚±ãƒƒãƒˆé§†å‹•é–‹ç™ºã«ãŠã‘ã‚‹Excelã®å½¹å‰²ã«ã¤ã„ã¦ãƒ¡ãƒ¢ã€‚ ï¼ƒã‚ãã¾ã§ã‚‚ãƒ¡ãƒ¢æ›¸ãã€‚ å—è¨—é–‹ç™ºã§ã¯é¡§å®¢ã®æ¥å‹™ã®ã†ã¡Excelã§æ‰‹é‹ç”¨ã—ã¦ã„ã‚‹æ¥å‹™ã‚’ITåŒ–ã€WebåŒ–ã™ã‚‹ã“ã¨ã§ç‹™ã„æ’ƒã¡ã«ã—ã¦ã„ã‚‹ã®ã«ã€è‡ªåˆ†ãŸã¡ã®SWé–‹ç™ºã§ã¯ExcelãŒå¹…ã‚’åˆ©ã‹ã›ã¦ã„ã‚‹ã€‚ ã¤ã¾ã‚Šã€SWé–‹ç™ºã®æ¥å‹™ãã®ã‚‚ã®ã®ITåŒ–ã¯é…ã‚Œã¦ã„ã‚‹ã®ãŒç¾çŠ¶ã ã‚ã†ã€‚ ãªãœã€Excelã«ã‚ˆã‚‹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ã¯è‰¯ããªã„ã®ã‹ï¼Ÿ ãã®ç†ç”±ã¯ä¸‹è¨˜ã§æ›¸ã„ãŸã€‚ Excelã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ã¯ä½•æ•…è‰¯ããªã„ã®ã‹: ãƒ—ãƒã‚°ãƒ©ãƒžã®æ€ç´¢ ä¸€è¨€ã§è¨€ãˆã°ã€Excelã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯SVNãƒ»Mercurialãªã©ã§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã™ã¹ãã‹ã€Redmineã®ãƒã‚±ãƒƒãƒˆã‚„TestLinkã®ãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ãªã©ã§ä»£ç”¨ã§ãã‚‹ã‹ã€ä½¿ã„åˆ†ã‘ã‚‹ã“ã¨ãŒè‚å¿ƒã€‚ ã§ã¯ã€ãƒã‚±ãƒƒãƒˆé§†å‹•é–‹ç™ºã¯ä½•ã‚’ã‚‚ãŸã‚‰ã—ã¦ã„ã‚‹ã®ã‹ï¼Ÿ ãã®ç†ç”±ã¯ä¸‹è¨˜ã§æ›¸ã„ãŸã€‚ Excelã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ã‹ã‚‰è„±å´ã›ã‚ˆï½žSWæ§‹æˆç®¡ç†ã‚’è¦‹ç›´ãã†:
nakaji999 2010/08/22
Excel

TiDD
ãƒªãƒ³ã‚¯
Apache POIâ„¢ - Download Release Artifacts
This page provides instructions on how to download and verify the Apache POI release artifacts. There are different versions available depending on how stable your code should be. The latest stable release is Apache POI 5.3.0 Archives of all prior releases Apache POI releases are available under the Apache License, Version 2.0. See the NOTICE file contained in each release artifact for applicable
nakaji999 2010/06/09
POI

Java

Excel
ãƒªãƒ³ã‚¯
æœ€æ–°POIã§Office Open XMLå½¢å¼ã®Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ“ä½œä¸€è¦§
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
nakaji999 2010/06/09
POI

Excel

Java
ãƒªãƒ³ã‚¯
Excel
ã¯ã˜ã‚ã« å‘Šç™½ã™ã‚‹ã€‚ ç§ã¯ã€ã©ã†ã‚‚äººã‚ˆã‚Šç›¸å½“é ãŒæ‚ªã„ã‚‰ã—ãã€ ã¾ãŒã‚Šãªã‚Šã«ã‚‚ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã®ãƒ—ãƒã¨ã„ã†ã‹ã€ ãƒ—ãƒã‚°ãƒ©ãƒžã§é£¯ã‚’é£Ÿã£ã¦ã„ã‚‹èº«ã®çˆãªã®ã§ã‚ã‚‹ãŒã€ ã„ã‚ã‚†ã‚‹ã€Œè¡¨è¨ˆç®—ã‚½ãƒ•ãƒˆã€ã¨ã„ã†ã®ãŒ ä½•ãŒãªã‚“ã ã‹ã•ã£ã±ã‚Šã‚ã‹ã‚‰ãªã„ã®ã§ã‚ã‚‹ã€‚ ã¨ã¯ã„ãˆã€å‘¨ã‚Šã«ã¯ã€Excelå¤§å¥½ããªäººä¸€æ¯ã§ã‚ã‚‹(ã„ã‚„ã€ã‚‚ã¡ã‚ã‚“ã€ Excelã°ã‹ã‚ŠãŒè¡¨è¨ˆç®—ã§ã¯ãªã„ãŒã€ã‚„ã¯ã‚Šæ—¢ã«ä»£åè©žã«ã¯ãªã£ã¦ã—ã¾ã£ã¦ã„ã‚‹)ã€‚ ä¸æ€è°ãªã“ã¨ã«ã€è¡¨ã§ã‚‚ãªã‘ã‚Œã°è¨ˆç®—ã‚‚ã—ãªã„æ–‡æ›¸ã‚’ä½œã‚‹ã®ã«ã•ãˆã€ Excelã‚’ä½¿ã†äººãŒå¾Œã‚’çµ¶ãŸãªã„ã€‚ ãƒ•ãƒ„ãƒ¼ã®æ–‡æ›¸ã‚’ä½œã‚‹ã®ãªã‚‰ã€ã€Œè¡¨è¨ˆç®—ã€ã‚½ãƒ•ãƒˆã˜ã‚ƒãªãã¦ãƒ¯ãƒ¼ãƒ—ãƒã ã‚ã†ã€ ã¨æ€ã†ã®ã ãŒ... # ãˆ? Wordã¯ä½¿ã„ã«ãã„? # ã”ã‚‚ã£ã¨ã‚‚ã§ã™ã€‚å…¨é¢çš„ã«è³›æˆã—ã¾ã™(åˆ‡å®Ÿ)ã€‚ Excelä½¿ã£ã¦ã„ã‚‹äººã¯ã€å£ã‚’æƒãˆã¦ã€Œã“ã‚“ãªä¾¿åˆ©ãªã‚‚ã®ã¯ãªã„ã€ã¨è¨€ã†ã€‚ ã§ã‚‚ã€ã‚„ã£ã±ã‚Šã€ç§ã«ã¨ã£ã¦ã¯ã€ ã€Œä½•ãŒãªã‚“ã ã‹ã‚ã‹ã‚‰ãªã„ã€ ã®ã§ã‚ã‚‹ã€‚
nakaji999 2010/06/02
æ·±ãè€ƒãˆã‚‹äººã‚‚ã„ã‚Œã°ã€Excelæ–¹çœ¼ç´™ã‚’ä½•ã‚‚è€ƒãˆãšã«ä½¿ã„ã¾ãã‚‹äººã‚‚ã„ã‚‹ã€‚åœ§å€’çš„ã«å¾Œè€…ã®æ–¹ãŒå¤šã„ã®ãŒæ‚²åŠ‡ã®å§‹ã¾ã‚Šã€‚

Excel
ãƒªãƒ³ã‚¯
POIã‚’æ´»ç”¨ã—ã¦Excelã‹ã‚‰å¸³ç¥¨ã‚’ä½œæˆ
ã¯ã˜ã‚ã« POIã¯Javaã‹ã‚‰Microsoftã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’æ“ä½œã™ã‚‹ãŸã‚ã®APIã§ã€2007å¹´6æœˆã‹ã‚‰Apache Software Foundationã®ãƒˆãƒƒãƒ—ãƒ¬ãƒ™ãƒ«ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«æ ¼ä¸Šã’ã•ã‚Œã¾ã—ãŸã€‚ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦æä¾›ã•ã‚Œã¦ã„ã‚‹ã®ã§èª°ã§ã‚‚ç„¡å„Ÿã§åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãªãœåˆæœŸã®ãƒªãƒªãƒ¼ã‚¹å¾Œã€7å¹´ä»¥ä¸Šã‚‚çµŒéŽã—ã€å¤šãã®æƒ…å ±ãŒå˜åœ¨ã™ã‚‹POIã‚’ä»Šå›žã‚ã‚‰ãŸã‚ã¦å–ã‚Šä¸Šã’ã‚‹ã“ã¨ã«ã—ãŸã‹ã¨è¨€ã†ã¨ã€2009å¹´9æœˆãƒªãƒªãƒ¼ã‚¹ã®Version 3.5ã§Office Open XMLå½¢å¼ï¼ˆä»¥é™ã€OOXMLå½¢å¼ï¼‰ã¸ã®å¯¾å¿œã¨ã„ã†å¤§ããªå¤‰æ›´ãŒåŠ ã‚ã£ãŸã‹ã‚‰ã§ã™ã€‚ åˆ†ã‹ã‚Šã‚„ã™ãã„ã†ã¨2007å½¢å¼ã®Excelï¼ˆxlsxï¼‰ã‚„Wordï¼ˆdocxï¼‰ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚‚æ‰±ãˆã‚‹ã‚ˆã†ã«ãªã£ãŸã¨ã„ã†ã“ã¨ã§ã™ã€‚ æœ¬é€£è¼‰ã§ã¯ã€POIã®ä¸ã‹ã‚‰Excelã‚’æ“ä½œã™ã‚‹ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆï¼ˆHSSF/XSSFï¼‰ã«å¯¾è±¡ã‚’çµžã‚Šã€ä¸‹è¨˜ã®äºˆå®šã§ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ æº–
nakaji999 2010/05/18
POI

Java

Excel
ãƒªãƒ³ã‚¯
2010-04-13
ã¶ã£ã¡ã‚ƒã‘ã€åƒ•ã®ç¿’ç†Ÿåº¦ãŒé«˜ã„è¨€èªžãŒVBScriptãªã ã‘ã€‚ã¨ã„ã†è©±ã§ã‚‚ã‚ã‚‹ã®ã§ã™ãŒã€‚ ã¡ãªã¿ã«ã‚¢ãƒ³ãƒ“ã‚¨ãƒ³ãƒˆã£ã¦ã®ã¯ã€ é›»åæ›¸ç±ã®è¡æ’ƒ (ãƒ‡ã‚£ã‚¹ã‚«ãƒ´ã‚¡ãƒ¼æºæ›¸) ã§è¨€åŠã•ã‚Œã¦ã„ã‚‹è¨€è‘‰ã§ã€åƒ•ã®è§£é‡ˆã ã¨ã‚·ãƒ¼ãƒ ãƒ¬ã‚¹ã¨ã‹ã€ã‚¹ãƒˆãƒ¬ã‚¹ãƒ•ãƒªãƒ¼ãªã¨ã„ã†æ„å‘³ã ã¨æ€ã£ã¦ã¾ã™ã€‚ é›»åæ›¸ç±ã¯ã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸã‚‰ã™ãèªã‚ã‚‹ã¿ãŸã„ãªã“ã¨ã€‚ ä»Šã¾ã§ã¿ãŸã„ã«ã€USBã‚±ãƒ¼ãƒ–ãƒ«ã«ã¤ãªã„ã§è»¢é€ã®ã‚ˆã†ãªæ‰‹é–“ã¯ä¸è¦ã§ã™ã‚ˆã€‚ã¿ãŸã„ãªæ–‡è„ˆã§ä½¿ã„ã¾ã™ã€‚ å®¢è¦³çš„ã«è¦‹ãŸVBScript(WSH)ã®åˆ©ç‚¹ã¯ã€ ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ä¸è¦ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã§ã‚ã‚‹ã€‚ æœ€è¿‘ã®Windowsã«ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã€‚åˆ¥é€”ãƒ©ãƒ³ã‚¿ã‚¤ãƒ ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒä¸è¦ã€‚é…å¸ƒã«æ°—ã‚’ä½¿ã‚ãªã„ã€‚ Officeç³»ã‚¢ãƒ—ãƒª(ç‰¹ã«Excel)ã¨ã®é€£æºãŒå®¹æ˜“ ãƒ‰ãƒ©ãƒƒã‚°ã‚¢ãƒ³ãƒ‰ãƒ‰ãƒãƒƒãƒ—ãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ã€‚ ã¨ã„ã†ã¨ã“ã‚ã€‚ ç‰¹ã«ã€ãƒ‰ãƒ©ãƒƒã‚°ã‚¢ãƒ³ãƒ‰ãƒ‰ãƒãƒƒãƒ—ãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ã£ã¦ã®ã¯ã€ ã‚¢ãƒ³ãƒ“ã‚¨ãƒ³
nakaji999 2010/04/14
Java

Excel

tips
ãƒªãƒ³ã‚¯
1