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

tuki0918 id:tuki0918

excelã«é–¢ã™ã‚‹tuki0918ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (50)

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

Office TANAKA - Excel Tips[VLOOKUPé–¢æ•°ã§0ã‚’è¿”ã•ãªã„]
VLOOKUPé–¢æ•°ã®ä½¿ã„æ–¹ã«é–¢ã—ã¦ã¯ã€ã“ã®é–¢æ•°ã¯ã“ã†ä½¿ãˆï¼ã€ŒVLOOKUPé–¢æ•°ã€ã‚’ã”è¦§ãã ã•ã„ã€‚ã•ã¦ã€ä¸‹å›³ã®ã‚ˆã†ãªè¡¨ãŒã‚ã£ãŸã¨ã—ã¾ã™ã€‚ VLOOKUPé–¢æ•°ã®ã€ã”ãã”ãåŸºæœ¬çš„ãªãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã™ã€‚ã§ã¯ã€ã‚‚ã—ã‚»ãƒ«B4ãŒç©ºæ¬„ã ã£ãŸã‚‰ã©ã†ã§ã—ã‚‡ã†ã€‚ ã”è¦§ã®ã‚ˆã†ã«ã€VLOOKUPé–¢æ•°ã¯0ã‚’è¿”ã—ã¾ã™ã€‚ç©ºæ¬„ãŒ0ã¨ãªã£ã¦ã—ã¾ã†ã‚“ã§ã™ãã€‚VLOOKUPé–¢æ•°ã®çµæžœãŒç©ºæ¬„ã ã£ãŸã¨ãã€0ã§ã¯ãªãç©ºæ¬„ã‚’è¿”ã™ã‚ˆã†ã«ã™ã‚‹ã«ã¯ã€ =VLOOKUP(D2,A2:B5,2,FALSE)&"" ã¨ã€æœ«å°¾ã«ã€Œ&""ã€ã‚’ã¤ã‘ã¾ã™ã€‚ã€Œ&ã€ã¯æ–‡å—åˆ—ã‚’çµåˆã™ã‚‹æ¼”ç®—åã§ã€ç©ºæ¬„ã§ã‚ã‚‹ã€Œ""ã€ã‚’çµåˆã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã€0ã‚’ç©ºæ¬„ã«å¤‰æ›ã§ãã¾ã™ã€‚
tuki0918 2014/03/13
excel
ãƒªãƒ³ã‚¯
PHPExcelã‚’CakePHPã§ä½¿ã£ã¦ã¿ã‚‹ â€“ å¤§é˜ªã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºãƒ»WEBã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºä¼šç¤¾æŠ€è¡“æ‹…å½“ã‚¹ã‚¿ãƒƒãƒ•ã®è¦šæ›¸ãã€åã ã¬ãã®æŠ€è¡“ç¿’å¾—ãƒŽãƒ¼ãƒˆ
ã‚·ã‚¹ãƒ†ãƒ ã‚’ä½œã£ã¦ã„ã‚‹ã¨ã€ãŠå®¢æ§˜ã‹ã‚‰ã‚ˆãã€Œã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’Excelã§ä½¿ã„ãŸã„ã€ã¨ã„ã†ã“ã¨ã‚’ãŠèžãã—ã¾ã™ã€‚ å¤§æŠµã®å ´åˆCSVå½¢å¼ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡ºåŠ›ã—ã¦ã€ãã‚Œã‚’Excelã§èªã¿è¾¼ã‚“ã§å¥½ãã«åŠ å·¥ã—ã¦æˆ´ãã®ã§ã™ãŒã€ã‚„ã¯ã‚ŠExcelã®å½¢å¼ã§ã¯ãªã„ã®ã§ä½¿ã„è¾›ã„ã¨è¨€ã‚ã‚Œã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ãã“ã§ã€Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡ºåŠ›ã™ã‚‹ã‚ˆã†ã«ã—ã‚ˆã†ã¨ã„ã†ã“ã¨ã«ãªã‚Šã€PHP Excelã¨ã„ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’CakePHPã«çµ„ã¿è¾¼ã‚“ã§ä½¿ã†ã“ã¨ã«ã—ã¾ã—ãŸã€‚ å‡ºåŠ›ã™ã‚‹Excelã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯Excel95ï¼ˆæ‹¡å¼µå .xlsï¼‰ã¨ã—ã€PHP Excelã¯Vendorãƒ©ã‚¤ã‚¯ã«ä½¿ã„ã¾ã™ã€‚ ãªã‚‹ã¹ãMVCãƒ¢ãƒ‡ãƒ«ã«ãªã‚‹ã‚ˆã†ã«ã€ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ©ã§å¿…è¦ãªãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã—ã¦ã€ãƒ“ãƒ¥ãƒ¼ã§ãƒ•ã‚¡ã‚¤ãƒ«å‡ºåŠ›ã‚’è¡Œã„ã¾ã™ã€‚ ã¾ãšã€PHP Excelãƒ©ã‚¤ãƒ–ãƒ©ãƒªä¸€å¼ã‚’Vendorç”¨ã®ãƒ•ã‚©ãƒ«ãƒ€ã«é…ç½®ã—ã¾ã™ã€‚ \cakephp\app\vendors/php excel\PHP Excel
tuki0918 2013/09/30
cakephp

