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

sugimori id:sugimori

excelã«é–¢ã™ã‚‹sugimoriã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

WorkbookFactoryã‚’ä½¿ã† - æ—¥ã€…å¸¸ã€…
POIã§Excelãƒ¯ãƒ¼ã‚¯ãƒ–ãƒƒã‚¯ã‚’ä½¿ç”¨ã™ã‚‹å ´åˆã€ä½¿ç”¨ã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã®å½¢å¼ã«å¾“ã£ãŸWorkbookã®å…·è±¡ã‚¯ãƒ©ã‚¹ã§ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ç”Ÿæˆã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ä¾‹ã‚’æŒ™ã’ã‚‹ã¨ã€Excel97-2007ã§ã¯HSSFWorkbookã«ãªã‚Šã¾ã™ã€‚ InputStream stream = new FileInputStream("ãƒ•ã‚¡ã‚¤ãƒ«ã¸ã®ãƒ‘ã‚¹"); HSSFWorkbook workbook = new HSSFWorkbook(stream); HSSFã¯POIã§ã®Excel97-2007ãƒ•ã‚¡ã‚¤ãƒ«å½¢å¼ã‚’æŒ‡ã—ã¾ã™ã€‚2008ä»¥é™ã§ã¯XSSFã«ãªã‚Šã¾ã™ã€‚Excel2008å½¢å¼ã®ãƒ•ã‚¡ã‚¤ãƒ«ã§HSSFWorkbookã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ä½œã‚ã†ã¨ã—ã¦ã‚‚ä¾‹å¤–ãŒç™ºç”Ÿã—ã¾ã™ã®ã§ã€ã“ã®å ´åˆã¯XSSFWorkbookã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ç”Ÿæˆã—ãªãã¦ã¯ã„ã‘ã¾ã›ã‚“ã€‚ã§ã‚‚ãƒ•ã‚¡ã‚¤ãƒ«å½¢å¼ã‚’ã„ã¡ã„ã¡åˆ¤åˆ¥ã—ãŸã‚Šã€ä¾‹å¤–ã‚’ã‚ãƒ£ãƒƒãƒã—ã¦XSSFWorkbook
sugimori 2017/12/18
POI

Excel
ãƒªãƒ³ã‚¯
GitHub - nobeans/gexcelapi: GExcelAPI is a thin Groovy-ish wrapper library of not JExcelAPI but Apache POI.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
sugimori 2017/05/03
ã“ã‚Œä½¿ãŠã†

Excel

GExcelAPI

Groovy

POI
ãƒªãƒ³ã‚¯
åˆå¿ƒè€…å‘ã‘ã€ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆãŒæ•™ãˆã‚‹ã‚¨ã‚¯ã‚»ãƒ«ï¼ˆExcelï¼‰å…¥é–€ - æˆ¦ç•¥ã‚³ãƒ³ã‚µãƒ«ã«ã‚ˆã‚‹è»¢è·ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€æˆ¦ç•¥ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã§ã™ã€‚ ä»Šå›žã¯ç§ã®ã€Œç¤¾ä¼šäººã§ã‚ã‚Œã°ã“ã‚“ãã‚‰ã„ã¯æœ€ä½Žé™å‡ºæ¥ã¦ã‚ˆã€ã¨ã„ã†ãƒ•ãƒ©ã‚¹ãƒˆãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã¶ã¤ã‘ãŸã€Œã“ã‚Œã ã‘æœ€ä½Žé™çŸ¥ã£ã¦ã‚ã€ã§ã™ã€‚éžå¸¸ã«é•·ã„è¨˜äº‹ã§ã™ãŒã€ç›®æ¬¡ã‚’ã†ã¾ãæ´»ç”¨ã—ãªãŒã‚‰è‡ªåˆ†ã«å¿…è¦ãªéƒ¨åˆ†ã‚’èªã‚€ã‚ˆã†ã«ã—ã¦ä¸‹ã•ã„ã€‚ ã‚¨ã‚¯ã‚»ãƒ«ã§å‡ºæ¥ã‚‹ã“ã¨ ã‚ã‚‹ã¹ããƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆ/ä½œã£ã¦ã¯ãªã‚‰ãªã„ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆ åˆå¿ƒè€…ã§ã‚‚çŸ¥ã£ã¦ãŠãã¹ãé »å‡ºã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆ alt + e + s(altç³»ã¯é †ç•ªã«æŠ¼ã™)ã€€ï¼šå½¢å¼ã‚’é¸æŠžã—ã¦è²¼ã‚Šä»˜ã‘ ç¯„å›²é¸æŠžã®shift,ctrl ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆç”¨) alt+w+v+gã§ç½«ç·šéžè¡¨ç¤º shift+ctrl+1ã§ã‚«ãƒ³ãƒžè¡¨ç¤º,shift+ctrl+5ã§ï¼…è¡¨ç¤º ctrl+1ã§ã‚»ãƒ«ã®æ›¸å¼è¨å®š é–¢æ•°ï¼šå…Žã«ã‚‚è§’ã«ã‚‚vlookup! vlookup ãƒ”ãƒœãƒƒãƒˆãƒ†ãƒ¼ãƒ–ãƒ« åˆ†æžçµæžœã‚’ä¼ãˆã‚‹ãƒ»ã‚°ãƒ©ãƒ•ä½œæˆ ãƒ‡ãƒ¼ã‚¿ã ã‘ã§ã¯æ„å‘³ã‚’æˆã•ãªã„ã€æ¯”è¼ƒã‚’è¡Œã£ã¦åˆã‚ã¦æ„å‘³ãŒã‚ã‚‹ ç°¡å˜ãªåˆ†æžè¨è¨ˆã‚’ã‚„
sugimori 2016/05/07
ã‚ˆã—ã€‚çµåˆã‚„ã‚ã‚ˆã†ã€‚

