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

InoHiro id:InoHiro

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

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

ç¬¬ä¸‰åå››å›ž èª°ã§ã‚‚ã‚ã‹ã‚‹ï¼†ã§ãã‚‹ï¼VLOOKUPé–¢æ•°å…¥é–€ã‚¬ã‚¤ãƒ‰
ã¤ã„ã«å‡ºãŸï¼ã€ŒVLOOUKPé–¢æ•°ã‚¬ã‚¤ãƒ‰ã€ã®æ±ºå®šç‰ˆï¼ã‚ã®ã‚„ã‚„ã“ã—ã™ãŽã‚‹æ•°å¼ã®ã›ã„ã§ä½¿ã†äº‹ã‚’æ–å¿µã—ã¦ã„ãŸãã“ã®ã‚¢ãƒŠã‚¿ï¼ã”å®‰å¿ƒãã ã•ã„ã€‚ã“ã‚Œã§ä»Šæ—¥ã‹ã‚‰ä½¿ã„ã“ãªã›ã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ï¼ï¼ Excelã®å…¥åŠ›ä½œæ¥ã§ã€æ™‚é–“ã‚’ç„¡é§„ã«ã—ã¦ã„ã¾ã›ã‚“ã‹ï¼Ÿ ä¾‹ãˆã°ã€æ¯Žæœˆä½œæˆã™ã‚‹è«‹æ±‚æ›¸ã€‚ ã€Œå•†å“åã¯â€¦ã‚¹ãƒ†ã‚£ãƒƒã‚¯â€¦ã®ã‚Šã€å˜ä¾¡ãŒâ€¦ãˆãƒ¼ã£ã¨200å††ã€ã¨ã„ã¡ã„ã¡æ‰‹å…¥åŠ›ã—ã¦ã„ã‚‹ã‚ãªãŸã¯ã€ æ®‹å¿µãªãŒã‚‰ExcelåŠäººå‰ï¼ ã“ã‚“ãªã¨ãã€ã€ŒExcelã§ãã‚‹äººã€ãŒå¿…ãšã¨è¨€ã£ã¦ã„ã„ã»ã©ä½¿ã£ã¦ã„ã‚‹ã®ãŒã€VLOOKUPé–¢æ•°ã§ã™ã€‚ ã“ã®é–¢æ•°ã‚’ä½¿ãˆã°ã€ãƒ‡ãƒ¼ã‚¿å…¥åŠ›ãŒé£›èºçš„ã«ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚¢ãƒƒãƒ—ã™ã‚‹ã‚“ã§ã™ã‚ˆï¼ ã“ã®ã‚ˆã†ã«ãƒ‡ãƒ¼ã‚¿ã‚’è‡ªå‹•å…¥åŠ›ã—ã¦ãã‚Œã‚‹ã®ã§ã€VLOOKUPé–¢æ•°ã‚’ä½¿ã†ã‹ä½¿ã‚ãªã„ã‹ã§ä½œæ¥æ™‚é–“ãŒ ä½•å€ã‚‚å¤‰ã‚ã£ã¦ãã‚‹ã®ã§ã™ã€‚ â€¦ã¨éžå¸¸ã«ä¾¿åˆ©ãªVLOOKUPé–¢æ•°ã§ã™ãŒã€å®Ÿã¯ã€Œæ•°å¼ãŒé•·ãã¦ã‚„ã‚„ã“ã—ã„ï¼ã€ã¨è‹¦æ‰‹æ„è˜ã‚’æŒã¤äººãŒ å¤šã„é–¢æ•°ã§ã‚‚ã‚ã‚Šã¾ã™ã€‚ ãã“ã§ä»Šå›žã¯
InoHiro 2016/11/22
Excel
ãƒªãƒ³ã‚¯
ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã€ã€ŒExcel REST API for Office 365ã€æ£å¼ãƒªãƒªãƒ¼ã‚¹ã€‚ä¿å˜ã•ã‚ŒãŸExcelã®ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã«APIã§ã‚¢ã‚¯ã‚»ã‚¹å¯èƒ½
ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã€ã€ŒExcel REST API for Office 365ã€æ£å¼ãƒªãƒªãƒ¼ã‚¹ã€‚ä¿å˜ã•ã‚ŒãŸExcelã®ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã«APIã§ã‚¢ã‚¯ã‚»ã‚¹å¯èƒ½ å¤šãã®ä¼æ¥ã§æ´»ç”¨ã•ã‚Œã¦ã„ã‚‹Excelã€‚å–¶æ¥éƒ¨é–€ãŒå„å–¶æ¥æ‹…å½“ã®é€²æ—çŠ¶æ³ã‹ã‚‰å£²ä¸Šã’ã‚’äºˆæ¸¬ã™ã‚‹Excelã‚·ãƒ¼ãƒˆã‚’ä½œæˆã—ã¦ã„ãŸã‚Šã€çµŒç†éƒ¨é–€ãŒçµŒè²»ã®é…è³¦ã‚’Excelã®ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã§ç®¡ç†ã—ã¦ã‚‹ã€ãªã©ã¨ã„ã†ä¾‹ã‚‚å°‘ãªããªã„ã§ã—ã‚‡ã†ã€‚ ä¸€èˆ¬çš„ã«ã“ã†ã—ãŸExcelã§ä½œã‚Šè¾¼ã¾ã‚ŒãŸç¤¾å†…ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ—¢å˜ã®æ¥å‹™ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«çµ„ã¿è¾¼ã‚€ãŸã‚ã«ã¯ã€ã„ã¡ã©Excelã§ä½œã‚Šè¾¼ã¾ã‚ŒãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è§£æžã—ã€ã‚ã‚‰ãŸã‚ã¦ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§çµ„ã¿ç«‹ã¦ç›´ã™å¿…è¦ãŒã‚ã‚Šã¾ã—ãŸã€‚ ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆãŒæ£å¼ã«ãƒªãƒªãƒ¼ã‚¹ã—ãŸã€ŒExcel REST API for Office 365ã€ã‚’ç”¨ã„ã‚‹ã¨ã€OneDriveï¼ˆè£œè¶³ï¼šä½¿ãˆã‚‹ã®ã¯OneDrive for Businessï¼‰ã«ä¿å˜ã—ãŸExce
InoHiro 2016/08/06
Excel
ãƒªãƒ³ã‚¯
Excel 2016ã§UTF-8ã®CSVãƒ•ã‚¡ã‚¤ãƒ«ãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ | åˆå¿ƒè€…å‚™å¿˜éŒ²
ãƒ›ãƒ¼ãƒ Officeé–¢é€£, Office 2013 Excel 2013ã§è¿½åŠ ã•ã‚ŒãŸã€ŒWEBSERVICEã€é–¢æ•°ã‚’ä½¿ã£ã¦ã€ãƒžã‚¯ãƒã‚’ä½¿ã‚ãšWeb APIã‚’åˆ©ç”¨ã™ã‚‹ã€‚ Microsoft Office 2013ãŒç™»å ´ã—ã€Excelã«ã‚‚æ–°ã—ã„é–¢æ•°ãŒã„ãã¤ã‹è¿½åŠ ã•ã‚Œã¾ã—ãŸã€‚ ãã®ä¸ã§ã‚‚ç§ãŒç‰¹ã«æ³¨ç›®ã—ãŸã„ã®ãŒã€ŒWebã€é–¢é€£ã®é–¢æ•°ã§ã™ã€‚ ã€ŒWEBSERVICEã€ã€ŒENCODEURLã€ã€ŒFILTERXMLã€ã®3ã¤ã®é–¢æ•°ãŒè¿½åŠ ã•ã‚Œã€ã“ã‚Œã‚‰ã®é–¢æ•°ã‚’ä½¿ã†ã¨ã€Webã‚µãƒ¼ãƒ“ã‚¹ã€ã¤ã¾ã‚Šå…¬é–‹ã•ã‚Œã¦ã„ã‚‹Web APIã‚’VBAã§ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãã“ã¨ãªãåˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ã¾ãšã¯é–¢æ•°ã®èª¬æ˜Žã‹ã‚‰ã€‚ ãƒ»ENCODEURL(æ–‡å—åˆ—)ï¼šURL ã«ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ã•ã‚ŒãŸæ–‡å—åˆ—ã‚’è¿”ã—ã¾ã™ã€‚ ãƒ»FILTERXML(xml,xpath)ï¼šæŒ‡å®šã•ã‚ŒãŸ XPath ã«å¾“ã£ã¦ã€XML ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã®ç‰¹å®šãƒ‡ãƒ¼ã‚¿ã‚’è¿”ã—ã¾ã™ã€‚ ãƒ»WEBSERVICE(u
InoHiro 2015/07/12
ã“ã‚“ãªã“ã¨ã§ãã‚‹ã®ã‹...

Excel
ãƒªãƒ³ã‚¯
é€£ç¶šãƒ‡ãƒ¼ã‚¿ã®ä½œæˆã§é€£ç•ªå…¥åŠ›ãªãŒãƒ¼ã„é€£ç•ªå…¥åŠ›ã‚‚ãƒ¯ã‚¶ã§ç°¡å˜ï¼ï½žExcelã®åˆç´šæŠ€
é€£ç•ªå…¥åŠ›ã¯ã€ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã§ç°¡å˜ã«å…¥åŠ›ã§ãã‚‹ã®ã¯ã€ã™ã§ã«çŸ¥ã£ã¦ã„ã‚‹ã€‚ ã—ã‹ã—ã€500ã¨ã‹1000ã¨ã‹ã«ãªã£ã¦ãã‚‹ã¨ã€ç°¡å˜ã«ã¯ã„ã‹ãªã„ã€‚å‹¢ã„ãŒã¤ã„ã¦ã€ãƒ”ãƒƒã‚¿ãƒªã¨ã¾ã‚‰ãªã„ã‚“ã ã€‚ ãƒã‚¤ãƒ³ãƒˆ 500ç•ª1000ç•ªã¨ã„ã£ãŸé•·ã„é€£ç•ªã«ã¯ã€ãƒ•ã‚£ãƒ«ã®ã€Œé€£ç¶šãƒ‡ãƒ¼ã‚¿ã®ä½œæˆã€ã¨ã„ã†æ‰‹ãŒã‚ã‚‹ã€‚ Excelãƒãƒ¼ã‚¸ãƒ§ãƒ³ï¼šALL20162013201020072003~ ãªãŒãƒ¼ã„é€£ç•ªå…¥åŠ›ã‚‚ãƒ¯ã‚¶ã§ç°¡å˜ï¼ é€£ç•ªå…¥åŠ›ã«ä¾¿åˆ©ãªã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«æ©Ÿèƒ½ã€‚1,2,3â€¦ã¨é€£ç¶šã—ãŸæ•°å€¤ã‚‚ãƒ•ã‚£ãƒ«ãƒãƒ³ãƒ‰ãƒ«ï¼ˆã‚»ãƒ«å³ä¸‹ã®ã€Œï¼‹ã€ï¼‰ã‚’ãƒ‰ãƒ©ãƒƒã‚°ã™ã‚‹ã ã‘ã§å…¥åŠ›ã§ãã‚‹ã¨ã„ã†ãƒ¯ã‚¶ã§ã—ãŸã€‚ã€åŸºæœ¬æ“ä½œã§ç´¹ä»‹ã€‘ ã§ã‚‚1000ä»¥ä¸Šã«ãªã‚‹ã‚ˆã†ãªé•·ã„é€£ç•ªã‚’å…¥åŠ›ã™ã‚‹ã¨ãã«ã¯ã€ãƒ‰ãƒ©ãƒƒã‚°ã‚‚é›£ã—ã„ã‚‚ã®ã§ã™ã€‚ãã‚“ãªã¨ãã¯ã€ãƒ¡ãƒ‹ãƒ¥ãƒ¼æ“ä½œã‚’ä½¿ã„ã¾ã—ã‚‡ã†ã€‚
InoHiro 2014/08/05
Excel
ãƒªãƒ³ã‚¯
TechCrunch | Startup and Technology News
VCs are clamoring to invest in hot AI companies, willing to pay exorbitant share prices for coveted spots on their cap tables. Even so, most arenâ€™t able to get into such deals at all. Yet, small, unknown investors, including family offices and high-net-worth individuals, have found their own way to get shares of the hottestâ€¦
InoHiro 2014/02/11
ã™ã”ãã†ã«è¦‹ãˆã‚‹

BI

Excel
ãƒªãƒ³ã‚¯
ç©ã¿ä¸Šã’ç¸¦æ£’ã‚°ãƒ©ãƒ•2æœ¬ã‚’ä¸¦ã¹ã¦æœˆã”ã¨ã®å‰å¹´å¯¾æ¯”ãŒã§ãã‚‹ã‚°ãƒ©ãƒ•ã‚’ä½œæˆ
ã¾ãšã¯ã€å…ƒãƒ‡ãƒ¼ã‚¿ã«ãªã‚‹è¡¨ã‚’ä¸‹ã®ã‚ˆã†ã«ä½œæˆã—ã¾ã™ã€‚ å„æœˆã®é–“ã«ã¯ç©ºç™½åˆ—ã‚’æŒ¿å…¥ã—ã¦ã€ä¸€ç•ªä¸Šã®ã‚»ãƒ«ã«ã¯ç©ºç™½ã‚¹ãƒšãƒ¼ã‚¹ã‚’å…¥åŠ›ã—ã¦ãŠãã¾ã™ã€‚ ï¼ˆæ¨ªè»¸ã®æœˆã‚’ä¸å¤®æƒãˆã«ã™ã‚‹ãŸã‚ã§ã™ã€‚ï¼‰ ç©ã¿ä¸Šã’ç¸¦æ£’ã‚°ãƒ©ãƒ•ã®ä½œæˆ ä½œæˆã—ãŸè¡¨ã‚’é¸æŠžã—ã¦ã€ï¼»æŒ¿å…¥ï¼½ã‚¿ãƒ–ã‹ã‚‰ï¼»ç©ã¿ä¸Šã’ç¸¦æ£’ï¼½ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ ã‚°ãƒ©ãƒ•ãŒä½œæˆã§ãã¾ã—ãŸã€‚ã“ã“ã‹ã‚‰å°‘ã—ç·¨é›†ã—ã¾ã™ã€‚ ï¼»ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã®é¸æŠžï¼½ã§ç·¨é›† ã‚°ãƒ©ãƒ•ã‚¨ãƒªã‚¢ã‚’é¸æŠžã—ãŸã¾ã¾ã€ï¼»ãƒ‡ã‚¶ã‚¤ãƒ³ï¼½ã‚¿ãƒ–ã®ï¼»ãƒ‡ãƒ¼ã‚¿ï¼½ã‚°ãƒ«ãƒ¼ãƒ—ã«ã‚ã‚‹ï¼»ãƒ‡ãƒ¼ã‚¿ã®é¸æŠžï¼½ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ ï¼»ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã®é¸æŠžï¼½ãƒ€ã‚¤ã‚¢ãƒã‚°ãƒœãƒƒã‚¯ã‚¹ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ ï¼»å‡¡ä¾‹é …ç›®ï¼½ã®ï¼»åŒºåˆ†ï¼½ã¯ä¸è¦ãªã®ã§ã€é¸æŠžã—ã¦ï¼»å‰Šé™¤ï¼½ãƒœã‚¿ãƒ³ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ ãã®ã¾ã¾ï¼»æ¨ªï¼ˆé …ç›®ï¼‰è»¸ãƒ©ãƒ™ãƒ«ï¼½ã®ï¼»ç·¨é›†ï¼½ãƒœã‚¿ãƒ³ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ ï¼»è»¸ãƒ©ãƒ™ãƒ«ã®ç¯„å›²ï¼½ã‚’å¹´åº¦ãŒå…¥åŠ›ã•ã‚ŒãŸã‚»ãƒ«ç¯„å›²ã¾ã§æ‹¡å¤§ã—ã¾ã™ã€‚ ã“ã“ã§ã¯ã€ã‚»ãƒ«ï¼»B1ï¼½ã‹ã‚‰ã‚»ãƒ«ï¼»L2ï¼½ã¾ã§ã«ãªã‚Šã¾ã™ã€‚ ï¼»OKï¼½ãƒœã‚¿ãƒ³ã‚’ã‚¯ãƒªãƒƒã‚¯
InoHiro 2014/02/10
Excel
ãƒªãƒ³ã‚¯
<4D6963726F736F667420576F7264202D20457863656C82C58376838D834F8389838082F08F9182AD>
Excel ã§ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æ›¸ã è©è°· æ˜Œå·± ï¼ˆæ±å¤§ãƒ»æƒ…å ±ç†å·¥ï¼‰ å…¥é–€çš„ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°æ•™è‚²ã®ãŸã‚ã«Excelãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’æå”±ã™ã‚‹ï¼Žå®Ÿéš›ã«ï¼ŒExcelã‚’ç”¨ã„ã¦ç´ å› æ•°åˆ†è§£ï¼Œã‚¨ãƒ©ãƒˆã‚¹ãƒ†ãƒã‚¹ã®ç¯©ï¼Œã‚½ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ï¼Œå‹•çš„ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãªã©ã®å„ç¨®ã®ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã‚’ å®Ÿè£…ã—ï¼Œãã®å¯èƒ½æ€§ã¨é™ç•Œã‚’è°è«–ã™ã‚‹ï¼Žã¾ãŸï¼Œãã®çµŒé¨“ã«åŸºã¥ã„ã¦ Excel ã«å¯¾ã™ã‚‹æ‹¡å¼µã®ææ¡ˆ ã‚’è¡Œã†ï¼Žä»¥ä¸Šã«å…ˆç«‹ã£ã¦ï¼ŒExcel ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’è€ƒãˆã‚‹å¥‘æ©Ÿã¨ãªã£ãŸæ±å¤§å‰æœŸèª²ç¨‹ã«ãŠã‘ã‚‹æƒ… å ±æ•™è‚²ã«ã¤ã„ã¦æ¦‚è¦³ã™ã‚‹ï¼Ž èƒŒæ™¯ã¨å‹•æ©Ÿ æ±å¤§é§’å ´ï¼ˆå‰æœŸèª²ç¨‹ï¼‰ã®æƒ…å ±ã«é–¢ã™ã‚‹ç§‘ç›®ã¯äºŒã¤ã‚ã‚‹ï¼Žä¸€ã¤ã¯ä¸€å¹´ç”Ÿå¤å¦æœŸã®æ–‡ç†å…±é€šã®å¿…ä¿® ç§‘ç›®ã§ã‚ã‚‹ã€Œæƒ…å ±ã€ã§ã‚ã‚Šï¼ˆå·åˆæ…§ç›£ä¿®ã€Œæƒ…å ±ã€æ±å¤§å‡ºç‰ˆä¼šï¼‰ï¼Œã“ã®æŽˆæ¥ã§ã¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã¯æ•™ãˆãªã„ï¼Ž ã‚‚ã†ä¸€ã¤ã®ã€Œæƒ…å ±ç§‘å¦ã€ã¯ï¼Œä¸€å¹´ç”Ÿå†¬å¦æœŸã®ç†ç§‘ã®ã‚¯ãƒ©ã‚¹æŒ‡å®šï¼ˆé¸æŠžï¼‰ã®ç§‘ç›®ã§ã‚ã‚Šï¼Œæƒ…å ±ã®åŸºç¤Žæ¦‚å¿µ ã«åŠ ãˆã¦ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã«ã¤ã„ã¦ã‚‚å¦ã¶ï¼Žã“ã“ã§
InoHiro 2013/08/07
Excel
ãƒªãƒ³ã‚¯
Microsoftã€Excelã§ã‚¤ãƒ³ã‚¿ãƒ©ã‚¯ãƒ†ã‚£ãƒ–ãª3Dåœ°å›³ä¸Šã‚°ãƒ©ãƒ•ã‚’ä½œã‚Œã‚‹ã‚¢ãƒ‰ã‚¤ãƒ³ã€ŒGeoFlowã€ã‚’ç™ºè¡¨
ç±³Microsoftã®ç ”ç©¶éƒ¨é–€ã§ã‚ã‚‹Microsoft Researchã¯4æœˆ11æ—¥ï¼ˆç¾åœ°æ™‚é–“ï¼‰ã€Microsoft Excelã®ã‚¢ãƒ‰ã‚¤ãƒ³ã€ŒGeoFlowã€ã®ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ç‰ˆã‚’å…¬é–‹ã—ãŸã¨ç™ºè¡¨ã—ãŸã€‚Excelã®ãƒ‡ãƒ¼ã‚¿ã‚’åœ°å›³ä¸Šã®3Dã‚°ãƒ©ãƒ•ã«è¦–è¦šåŒ–ã—ã€ãƒ‡ãƒ¼ã‚¿ã‚’è¦–è¦šçš„ã«åˆ†æžã—ãŸã‚Šã€åœ°å›³ä¸Šã‚’ç§»å‹•ã—ãŸã‚Šæ™‚é–“è»¸ã‚’ç§»å‹•ã—ãŸã‚Šã§ãã‚‹â€œã‚¤ãƒ³ã‚¿ãƒ©ã‚¯ãƒ†ã‚£ãƒ–ãªãƒ„ã‚¢ãƒ¼â€ã‚’ä½œæˆã§ãã‚‹ã€‚ ã€Œ"GeoFlow" Preview for Excel 2013ã€ã¯Microsoftã®Download Centerã‹ã‚‰ç„¡æ–™ã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚åˆ©ç”¨ã™ã‚‹ã«ã¯ã€Windows 2008 R2ï¼ˆ.NET Framework 4.0ãŒå¿…è¦ï¼‰ï¼Windows 7ï¼Windows 8ä¸Šã®Office Professional Plus 2013ã‚ã‚‹ã„ã¯Office 365 ProPlusãŒå¿…è¦ã€‚ã¾ãŸã€Bing Mapsã®ãƒ‡ãƒ¼ã‚¿ã‚’åˆ©ç”¨ã™ã‚‹ãŸã‚ã€ã‚¤
InoHiro 2013/04/16
Excel
ãƒªãƒ³ã‚¯
Excelã§LTSVèªã‚€ã‚ˆãƒ¼ - aikeâ€™s blog
LTSVãŒæœ€è¿‘ç†±ã„ã§ã™ãã€‚ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã¯ã“ã‚Œã§æ±ºã¾ã‚Šã€ã¿ãŸã„ãªã€‚ ã¨ã¯ã„ãˆã€æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã ã¨ã„ã¾ã ã«äººæœˆè¨ˆç®—ã¨ã‚¹ãƒ¼ãƒ„ã¨Excelã®ä¸–ç•Œãªã®ã§ã€ä¸Šå¸ã«æå‡ºã™ã‚‹å ´åˆã¨ã‹ãã®ã‚ãŸã‚Šã®è¦ªå’Œæ€§ã‚’ãªã‚“ã¨ã‹ã—ãŸã„ã¨ã“ã‚ã§ã™ã€‚ ãã‚“ãªã‚ã‘ã§Excelã§LTSVã‚’èªã‚ã‚‹ã‚ˆã†ã«VBAã‚’æ›¸ã„ã¦ã¿ã¾ã—ãŸã€‚ã“ã‚Œã§ãƒã‚°ã‚’ç½«ç·šã§å›²ã£ãŸã‚Šã‚»ãƒ«ã«è‰²ã‚’ã¤ã‘ãŸã‚Šã§ãã¾ã™ï¼å¬‰ã—ã„ã®ã‹ã€ãã‚Œã€‚ Attribute VB_Name = "LtsvLoader" ' ' LtsvLoader.bas ' ' This program is licensed under the MIT License. ' Copyright 2013, aike (@aike1000) ' Option Explicit Dim gHash As Object Dim gMaxColumn As Integer Sub LoadLTSV
InoHiro 2013/02/14
LTSV

Excel
ãƒªãƒ³ã‚¯
1