excel
ãƒªãƒ³ã‚¯
å…¬å‹™å“¡ãŒå…¬é–‹ã™ã‚‹ãƒç”³ExcelãŒæ—¥æœ¬ã®ç”Ÿç”£æ€§ã‚’è½ã¨ã—ã¦ã„ã‚‹è©±
Haruhiko Okumura @h_okumura æ˜¨æ—¥ã®æœ€å¾Œã®ã€Œæ¸›ç½ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ï¼ŒæŸå…ˆç”Ÿã®ã€Œã€Œã‚¨ã‚¯ã‚»ãƒ«ã€ã¯ç¥žçš„ã‚½ãƒ•ãƒˆã€ã¨ã„ã†ã‚¹ãƒ©ã‚¤ãƒ‰2æžšï¼Œè‡ªæ²»ä½“ã§ã®Excelã®é©šç•°çš„ãªä½¿ã„æ–¹ã‚’ç´¹ä»‹ã€‚ãƒ‡ãƒ¼ã‚¿å†åˆ©ç”¨ã‚’è€ƒãˆãªã„æ›¸é¡žä½œæˆãƒ„ãƒ¼ãƒ«ã«ãªã£ã¦ã„ã‚‹ Haruhiko Okumura @h_okumura â†“ç§ãŒéœ‡ç½å¾Œãšã£ã¨æ„Ÿã˜ã¦ã„ãŸã“ã¨ã¨ã‚‚ç¬¦åˆã€‚O'Reillyã®ã€ŽBad Dataã€ã¨ã„ã†æœ¬ã«ã‚‚ï¼ŒExcelã§ã‚ã‚ŠãªãŒã‚‰ã‚¹ã‚¯ãƒ¬ãƒ¼ãƒ”ãƒ³ã‚°ã—ãªã„ã¨ãƒ‡ãƒ¼ã‚¿ã«ãªã‚‰ãªã„ä¾‹ãŒç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹
tuki0918 2013/03/10
Excelã§ã‚‚æ£è¦åŒ–ã¯å½¹ã«ç«‹ã¤

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
tuki0918 2013/02/14
excel
ãƒªãƒ³ã‚¯
Excelã®è¡¨ã‚’ç½«ç·šã”ã¨ãƒ†ã‚ã‚¹ãƒˆã«å¤‰æ›ã™ã‚‹
ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ä¸Šã§è¡¨çµ„ã¿ã‚’è¡¨ã—ãŸã„å ´åˆã€ã€Œâ”Œã€ã‚„ã€Œâ”¬ã€ã¨ã„ã£ãŸå¤–å—ã‚’ç”¨ã„ã¦ç½«ç·šã‚’ä½œã‚‹æ–¹æ³•ãŒã‚ã‚‹ã€‚ä¾‹ãˆã°ãƒ¡ãƒ¼ãƒ«æœ¬æ–‡ã®ä¸ã«è¡¨ã‚’æŒ¿å…¥ã—ãŸã„å ´åˆãªã©ã€æ•°è¡Œç¨‹åº¦ã®ã¡ã‚‡ã£ã¨ã—ãŸè¡¨ã§ã‚ã‚Œã°ã€ã“ã‚Œã§ã˜ã‚…ã†ã¶ã‚“ã«è¡¨çµ„ã¿ã§ã‚ã‚‹ã“ã¨ãŒä¼ãˆã‚‰ã‚Œã‚‹ã€‚ã„ã¡ã„ã¡Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‚ç…§ã—ã¦ã‚‚ã‚‰ã‚ãªãã¦ã‚‚æ¸ˆã‚€ã¨ã„ã†ã‚ã‘ã ã€‚
tuki0918 2012/12/26
ãƒ†ã‚ã‚¹ãƒˆ