Excel

ã‚¨ã‚¯ã‚»ãƒ«
ãƒªãƒ³ã‚¯
Railsã§Excelã‚’æ‰±ã†Gemã¾ã¨ã‚ - Qiita
# æ–°è¦ä½œæˆ book = Spreadsheet::Workbook.new sheet = book.create_worksheet(name: 'curry') # ã„ã‚ã„ã‚ãªæ–¹æ³•ã§ãƒ‡ãƒ¼ã‚¿ã‚’å…¥ã‚Œã‚‰ã‚Œã‚‹ # è¨ˆç®—å¼ã¯å…¥åŠ›ã§ããªã„ sheet.row(0).concat %w{å“å å˜ä¾¡ æ•°é‡ è¨ˆ} sheet[1,0] = 'ã«ã‚“ã˜ã‚“' sheet[1,1] = 80 sheet[1,2] = 1 sheet[1,3] = 80 row = sheet.row(2) row.push 50 row.push 2 row.push 100 row.unshift 'ãŸã¾ããŽ' sheet.row(3).replace [ 'ã˜ã‚ƒãŒã„ã‚‚', 40, 2, 80 ] sheet.row(4).push 'ç‰›è‚‰', 1, 200 sheet.row(4).insert 1, 200 shee
sugimori 2015/07/01
Excel

ruby
ãƒªãƒ³ã‚¯
Excelã®é›†è¨ˆã‚’SQLã§ãŠã“ãªã†æ–¹æ³•ã€‚VLOOKUP()ã‚„SUBTOTAL()ã®é™ç•Œã‚’è¶…ãˆã‚ï¼ï¼ - ã‚€ã‹ãï½ž ã©ã£ã¨ã€€ã“ã‚€
SELECT Products, count(*) as [cnt], sum(cost) as [sum] FROM [A$] GROUP BY Products æ“ä½œã¯ç°¡å˜ã€ã€ŒSQLã€ã‚·ãƒ¼ãƒˆã®B1ã‚»ãƒ«ã«ã«ä¸Šè¨˜æ–‡ã‚’è²¼ã‚Šã¤ã‘ã—ã¦ ãƒœã‚¿ãƒ³ã‚’æŠ¼ã™ã ã‘ã§ã™ï¼ï¼ ãªã‚“ã¨ã€ã‚·ãƒ¼ãƒˆåŒå£«ã‚’çµåˆã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ãªã®ã§vlookup()ã‚’ æŒ‡å®šã›ãšã¨ã‚‚ãŠæ‰‹è»½ä¾¿åˆ©ï¼ï¼ ä»–ã«ã‚‚ã„ã‚ã‚“ãªé›†è¨ˆæ–¹æ³•ã‚’ã‚µãƒ³ãƒ—ãƒ«ã§è¼‰ã›ã¦ãŠãã¾ã™ã€‚ /* Aã‚·ãƒ¼ãƒˆä¸€è¦§ */ select * from [A$] /* A,Bã‚·ãƒ¼ãƒˆä¸€è¦§ */ select * from [A$],[B$] where [A$].CID = [B$].CID /* ãƒãƒŠãƒŠã®è²©å£²æ•° */ select count(*) from [A$] where Products = 'ãƒãƒŠãƒŠ' /* ãƒãƒŠãƒŠã®å£²ä¸Š */ SELECT Products, sum(cost)
sugimori 2015/05/24
Excel