excel
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› - NAVER ã¾ã¨ã‚
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› NAVERã¾ã¨ã‚ã¯2020å¹´9æœˆ30æ—¥ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ç´„11å¹´é–“ã€NAVERã¾ã¨ã‚ã‚’ã”åˆ©ç”¨ãƒ»ã”æ„›é¡§ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚
tuki0918 2012/12/22
NAVER

excel
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› - NAVER ã¾ã¨ã‚
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› NAVERã¾ã¨ã‚ã¯2020å¹´9æœˆ30æ—¥ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ç´„11å¹´é–“ã€NAVERã¾ã¨ã‚ã‚’ã”åˆ©ç”¨ãƒ»ã”æ„›é¡§ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚
tuki0918 2012/12/16
ä¾¿åˆ©ãªé–¢æ•°ã®ã¾ã¨ã‚ã‚‚è¦‹ã¦ã¿ãŸã„ãªãƒ¼

excel
ãƒªãƒ³ã‚¯
ä¸‰æµå› ken3ã®memoç½®ãå ´
2024-08-13 Q:1ã¤ã§ã‚‚ãƒãƒ£ãƒ³ãƒãƒ«BANã•ã‚ŒãŸã‚‰ã‚¢ã‚«ã‚¦ãƒ³ãƒˆå…¨ã¦BANã•ã‚Œã‚‹ã®ã§ã™ã‹ï¼Ÿ A:ç§ã®å ´åˆã¯é•åãƒãƒ£ãƒ³ãƒãƒ«ã ã‘ã§ã—ãŸ YouTube é›‘è«‡ Q:è¤‡æ•°ãƒãƒ£ãƒ³ãƒãƒ«ã‚’å–å¾—ä¸ã«1ã¤ã§ã‚‚ãƒãƒ£ãƒ³ãƒãƒ«BANã•ã‚ŒãŸã‚‰ã‚¢ã‚«ã‚¦ãƒ³ãƒˆå…¨ã¦BANã•ã‚Œã‚‹ã®ã§ã™ã‹ï¼ï¼ŸA:ãã®ãƒãƒ£ãƒ³ãƒãƒ«ã ã‘ã ã¨æ€ã„ã¾ã™ (â€»ã‚ã£ã€ã‚‚ã—ã‹ã—ã¦å†å¯©è«‹æ±‚ä¸ã«ä»–ãŒç”Ÿã‹ã•ã‚Œã¦ã„ãŸã ã‘ï¼Ÿã¨è¨˜äº‹ã‚’æ›¸ã„ã¦ã¦è‡ªåˆ†ã§æ°—ãŒä»˜ã„ãŸã‚Šãƒ»ãƒ»)è¤‡æ•°ãƒãƒ£ãƒ³ãƒãƒ«ã®ç®¡ç†ã«ã¤â€¦ #YouTube #BAN #é›‘è«‡ 2024-08-13 Q:YouTubeã®ãƒ¡ã‚¤ãƒ³ãƒãƒ£ãƒ³ãƒãƒ«ã¨ã‚µãƒ–ãƒãƒ£ãƒ³ãƒãƒ«ã®åŒºåˆ¥ã®ä»•æ–¹ã¯ã©ã†ã‚„ã£ã¦ã‚„ã‚‹ã®ã§ã™ã‹ï¼Ÿ A:ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®æŒ‡å®šãŒã‚ã‚‹ã ã‘ã§ã™ YouTube é›‘è«‡ detail.chiebukuro.yahoo.co.jp YouTubeã®ãƒ¡ã‚¤ãƒ³ãƒãƒ£ãƒ³ãƒãƒ«ã¨ã‚µãƒ–ãƒãƒ£ãƒ³ãƒãƒ«ã®åŒºåˆ¥ã®ä»•æ–¹ã¯ã©ã†ã‚„ã£ã¦ã‚„ã‚‹ã®ã§ã™ã‹ï¼Ÿ ç™»éŒ²è€…2000äººã®å¼±å°ãƒãƒ£ãƒ³
tuki0918 2012/12/12
excel
ãƒªãƒ³ã‚¯
downpanda.comÂ -Â downpanda ãƒªã‚½ãƒ¼ã‚¹ãŠã‚ˆã³æƒ…å ±
tuki0918 2012/12/11
excel
ãƒªãƒ³ã‚¯
DCOUNTAé–¢æ•°ã®ä½¿ã„æ–¹ã€€åˆå¿ƒè€…ã®ã‚¨ã‚¯ã‚»ãƒ«(Excel)å¦ç¿’ãƒ»å…¥é–€
A5ã«=DCOUNTA(A7:D17,C7,A2:D3)ã‚’å…¥åŠ›ã™ã‚‹ã¨ä»¥ä¸‹ã®è¡¨ã®çµæžœã¨ãªã‚Šã¾ã™ã€‚ A5ã®=DCOUNTA(A7:D17,C7,A2:D3)ã§ã¯Databaseã«A7:D17ã®ã‚»ãƒ«ç¯„å›²ã‚’æŒ‡å®šã—ã€ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«C7ã€ Criteriaï¼ˆæ¤œç´¢æ¡ä»¶ï¼‰ã«A2:D3ã®ã‚»ãƒ«å‚ç…§ã‚’æŒ‡å®šã—ã¦ã„ã¾ã™ã€‚ è¦‹å‡ºã—ã®ã‚½ãƒ•ãƒˆç¨®é¡žã®è¡Œã®"ã‚¨ã‚¯ã‚»ãƒ«"ãŒå…¥åŠ›ã•ã‚Œã¦ã„ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ¤œç´¢ã—ã€å£²ä¸Šã®åˆ—ã®ç©ºç™½ã‚»ãƒ«ä»¥å¤–ã®ã‚»ãƒ«ã®å€‹æ•°3ã‚’è¿”ã—ã¾ã™ã€‚
tuki0918 2012/12/08
Excel

ã‚¨ã‚¯ã‚»ãƒ«
ãƒªãƒ³ã‚¯
ãƒžã‚¯ãƒã‚’çµ„ã‚“ã§ä»•äº‹ã—ãŸã‚‰å…ˆè¼©ã«ã²ãã‚‡ã†è€…ã¨å‘¼ã°ã‚ŒãŸ
ãƒžã‚¯ãƒã‚’çµ„ã‚“ã§ä»•äº‹ã—ãŸã‚‰å…ˆè¼©ã«ã²ãã‚‡ã†è€…ã¨å‘¼ã°ã‚ŒãŸ 2012å¹´09æœˆ08æ—¥21:20 ã‚«ãƒ†ã‚´ãƒªä»•äº‹ãƒ»ãƒ“ã‚¸ãƒã‚¹ãƒ»é‡‘å„²ã‘ã“ã‚Œã¯é…·ã„ Tweet http://vip.2ch blog.jp/archives/17063942.htmlãƒžã‚¯ãƒã‚’çµ„ã‚“ã§ä»•äº‹ã—ãŸã‚‰å…ˆè¼©ã«ã²ãã‚‡ã†è€…ã¨å‘¼ã°ã‚ŒãŸ http://hayabusa.2ch.net/test/read.cgi/news4vip/1347035535/ 1ï¼šä»¥ä¸‹ã€åç„¡ã—ã«ã‹ã‚ã‚Šã¾ã—ã¦VIPãŒãŠé€ã‚Šã—ã¾ã™ï¼š2012/09/08(åœŸ) 01:32:15.69 ID:zNwUByf60 ç§ã®è·æ¥ã¯ä¸€èˆ¬äº‹å‹™ï¼ˆæ´¾é£ï¼‰ã§ã™ãŒ å°‘ã—VBAãŒã‚ã‹ã‚‹ã®ã§ãƒ«ãƒ¼ãƒãƒ³åŒ–ã§ãã‚‹ã‚‚ã®ã¯ãƒžã‚¯ãƒã‚’çµ„ã‚“ã§ã„ã¾ã™ã€‚ ãã†ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã‚¨ã‚¯ã‚»ãƒ«ã§1æ™‚é–“ã‹ã‹ã‚‹ä½œæ¥ãŒ1åˆ†ã§çµ‚ã‚ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ãªã®ã§è·å ´ã§ã¯ã€Œä»•äº‹ãŒæ—©ã„ã€ä»•äº‹ãŒã§ãã‚‹ã€ã¨è©•ä¾¡ã•ã‚Œã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ãŒ å…ˆæ—¥å…ˆè¼©
tuki0918 2012/10/26
excel
ãƒªãƒ³ã‚¯
ã‚†ã¨ã‚Šç¤¾å“¡ãŒExcelã‚’é›»å“ä½¿ã„ãªãŒã‚‰è¡¨ä½œã£ã¦ã‚‹â€¦
ã‚†ã¨ã‚Šç¤¾å“¡ãŒExcelã‚’é›»å“ä½¿ã„ãªãŒã‚‰è¡¨ä½œã£ã¦ã‚‹â€¦ 2012å¹´09æœˆ07æ—¥12:20 ã‚«ãƒ†ã‚´ãƒªç¤¾ä¼šãƒ»ç”Ÿæ´»ä»•äº‹ãƒ»ãƒ“ã‚¸ãƒã‚¹ãƒ»é‡‘å„²ã‘ Tweet http://vip.2ch blog.jp/archives/16835237.htmlã‚†ã¨ã‚Šç¤¾å“¡ãŒExcelã‚’é›»å“ä½¿ã„ãªãŒã‚‰è¡¨ä½œã£ã¦ã‚‹â€¦ http://hayabusa.2ch.net/test/read.cgi/news4vip/1346830278/ 1ï¼šä»¥ä¸‹ã€åç„¡ã—ã«ã‹ã‚ã‚Šã¾ã—ã¦VIPãŒãŠé€ã‚Šã—ã¾ã™ï¼š2012/09/05(æ°´) 16:31:18.53 ID:4jAiSNUHi ã©ã†ã—ãŸã‚‚ã®ã‹â€¦ ãƒ»æ€’ã‚‹ ä»•äº‹ã—ã¦ã‚‹ã®ã«ãªã‚“ã§æ€’ã‚‰ã‚Œãªãã‚ƒãªã‚‰ãªã„ã®ã‹ï¼ï¼ã¨é€†åˆ‡ã‚Œã‹ã¾ãŸã¯é€†æ¨ã¿ ãƒ»å„ªã—ãå‚è€ƒæ›¸ã‚’æ¸¡ã—ã¦ã‚ã’ã‚‹ è‡ªåˆ†ã‚ãƒ›ãƒ³ã“ã®ã‚¹ã‚¿ã‚¤ãƒ«ãªã‚“ã§^_^ã¨è¨€ã†ã“ã¨ã‚’èžã‹ãªã„ ãƒ»ç„¡è¦–ã™ã‚‹ ç”Ÿç”£æ€§ãŒè½ã¡å°»æ‹ã„ã‚’ã•ã›ã‚‰ã‚Œã‚‹ ãƒ»å¼µã‚Šå€’ã™ ä¿ºãŒã‚¯ãƒ“
tuki0918 2012/10/26
ã‚¨ã‚¯ã‚»ãƒ«