SQL
ãƒªãƒ³ã‚¯
VBScript : ADO ã§ Excel2007(Excel 2010ã€Excel 2013) ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹( ã‚·ãƒ¼ãƒˆã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã—ã¦èªã¿è¾¼ã‚€ ) : logicalã€€error
Excel2007(Excel 12.0) ã¨ Excel2010 ã¨ Excel2013ã§ç¢ºèªã—ã¾ã—ãŸã€‚ â€» Excel 2010 ã¯ã€Excel 14.0 ã ãã†ã§ã™ãŒã€æŽ¥ç¶šæ–‡å—åˆ—ã¯ Excel 12.0 ã§ã®ã¿å‹•ä½œã—ã¾ã—ãŸã€‚ Excel 2013(Windows8) ã§ã¯ã€Microsoft Access ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ã‚¨ãƒ³ã‚¸ãƒ³ 2010 å†é ’å¸ƒå¯èƒ½ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚( â€»å‚è€ƒ1ã€â€»å‚è€ƒ2 ) ( 32ãƒ“ãƒƒãƒˆç‰ˆã¨64ãƒ“ãƒƒãƒˆç‰ˆãŒã‚ã‚‹ã®ã§é¸æŠžã—ã¦ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¾ã™ ) IMEX=1 : æ¦‚è¦ã¨ã—ã¦ã¯ã€äºˆæœŸã—ãªã„åˆ—ã®å€¤ã®å¤‰åŒ–ã‚’æŠ‘åˆ¶ã—ã¦ãã‚Œã¾ã™ã€‚ä»•æ§˜çš„ã«ã¯ã€ã€Œintermixedã€ã§ã€ãƒ‡ãƒ¼ã‚¿è¡Œã‚’å¸¸ã«ãƒ†ã‚ã‚¹ãƒˆã¨ã—ã¦èªã¿å–ã‚‹ã“ã¨ã‚’ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã«æŒ‡ç¤ºã—ã¦ã„ã¾ã™ã€‚ã“ã¡ã‚‰ã‚’å‚ç…§ã—ã¦ä¸‹ã•ã„ é–¢é€£ã™ã‚‹ Microsoft ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ [HOWTO] Visua
sugimori 2015/05/05
Excel

ADO
ãƒªãƒ³ã‚¯
ã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ç¾é‡‘åŒ–ã®é«˜é‚„å…ƒçŽ‡ã®å„ªè‰¯åº—ã‚’é¸ã¶ãŸã‚ã«ã¯
ã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ç¾é‡‘åŒ–ã®é«˜é‚„å…ƒçŽ‡ã®å„ªè‰¯åº—ã‚’é¸ã¶ãŸã‚ã«ã¯ ã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ç¾é‡‘åŒ–ã®å„ªè‰¯åº—ã‚’é¸ã¶ãƒã‚¤ãƒ³ãƒˆã¯ã€æ›é‡‘çŽ‡ã‚„ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚‚ã‚ã‚Šã¾ã™ãŒã€ãã®ã»ã‹ã«ã‚‚è¦‹ã¦ãŠããŸã„ãƒã‚¤ãƒ³ãƒˆã‚‚ã‚ã‚Šã¾ã™ã€‚ ãŠé‡‘ã«åŽ³ã—ã„äººãŒåˆ©ç”¨ã—ã¾ã™ã®ã§ã€æ‰‹æ•°æ–™ã‚„ã‚ãƒ£ãƒ³ãƒšãƒ¼ãƒ³ã®æœ‰ç„¡ã€ä¾¡æ ¼äº¤æ¸‰ãŒã§ãã‚‹æ¥è€…ã¨ã„ã†ã“ã¨ã¯è¦‹ã¦ãŠããŸã„ã¨ã“ã‚ã§ã™ã€‚ ãã‚Œãžã‚Œã©ã®ã‚ˆã†ãªå†…å®¹ãªã®ã§ã—ã‚‡ã†ã‹ã€‚ æ‰‹æ•°æ–™ãŒç„¡æ–™ã§ã‚ã‚‹ã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ç¾é‡‘åŒ–ã®æ¥è€…ã«ã¯ã€æ‰‹æ•°æ–™ã‚’ã™ã¹ã¦ç„¡æ–™ã§ã—ã¦ãã‚Œã‚‹ã¨ã“ã‚ãŒã‚ã‚Šã¾ã™ã€‚ æ¥è€…ã«ã‚ˆã£ã¦ã¯ã€å˜ç´”ã«æ‰‹æ•°æ–™ã¨ã„ã†åç›®ã§æ¥è€…å´ã®åˆ©ç›ŠãŒã¨ã‚‰ã‚Œã¦ã„ãŸã‚Šã€æŒ¯è¾¼æ‰‹æ•°æ–™ã€äº‹å‹™æ‰‹æ•°æ–™ã¨ã„ã†åç›®ã§å°‘é¡ãªãŒã‚‰ãŠé‡‘ãŒã‹ã‹ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ã›ã£ã‹ãé«˜ã„æ›é‡‘çŽ‡ãŒè¨˜è¼‰ã•ã‚Œã¦ã„ã¦ã‚‚ã€æ‰‹æ•°æ–™ã®åˆ†ãŒå·®ã—å¼•ã‹ã‚Œã‚‹ã“ã¨ã§ã€æã‚’ã—ãŸã‚ˆã†ãªæ°—æŒã¡ã«ãªã£ãŸã‚Šå¾Œã‹ã‚‰æ°—ã¥ãã“ã¨ã‚‚ã‚ã‚Šã¾ã™ã€‚ ã“ã‚Œã‚‰ã®æ‰‹æ•°æ–™ã¯æœ€åˆã‹ã‚‰å…¬å¼ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã«è¨˜è¼‰ãŒã‚ã‚‹å ´åˆã¯äº†æ‰¿ã—ãŸã†ãˆã§ç”³ã—è¾¼ã¿ã‚‚ã§ã
sugimori 2015/05/05
WSH

Excel

JScript

ADO
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
sugimori 2015/05/05
excel
ãƒªãƒ³ã‚¯
WSH/JScriptã§ï¼ŒExcelãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿æ›¸ãã™ã‚‹éš›ã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã€€ï¼ˆã‚·ãƒ¼ãƒˆä¸Šã®å…¨è¡Œã‚’èªã¿æ›¸ãã™ã‚‹ã‚³ãƒ¼ãƒ‰ã®ã²ãªåž‹ï¼‰ - ä¸»ã«è¨€èªžã¨ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«é–¢ã—ã¦
ãƒãƒƒãƒã®ã¾ã¨ã‚TOPã¸ WSH/JScriptã®ãƒãƒƒãƒã§ï¼ŒExcelãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿æ›¸ãã™ã‚‹å ´åˆï¼Œ ä¸‹è¨˜ã®ã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ã‚’æ¯Žå›žï¼Œæ¯Žå›žã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã™ã‚‹ã€‚ ã“ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã¯é »ç¹ã«ä½¿ã†ãŸã‚ï¼Œãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆï¼ˆã‚¹ãƒ‹ãƒšãƒƒãƒˆï¼‰ã¨ã—ã¦æŽ²è¼‰ã€‚ ã‚³ãƒ¼ãƒ‰ã®é››å½¢ excelèªã¿æ›¸ã.bat @if(0)==(0) ECHO OFF rem WSHã‚³ãƒ¼ãƒ‰ã«å¼•æ•°ã‚’æ¸¡ã™ã€‚ rem ç¬¬ä¸€å¼•æ•°ï¼šã“ã®ãƒãƒƒãƒã®ãƒ•ã‚©ãƒ«ãƒ€ã®ãƒ‘ã‚¹ rem ç¬¬äºŒå¼•æ•°ï¼šã“ã®ãƒãƒƒãƒã«ãƒ‰ãƒãƒƒãƒ—ã•ã‚ŒãŸãƒ•ã‚¡ã‚¤ãƒ«ã®ãƒ•ãƒ«ãƒ‘ã‚¹ cscript.exe //nologo //E:JScript "%~f0" "%~dp0" "%~1" echo çµ‚äº†ã—ã¾ã—ãŸã€‚ @pause GOTO :EOF @end // å¼•æ•°ã‚’å–å¾— if( ( WScript.Arguments.length < 2 ) || ( WScript.Arguments.Unnamed(1) == "")
sugimori 2015/04/13
excel