excel
ãƒªãƒ³ã‚¯
Aiper Diffex (Excel/Word/Clipboard/XPSæ¯”è¼ƒãƒ„ãƒ¼ãƒ«)
ã€ŒAiperDiffexã€ã¯ã€ä»¥ä¸‹ã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã®ãƒ‡ãƒ¼ã‚¿ã‚’æ¯”è¼ƒã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ»ã€ŒMicrosoft Excelã€ã§ä½œæˆã•ã‚ŒãŸãƒ•ã‚¡ã‚¤ãƒ« ãƒ»ã€ŒMicrosoft Wordã€ã§ä½œæˆã•ã‚ŒãŸãƒ•ã‚¡ã‚¤ãƒ« ãƒ»ã‚¯ãƒªãƒƒãƒ—ãƒœãƒ¼ãƒ‰ã«ã‚³ãƒ”ãƒ¼ã—ãŸãƒ‡ãƒ¼ã‚¿ï¼ˆè¡¨å½¢å¼ or ãƒ†ã‚ã‚¹ãƒˆå½¢å¼ï¼‰ ãƒ»ãƒ—ãƒªãƒ³ã‚¿ã€ŒMicrosoft XPS Document Writerã€ã«å‡ºåŠ›ã—ãŸãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆXPSãƒ•ã‚¡ã‚¤ãƒ«ï¼‰ ã¾ãŸã€æ¯”è¼ƒã—ãŸçµæžœã‚’è‰²é•ã„ã§ç”»é¢ã«è¡¨ç¤ºã™ã‚‹ç‚ºã€ç›¸é•ç‚¹ãŒä¸€ç›®ã§åˆ†ã‹ã‚Šã¾ã™ã€‚ ï¼œAiperDiffexã®ä¸»ãªæ©Ÿèƒ½ï¼ž ï¼‘ï¼ŽExcelãƒ•ã‚¡ã‚¤ãƒ«ã®æ¯”è¼ƒ ãƒ»Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚·ãƒ¼ãƒˆå˜ä½ã§æ¯”è¼ƒ ãƒ»æ¯”è¼ƒã™ã‚‹æ–¹å‘ã‚’æŒ‡å®šã—ã¦æ¯”è¼ƒ ãƒ»ã‚¿ã‚¤ãƒˆãƒ«ãŒä¸€è‡´ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’æ¯”è¼ƒ ãƒ»ã‚ãƒ¼ã¨ãªã‚‹é …ç›®ãŒä¸€è‡´ã™ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ¯”è¼ƒ ãƒ»æ¯”è¼ƒçµæžœã‚’è‰²é•ã„ã§ç”»é¢ã«è¡¨ç¤º ãƒ»æ¯”è¼ƒçµæžœã®å·®åˆ†ã‚’å®Ÿéš›ã®Excelãƒ•ã‚¡ã‚¤ãƒ«ã«åæ˜ ãƒ»æ¯”è¼ƒçµæžœã®ç”»é¢ã‹ã‚‰ã€é¸æŠžã—ãŸã‚»ãƒ«ï¼ˆExcelãƒ•ã‚¡ã‚¤ãƒ«ï¼‰
tuki0918 2012/10/26
ã‚ã‚‚ã£ã¨ã“ã†

excel

diff
ãƒªãƒ³ã‚¯
JavaScriptã§XLSXå½¢å¼ã‚’æ‰±ã†Â·XLSX.js MOONGIFT
XLSX.jsã¯JavaScriptã§Excelãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆBase64ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ï¼‰ã‚’èªã¿è¾¼ã‚“ã ã‚Šã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã•ã›ã‚‰ã‚Œã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’ã¯ã˜ã‚ã€Webãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§è¡¨è¨ˆç®—è¡¨ç¤ºã‚’è¡Œã£ãŸã‚Šã€ç·¨é›†ã—ãŸã‚Šã™ã‚‹Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚ã‚Šã¾ã™ã€‚ã—ã‹ã—æœ€ã‚‚æœ‰åŠ›ãªã®ã¯Excelã§ã—ã‚‡ã†ã€‚ãã“ã§è©¦ã—ãŸã„ã®ãŒExcelãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿æ›¸ãã§ãã‚‹JavaScriptãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€XLSX.jsã§ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã•ã‚ŒãŸãƒ•ã‚¡ã‚¤ãƒ«ã§ã™ã€‚ã¡ã‚ƒã‚“ã¨XLSXã¨ã—ã¦èªè˜ã•ã‚Œã¾ã™ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿è¾¼ã‚€å‡¦ç†ã®ãƒ‡ãƒ¢ã§ã™ã€‚Base64ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãŒè§£æžã•ã‚Œã¦ã„ã¾ã™ã€‚ XLSX.jsã¯base64ã®XLSXãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿è¾¼ã¿ã€JavaScriptã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã«å¤‰æ›ã§ãã¾ã™ã€‚å¾Œã¯ã„ã‹ã‚ˆã†ã«ã‚‚è¡¨ç¤ºã§ãã‚‹ã§ã—ã‚‡ã†ã€‚ã¾ãŸã€ã‚·ãƒ¼ãƒˆåã¨å„ã‚»ãƒ«ã®å€¤ã‚’HTMLãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰èªã¿è¾¼ã‚“ã§XLSXãƒ•ã‚¡ã‚¤ãƒ«ã«å¤‰æ›ã—ã¦ãƒ€
tuki0918 2012/10/18
excel