jscript

wsh
ãƒªãƒ³ã‚¯
ã€é–¢æ•°ã€‘åŒã˜æ•°å¼ã§è¤‡æ•°åˆ—ã®è»¢è¨˜ãŒã§ãã‚‹ã€ŒVLOOKUPã€ã¨ã€ŒMATCHã€ã®çµ„ã¿åˆã‚ã›ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ | Excelã‚’åˆ¶ã™ã‚‹è€…ã¯äººç”Ÿã‚’åˆ¶ã™
Excelã§æ¶ˆè€—ã™ã‚‹äººã‚’æ¸›ã‚‰ã™ãŸã‚ã«å„ç¨®ãƒŽã‚¦ãƒã‚¦ã‚’å±•é–‹ä¸ã€‚ã‚ãªãŸã®Excelã‚¹ã‚ãƒ«ã®å‘ä¸ŠãŒã€åƒãæ–¹æ”¹é©ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ‰ãƒªãƒ–ãƒ³ãƒ»DXã‚’å®Ÿç¾ã™ã‚‹ç¬¬ä¸€æ©ã§ã™ã€‚
sugimori 2015/04/03
excel
ãƒªãƒ³ã‚¯
æ˜¨æ—¥ã¾ã§JavaJavaã—ã¦ãŸäººãŒã„ããªã‚ŠExcelã®VBAã‚’å®Ÿè£…ã™ã‚‹ç¾½ç›®ã«ãªã£ãŸã¨ãã®ãŸã‚ã®ãƒ¡ãƒ¢ - Qiita
Excel ã¯æ»…ã³ã¬ï¼ Excel ã®åŠ›ã“ãæ—¥æœ¬ä¼æ¥ã®å¤¢ã ã‹ã‚‰ã ï¼ VBA å®Ÿè£…ã—ã¦ã¦å¦ã‚“ã ã“ã¨ã¨ã‹ã®ãƒ¡ãƒ¢ã€‚ Java Java ã—ã¦ãŸã‹ã¯ã‚ã¾ã‚Šé–¢ä¿‚ãªã„ã‹ã‚‚ã€‚ #ã‚¨ãƒ‡ã‚£ã‚¿ã®ä½¿ã„æ–¹ ##ã‚¨ãƒ‡ã‚£ã‚¿ã‚’è¡¨ç¤ºã™ã‚‹ Alt + F11 ã§ VB ã‚¨ãƒ‡ã‚£ã‚¿ã‚’è¡¨ç¤ºã§ãã‚‹ã€‚ ##ç’°å¢ƒè¨å®š ###èƒŒæ™¯è‰²ãƒ»ãƒ•ã‚©ãƒ³ãƒˆã‚’èª¿æ•´ã™ã‚‹ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ç™½èƒŒæ™¯ã¨ã‹æ°—ãŒç‹‚ã†ã®ã§ã€æš—ã„è‰²ã«ã™ã‚‹ã€‚ ã€Œãƒ„ãƒ¼ãƒ«ã€â†’ã€Œã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€ã‚’é¸æŠžã—ã€ã€Œã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ã®è¨å®šã€ã‚¿ãƒ–ã‚’é–‹ãã€‚ ã€Œã‚³ãƒ¼ãƒ‰ã®è¡¨ç¤ºè‰²ã€ã‚’é¸æŠžã—ã¦ã€ã€ŒèƒŒæ™¯ã€ã®è‰²ã‚’é¸æŠžã™ã‚‹ã€‚ ã¤ã„ã§ã«ãƒ•ã‚©ãƒ³ãƒˆã‚‚è¦‹ã‚„ã™ã„ã‚„ã¤ã«å¤‰æ›´ã™ã‚‹ã€‚ ã“ã‚Œã ã‘ã§é–‹ç™ºåŠ¹çŽ‡ãŒï¼•å‰²å¢—ã—ã«ãªã‚‹ã€‚ ###ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ ####ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã‚’è¡¨ç¤ºã™ã‚‹ ã„ã‚ã‚†ã‚‹ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã«å½“ãŸã‚‹ã®ãŒã€__ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦__ã¨å‘¼ã°ã‚Œã‚‹ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã€‚ Ctrl + G ã§è¡¨ç¤ºã•ã‚Œã‚‹ã€‚ ####ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã«å‡º
sugimori 2015/03/05
VBA