JavaScript

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã€ã™ã”ã„ã‚¨ã‚¯ã‚»ãƒ«ã€‘ãªãœã‹ã‚„ãŸã‚‰é‡ã„ã‚¨ã‚¯ã‚»ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã‚’è»½ãã™ã‚‹æ–¹æ³•ï½œã€Œã™ã”ã„æ”¹å–„ã€ï½ž2000æ™‚é–“&6000ä¸‡å††ã‚’å‰Šæ¸›ã—ãŸExcelã®ä½¿ã„æ–¹â€¦é‡ã„ã‚¨ã‚¯ã‚»ãƒ«ã‚’è»½ãã—ã¾ã™
ã€Œã™ã”ã„æ”¹å–„ã€ï½ž2000æ™‚é–“&6000ä¸‡å††ã‚’å‰Šæ¸›ã—ãŸExcelã®ä½¿ã„æ–¹â€¦é‡ã„ã‚¨ã‚¯ã‚»ãƒ«ã‚’è»½ãã—ã¾ã™ã‚¨ã‚¯ã‚»ãƒ«é«˜é€ŸåŒ–ï¼†è‡ªå‹•åŒ–ã®æ„Ÿå‹•ã¨å¿«æ¥½ã‚’ã•ã—ã‚ã’ã¾ã™ã€‚ â– ãƒ¡ãƒ«ãƒžã‚¬é…ä¿¡ä¸ â˜…ã‚¨ã‚¯ã‚»ãƒ«ã®å·¥å¤«ã§ä»•äº‹ã¯åŠ‡çš„ã«å¤‰ã‚ã‚Šã¾ã™ â– ã‚¨ã‚¯ã‚»ãƒ«è¡¨è¨ˆç®—ã§ã€€ã€Œã™ã”ã„æ”¹å–„ã€è¬›åº§ã€€ã€€ã€€ã€€ã€€ç”³ã—è¾¼ã¿å—ä»˜ä¸ã§ã™ï¼ â– ãŠå•ã„åˆã‚ã›å…ˆ yoshida.kenï¼ sugoikaizen.com ï¼ˆï¼ ã‚’åŠè§’ã«å¤‰æ›´ã—ã¦ä¸‹ã•ã„ï¼‰ ã€ã™ã”ã„ã‚¨ã‚¯ã‚»ãƒ«ã€‘ãªãœã‹ã‚„ãŸã‚‰é‡ã„ã‚¨ã‚¯ã‚»ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã‚’è»½ãã™ã‚‹æ–¹æ³•â€•(1)ã™ã”ã„ã‚¨ã‚¯ã‚»ãƒ«æŠ€ ãã‚“ãªã«ãŸãã•ã‚“ãƒ‡ãƒ¼ã‚¿ãŒ å…¥åŠ›ã•ã‚Œã¦ã„ã‚‹ã‚ã‘ã§ã‚‚ãªã„ã®ã«ã€ ã‚„ãŸã‚‰ãƒ•ã‚¡ã‚¤ãƒ«ã®å®¹é‡ãŒ é‡ããªã£ã¦ã—ã¾ã†ã¨ã„ã†ã“ã¨ãŒãŸã¾ã«ã‚ã‚Šã¾ã™ã€‚ å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã«è¤‡é›‘ãªé–¢æ•°ãŒçµ¡ã‚“ã§ã„ã‚‹ã‚ã‘ã§ã‚‚ãªãã€ ã‚·ãƒ³ãƒ—ãƒ«ãªè¡¨ã‚’ä½œã£ãŸã ã‘ãªã®ã«ä½•åãƒ¡ã‚¬ã«ã‚‚ãªã£ã¦ã—ã¾ã†â€¦ã€‚ ãªã‚“ã§ã ã‚ã†â€¦ã¨æ‚©ã‚“ã§ã—ã¾ã†ã‚ã‘ã§ã™ã€‚ ã“ã‚“ãªå ´åˆã€ã‚ˆãåŽŸå› ã¯ã‚ã‹ã‚Šã¾ã›ã‚“ãŒ
tuki0918 2012/10/17
ã™ã”ã„

Excel
ãƒªãƒ³ã‚¯
TechCrunch | Startup and Technology News
Live Nation says its Ticketmaster subsidiary was hacked. A hacker claims to be selling 560 million customer records. An autonomous pod. A solid-state battery-powered sports car. An electric pickup truck. A convertible grand tourer EV with up to 600 miles of range. A â€œfully connected mobility deviceâ€ for young urban innovators to be built by Foxconn and priced under $30,000. The next Popemobile. Ov
tuki0918 2012/08/12
excel