excel
ãƒªãƒ³ã‚¯
ãƒ—ãƒã‚°ãƒ©ãƒžãŒè€ƒãˆã‚‹åŠ‡çš„ã«åŠ¹çŽ‡ãŒä¸ŠãŒã‚‹Excelã‚·ãƒ¼ãƒˆã®ä½œã‚Šæ–¹
ãã“ãã“ã®è¤‡é›‘ãªè¨ˆç®—ã‚’ã™ã‚‹ã®ã«Excelã¯ã‚‚ã®ã™ã”ãä¾¿åˆ©ã§ã™ã€‚ä½•ã‹ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã‚’ä½¿ã£ã¦æ›¸ã„ãŸã‚‰1æ™‚é–“ãã‚‰ã„ã‹ã‹ã‚‹ã‚ˆã†ãªè¨ˆç®—ãŒã€ã‚‚ã®ã®æ•°åˆ†ã§ã‚·ãƒ¼ãƒˆä¸Šã«ã§ãã‚ãŒã‚Šã¾ã™ã€‚ ã“ã®ç´ æ™´ã‚‰ã—ã„Excelã‚’ã€ã‚ˆã‚Šä½¿ã„ã‚„ã™ãã™ã‚‹ãƒ¯ã‚¶ã‚’ã€ãƒ—ãƒã‚°ãƒ©ãƒžçš„ãªè¦–ç‚¹ã‹ã‚‰æ›¸ããŸã„ã¨æ€ã„ã¾ã™ã€‚ æ‹¡å¼µæ€§ã®ãªã„ã‚·ãƒ¼ãƒˆ ãã†ã„ã†ã‚ã‘ã§ã€Excelã¯ç´ æ™´ã‚‰ã—ã„ã‚“ã§ã™ãŒã€ä½¿ã†äººã«ã‚ˆã£ã¦ã¯ãªã‚“ã¨ã‚‚ã€Œæ‹¡å¼µæ€§ã®ãªã„ã‚·ãƒ¼ãƒˆã€ãŒã§ãã‚ãŒã‚Šã¾ã™ã€‚ åƒ•ã¯ãƒ—ãƒã‚°ãƒ©ãƒžãªã®ã§ã€ã“ã†ã„ã†ç´ æ™´ã‚‰ã—ã„ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã„ã¯ã˜ã‚ã‚‹ã¨ã€ã©ã†ã—ã¦ã‚‚æ‹¡å¼µæ€§ã¨ã‹ä¿å®ˆæ€§ã¿ãŸã„ãªã‚‚ã®ãŒæ°—ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ãƒ—ãƒã‚°ãƒ©ãƒžã¯åŒã˜ã“ã¨ã‚’ç¹°ã‚Šè¿”ã™ã®ãŒè‹¦æ‰‹ã§ã™ã€‚ã‚·ãƒ¼ãƒˆã«ãƒ‡ãƒ¼ã‚¿ã‚’å…¥åŠ›ã—ã¦ã‹ã‚‰å®Œæˆå½¢ãŒã§ãã‚ãŒã‚‹ã¾ã§ã«äººæ‰‹ã‚’ä½¿ã†ã“ã¨ã‚’é¿ã‘ã¦ã€å…¨éƒ¨ã‚’è‡ªå‹•åŒ–ã—ãŸããªã‚Šã¾ã™ã€‚ æ¬¡ã®ã‚ˆã†ãªã“ã¨ã‚’ã—ã¦ã„ãŸã‚‰ã€Excelã‚’æ£ã—ãä½¿ãˆã¦ã„ãªã„ã‚ˆã†ãªæ°—ãŒã—ã¾ã™ã€‚ é€”ä¸ã§é›»å“ã‚’ä½¿ã£ã¦è¨ˆç®—ã—ã¦ã‚»ãƒ«ã‚’åŸ‹ã‚ã¦ã„
sugimori 2014/05/17
excel

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
PowerPivot for Excel 2010 ã¯ç„¡èŒ¶è‹¦èŒ¶ã‚¹ã‚´ã‚¤ï¼ï¼ï¼ - matu_takâ€™s blog
SQL Server 2008 R2 ã§æä¾›ã•ã‚Œã‚‹ Microsoft SQL Server PowerPivot for Excel 2010 CTP2ï¼ˆé–‹ç™ºã‚³ãƒ¼ãƒ‰å Geminiï¼‰ã‚’ã¡ã‚‡ã£ã¨è§¦ã£ã¦ã¿ã¾ã—ãŸã€‚PowerPivot ã¨ã„ã†åã®ã¨ãŠã‚Šã€ãƒ”ãƒœãƒƒãƒˆ ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¶…é€²åŒ–ç‰ˆã§ã€ã¨ã£ã¦ã‚‚ä¾¿åˆ©ã§ã™ï¼ ã„ã‚ã„ã‚ãªãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãŒã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ãã‚‹ã—ã€Web ãƒšãƒ¼ã‚¸ã‚„ Excel ã‚·ãƒ¼ãƒˆã‹ã‚‰ã‚‚ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ãã‚‹ã€‚ãã—ã¦ãªã‚“ã¨è¨€ã£ã¦ã‚‚ã‚¹ãƒ©ã‚¤ã‚µãƒ¼ï¼ ã„ã‚„ã€œãƒ›ãƒ³ãƒˆã«ã‚¹ã‚´ã‚¤ã€‚æ„Ÿå‹•ã§ã™ã€‚ ç¾åœ¨ã€PowerPivot for Excel 2010 ã®è‡ªç¿’æ›¸ã‚’ä½œæˆã—ã¦ã„ã‚‹ã®ã§ãŠæ¥½ã—ã¿ã«ï¼ 2010/07/27 è¿½è¨˜ï¼š PowerPivot for Excel 2010 ã®è‡ªç¿’æ›¸ã¯ã“ã¡ã‚‰ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ï¼ http://www.microsoft.com/japan/sqlserver/2008/
sugimori 2014/05/11
excel
ãƒªãƒ³ã‚¯
Pythonã§Excelã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’å‡ºåŠ›ã—ã‚ˆã†
æ–Žè—¤ã§ã™ã€‚ã“ã‚“ã«ã¡ã¯ã€‚ ä»Šæ—¥ã¯ã€Pythonã®"xlutils"ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’åˆ©ç”¨ã—ã¦Excelã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ç”Ÿæˆã‚’ã—ã¦ã¿ã¾ã™ã€‚ã€Œä½¿ã„æ–¹ã€ã€Œæ›¸å¼å®šç¾©ã®ã—ã‹ãŸã€ãã—ã¦ã€Œæ³¨æ„ç‚¹ã€ã®3ç‚¹ã«ã¤ã„ã¦ã€é †ã«ãŠè©±ã—ã—ã¾ã™ã€‚ Excelã‚’ç”¨ã„ã¦ã€ã‚µãƒ¼ãƒç®¡ç†å°å¸³ãªã©ã€ITã‚¤ãƒ³ãƒ•ãƒ©é‹ç”¨ã«ç”¨ã„ã‚‹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ä½œã‚‰ã‚Œã‚‹æ–¹ã‚‚ã„ã‚‰ã£ã—ã‚ƒã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ãã®ã¨ãã«ã€ã“ã‚Œã‹ã‚‰ãŠè©±ã—ã™ã‚‹"xlutils"ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ç”¨ã„ã‚‹ã¨ã€ãŠæ‰‹è£½CSVå‡ºåŠ›ãƒ„ãƒ¼ãƒ«ã‚„ã€ãã‚Œã“ã æ‰‹å‹• ã§ä½œã‚‹ã‚ˆã‚Šã‚‚æ‰‹é–“ã‚’çœãã¤ã¤Excelã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’ä½œæˆã§ãã¾ã™ã€‚ â€»Python 2.7.4, xlutils 1.6.0, xlwt 0.9.2, Excel for Mac 2011 (14.3.6), Mac OS 10.7.5 ã‚’ç”¨ã„ã¦æ¤œè¨¼ã—ã¦ã„ã¾ã™ ä½¿ã„æ–¹ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ã¨ã¦ã‚‚ç°¡å˜ã§ã™ã€‚ # easy_instal xlutils
sugimori 2013/11/14
python

excel
ãƒªãƒ³ã‚¯
Rubyã§Excelã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿è¾¼ã‚€
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®ä»•äº‹ã‚’ã—ã¦ã„ã‚‹ã¨ã€Œä»•æ§˜æ›¸(å†…éƒ¨å‘ã‘)ã€ã€Œã‚³ãƒ¼ãƒ‰ã€ã€Œãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ(å¤–éƒ¨å‘ã‘)ã€ã‚’ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„å ´åˆãŒã‚ã‚‹ã€‚ãã—ã¦ã€3ã¤ã‚’åˆ¥ã€…ã«ç®¡ç†ã™ã‚‹ã®ãŒé¢å€’ãªã®ã¯è¨€ã†ã¾ã§ã‚‚ãªã„ã€‚ ç§ã‚‚æ¥å‹™ã§ãã‚“ãªå ´é¢ã«å‡ºãã‚ã—ãŸã€‚ä»Šå›žã®ä»•äº‹ã§ã¯å¤–éƒ¨å‘ã‘ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ã‚ã‚‹ç¨‹åº¦ãã¡ã‚“ã¨æ›¸ãå¿…è¦ãŒå‡ºã¦ããŸãŸã‚ã€å®Ÿè£…ã¨ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«å·®ç•°ãŒå‡ºã‚‹ã®ã¯å¤§å¤‰ã¾ãšã„ã€ã¨ã„ã†äº‹æƒ…ã‚‚ã‚ã‚‹ã€‚ã©ã†ã—ãŸã‚‚ã‚“ã‹â€¦ã¨twitterã§ãƒœãƒ¤ã„ã¦ã„ãŸã‚‰ã€TLã‹ã‚‰â€™win32oleâ€˜ã®æŽ¨è–¦ã‚’ã„ãŸã ã„ãŸã€‚ æŽ¨è–¦ã„ãŸã ã„è¨˜äº‹ã¯ã€ã€Œã‚‹ã³ã¾ã€ã®æœ€æ–°å·ã«æŽ²è¼‰ã•ã‚Œã¦ã„ã‚‹ã€ŒVBA ã‚ˆã‚Šä¾¿åˆ©ã§æ‰‹è»½ Excel æ“ä½œã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã€ŒRubyã€ã¸ã®ãŠèª˜ã„ (å‰ç·¨)ã€ã¨ã„ã†è¨˜äº‹ã€‚ãªã‚“ã®ã“ã¨ã¯ãªã„è‘—è€…ã”æœ¬äººã‹ã‚‰æŽ¨è–¦ã„ãŸã ã„ãŸã€ã¨ã„ã†ã‚ã‘ã€‚twitterã¯ã€Œã™ã”ã„äººãŒèº«è¿‘ã«ã„ã‚‹ã€ã¨ã„ã†ã“ã¨ã‚’å†èªè˜ã—ãŸæ¬¡ç¬¬ã§ã‚ã‚‹ã€‚ ã§ã€ã•ã£ããä½¿ã£ã¦ã¿ãŸã¨ã“ã‚ã€ã“ã‚ŒãŒäºˆ
sugimori 2013/05/21
ã‚ˆã—ã€‚æ˜Žæ—¥çµ‚ã‚ã£ãŸã‚‰ã€ã“ã‚Œã‚„ã‚ã†ã€‚

ruby

ä»•äº‹

excel
ãƒªãƒ³ã‚¯
1