Python
ãƒªãƒ³ã‚¯
ã‚‹ã³ã¾
ã€Žã‚‹ã³ã¾ã€ã¯ã€Ruby ã«é–¢ã™ã‚‹æŠ€è¡“è¨˜äº‹ã¯ã‚‚ã¡ã‚ã‚“ã®ã“ã¨ã€Rubyist ã¸ã®ã‚¤ãƒ³ã‚¿ãƒ“ãƒ¥ãƒ¼ã‚„ã‚¨ãƒƒã‚»ã‚¤ã€ãã®ä»–ã‚’ãŠå±Šã‘ã™ã‚‹ã‚¦ã‚§ãƒ–é›‘èªŒã§ã™ã€‚ Rubyist Magazine ã«ã¤ã„ã¦ ã€ŽRubyist Magazineã€ã€ç•¥ã—ã¦ã€Žã‚‹ã³ã¾ã€ã¯ã€æ—¥æœ¬ Ruby ã®ä¼šã®æœ‰å¿—ã«ã‚ˆã‚‹ Rubyist ã® Rubyist ã«ã‚ˆã‚‹ã€Rubyist ã¨ãã†ã§ãªã„äººã®ãŸã‚ã®ã‚¦ã‚§ãƒ–é›‘èªŒã§ã™ã€‚ æœ€æ–°å· Rubyist Magazine 0058 å· ãƒãƒƒã‚¯ãƒŠãƒ³ãƒãƒ¼ Rubyist Magazine 0058 å· RubyKaigi 2018 ç›´å‰ç‰¹é›†å· Rubyist Magazine 0057 å· RubyKaigi 2017 ç›´å‰ç‰¹é›†å· Rubyist Magazine 0056 å· Rubyist Magazine 0055 å· Rubyist Magazine 0054 å· æ±äº¬ Ruby ä¼šè° 11 ç›´
tuki0918 2012/08/08
excel
ãƒªãƒ³ã‚¯
rubyã®Excelæ“ç¸¦ç”¨ãƒ©ã‚¤ãƒ–ãƒ©ãƒª exlap.rb
çŸã„ã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨˜è¿°ã§Excelæ“ä½œã‚’è‡ªå‹•åŒ–ã€€ï½žã€€VBAã®æ‰‹æ³•ã‚’åˆ©ç”¨ã—ã¤ã¤rubyã®åŠ¹çŽ‡æ€§ã‚’ã„ã‹ã—ã¦ã€ç°¡æ½”ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆã§Excelã‚’æ“ç¸¦ã—ã¾ã™ã€‚ã‚ãšã‚‰ã‚ã—ã„ã‚ãƒ¼ãƒ»ãƒžã‚¦ã‚¹æ“ä½œã‹ã‚‰é€ƒã‚Œã‚‹æ‰‹æ®µã«ãªã‚Šã¾ã™ã€‚ ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®æœ€çµ‚æ›´æ–°æ—¥ï¼šã€€2016/05/12 æœ€æ–°ZIP ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ï¼šã€€exlap120.zip: ver 1.20 book_open, close ã®ä¸¡ãƒ¡ã‚½ãƒƒãƒ‰ã®å¼•æ•°ã®ä»•æ§˜ã‚’å¤‰æ›´ã€‚VBAã® Workbooks.Open, Workbook.Close ã¨åŒã˜ã‚ˆã†ã«å¼•æ•°ã‚’æŒ‡å®šå¯èƒ½ã«ã€‚ select_sheetãƒ¡ã‚½ãƒƒãƒ‰ã‚’å¼•æ•°ãªã—ã§å‘¼ã³å‡ºã—ãŸã¨ãã¯ã€VBAã®ActiveSheetã‚’è¿”ã™ã‚ˆã†ã«æ”¹è¨‚ã€‚ exlap120.zipã«ã¯ exlap.rb, exlap_utf.rb ãŠã‚ˆã³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ç”¨ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã¨ç°¡å˜ãªè§£èª¬ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒå«ã¾ã‚Œã¦ã„ã¾ã™ã€‚ä¿®æ£ç‚¹ã¯å½“ã‚µã‚¤ãƒˆã®å¾Œã‚ã®æ–¹ã«æŽ²è¼‰ã—ã¦ã„ã¾ã™ã€‚ exl
tuki0918 2012/08/08
ã‚‚ã—ã‹ã—ãŸã‚‰å½¹ã«ç«‹ã¤ã‹ã‚‚

excel

ruby
ãƒªãƒ³ã‚¯
Juice Labs - Chart Chooser
Please wait, redirecting.
tuki0918 2012/08/06
powerpoint

excel
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› - NAVER ã¾ã¨ã‚
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› NAVERã¾ã¨ã‚ã¯2020å¹´9æœˆ30æ—¥ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ç´„11å¹´é–“ã€NAVERã¾ã¨ã‚ã‚’ã”åˆ©ç”¨ãƒ»ã”æ„›é¡§ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚
tuki0918 2012/07/19
excel
ãƒªãƒ³ã‚¯
1 2 3 æ¬¡ã®ãƒšãƒ¼ã‚¸