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

Excelã§æ¬¡ã€…ã¨QRã‚³ãƒ¼ãƒ‰ã‚’ä½œæˆã™ã‚‹æ–¹æ³•

ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã§è‡ªç¤¾ã®Webã‚µã‚¤ãƒˆã‚’é–‹ã„ã¦ã‚‚ã‚‰ã†ãŸã‚ã«ã€ã‚«ã‚¿ãƒã‚°ã‚„ãƒã‚¹ã‚¿ãƒ¼ã«URLã‚’åŸ‹ã‚è¾¼ã‚“ã QRã‚³ãƒ¼ãƒ‰ã‚’è¼‰ã›ã‚‹ã“ã¨ã‚‚å¤šã„ã ã‚ã†ã€‚QRã‚³ãƒ¼ãƒ‰ãŒä½œæˆã§ãã‚‹ç„¡æ–™ã®Webã‚µãƒ¼ãƒ“ã‚¹ãªã©ã‚‚ã‚ã‚Šã€ã“ã†ã—ãŸã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½¿ã£ã¦è‡ªç¤¾ã®URLã‚’åŸ‹ã‚è¾¼ã‚“ã QRã‚³ãƒ¼ãƒ‰ã‚’ä½œæˆã—ã¦ã„ã‚‹äººã‚‚å¤šã„ã®ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ ãŸã ã€ã‚ãƒ£ãƒ³ãƒšãƒ¼ãƒ³ãªã©ã€ç‰¹å®šæ—¥ã¾ã§å¤–éƒ¨ã«çŸ¥ã‚‰ã‚ŒãŸããªã„æƒ…å ±ã®å ´åˆã€Webã‚µãƒ¼ãƒ“ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã«ä¸å®‰ã‚’æ„Ÿã˜ã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã ã‚ã†ã€‚ã¾ãŸã€åº—èˆ—ã”ã¨ã«å€‹åˆ¥ã®QRã‚³ãƒ¼ãƒ‰ã‚’ä½œæˆã—ãŸã„ã‚ˆã†ãªå ´åˆã€å°‘ã€…æ‰‹é–“ãŒã‹ã‹ã‚‹ã€‚ ãã®ã‚ˆã†ãªå ´åˆã€ã€ŒMicrosoft Excelï¼ˆã‚¨ã‚¯ã‚»ãƒ«ï¼‰ã€ã®QRã‚³ãƒ¼ãƒ‰ä½œæˆæ©Ÿèƒ½ã‚’åˆ©ç”¨ã™ã‚‹ã¨ã€å¤–éƒ¨ã«ãƒ‡ãƒ¼ã‚¿ãŒæµå‡ºã™ã‚‹ã“ã¨ãªãã€ä¸€è¦§è¡¨ã‹ã‚‰æ¯”è¼ƒçš„ç°¡å˜ã«QRã‚³ãƒ¼ãƒ‰ã‚’æ¬¡ã€…ã¨ä½œæˆã§ãã‚‹ã€‚ãã®æ–¹æ³•ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ ã€äº‹å‰æº–å‚™ã€‘ãƒªãƒœãƒ³ã«ï¼»é–‹ç™ºï¼½ã‚¿ãƒ–ã‚’è¿½åŠ ã™ã‚‹ QRã‚³ãƒ¼ãƒ‰ã®ä½œæˆã¯ã€ï¼»é–‹ç™ºï¼½ã‚¿ãƒ–ã«ã‚ã‚‹ActiveXã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«

larker 2023/02/06

ãƒªãƒ³ã‚¯

ç„¡å„Ÿã§ä½¿ãˆã‚‹å¸³ç¥¨ãƒ„ãƒ¼ãƒ«ã§PDFã‚„Excelå½¢å¼ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç”Ÿæˆã™ã‚‹(1)ï¼šIT Pro

å¸³ç¥¨ä½œæˆã¨èžãã¨ï¼Œã¨ã‹ãã€Œé«˜ä¾¡ãªãƒ„ãƒ¼ãƒ«ãŒå¿…è¦ãªã®ã§ã¯ï¼Ÿã€ã€Œã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãŒé›£ã—ãã†ã€ã¨æ€ã„ãŒã¡ã§ã™ã€‚ãªã‚‹ã»ã©ï¼Œä¸€æ˜”å‰ãªã‚‰ãã†ã ã£ãŸã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ã—ã‹ã—ï¼Œä»Šã§ã¯é«˜åº¦ãªæ©Ÿèƒ½ã‚’å‚™ãˆãŸã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®å¸³ç¥¨ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ãŒæ•°å¤šãã‚ã‚Šã¾ã™ã€‚é€£è¼‰æœ€çµ‚å›žã®ä»Šå›žã¯ï¼Œç„¡å„Ÿã§åˆ©ç”¨ã§ãã‚‹ã“ã†ã—ãŸã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ã‚’ä½¿ã£ã¦ï¼Œå¸³ç¥¨ã‚’å‡ºåŠ›ã™ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œæˆã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆä½œæˆã«Officeã‚’åˆ©ç”¨ã§ãã‚‹äºŒã¤ã®ã‚½ãƒ•ãƒˆ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§æä¾›ã•ã‚Œã¦ã„ã‚‹ä»£è¡¨çš„ãªå¸³ç¥¨ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«ã¯ï¼Œï¼ˆè¡¨1[æ‹¡å¤§è¡¨ç¤º]ï¼‰ã®ã‚ˆã†ãªã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ä»Šå›žã¯ï¼Œãã®ä¸ã‹ã‚‰äºŒã¤ã®ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ä¸€ã¤ã¯ï¼ŒPDFï¼ˆPorta ble Document Formatï¼‰ï¼ŒRTFï¼ˆRich Text Formatï¼‰ï¼ŒHTMLãªã©æ§˜ã€…ãªå½¢å¼ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆå‡ºåŠ›ã«å¯¾å¿œã—ãŸã€ŒJooReportsã€ã§ã™ã€‚ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‹ã‚‰å‹•çš„ã«å¸³ç¥¨ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ç”Ÿæˆã™ã‚‹ã€ŒJ

larker 2015/05/11

ãƒªãƒ³ã‚¯

[Java] å¸³ç¥¨ã‚’PDFã§å‡ºåŠ›ã™ã‚‹æ™‚ã«Excelã‚’ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã¨ã—ã¦ä½¿ã†æ–¹æ³• CMS CRM é¡§å®¢ç®¡ç† Webãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚°å®Ÿè·µ writeWired CMS Platform

ã‚»ãƒ«ã‚’ä¸€å€‹ä¸€å€‹ãƒã‚§ãƒƒã‚¯ã—ã¦ç½®æ›æ–‡å—åˆ—ãŒã‚ã£ãŸã‚‰ç½®æ›ã™ã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ // ãƒ¯ãƒ¼ã‚¯ãƒ–ãƒƒã‚¯ã‚’é–‹ã Workbook workbook = new HSSFWorkbook(excel); // æœ€åˆã®ã‚·ãƒ¼ãƒˆã‚’é–‹ã Sheet sheet = workbook.getSheetAt(0); // ã‚»ãƒ«å†…ã«åŸ‹ã‚è¾¼ã¾ã‚Œã¦ã„ã‚‹ç½®æ›æ–‡å—ã‚’ç½®æ› for (Iterator<Row> sheetIte = sheet.iterator(); sheetIte.hasNext(); ) { // è¡Œã‚’å–å¾— Row row = sheetIte.next(); for (Iterator<Cell> cellIte = row.iterator(); cellIte.hasNext();) { // ã‚»ãƒ«ã‚’å–å¾— Cell cell = cellIte.next(); // æ–‡å—åˆ—ã‚¿ã‚¤ãƒ—ã®ã‚»ãƒ«ã®ã¿ã‚’å¯¾è±¡ if

larker 2015/05/11

ãƒªãƒ³ã‚¯

Excel ã§ç¸¦è»¸ãŒå·¦å³ã«ã‚ã‚‹ 2 è»¸ã‚°ãƒ©ãƒ•ã‚’ä½œæˆã™ã‚‹ã«ã¯?

ã™ã¹ã¦ã® Microsoft è£½å“ Microsoft 365 Office Windows Surface Xbox ã‚»ãƒ¼ãƒ« ã‚µãƒãƒ¼ãƒˆ ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ Windows ã‚¢ãƒ—ãƒª OneDrive Outlook Skype OneNote Microsoft Teams PC ã¨ãƒ‡ãƒã‚¤ã‚¹ Xbox ã‚’è³¼å…¥ã™ã‚‹ ã‚¢ã‚¯ã‚»ã‚µãƒª VR & è¤‡åˆç¾å®Ÿ ã‚¨ãƒ³ã‚¿ãƒ¡ Xbox Game Pass Ultimate Xbox Live Gold Xbox ã¨ã‚²ãƒ¼ãƒ PC ã‚²ãƒ¼ãƒ Windows ã‚²ãƒ¼ãƒ æ˜ ç”»ã¨ãƒ†ãƒ¬ãƒ“ç•ªçµ„ æ³•äººå‘ã‘ Microsoft Azure Microsoft Dynamics 365 Microsoft 365 Microsoft Industry ãƒ‡ãƒ¼ã‚¿ ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ Power Platform æ³•äººå‘ã‘ã‚’è³¼å…¥ã™ã‚‹ Developer & IT .NET Visual Studi

larker 2014/12/03

Excel
Tips

ãƒªãƒ³ã‚¯

ã‚¨ã‚¯ã‚»ãƒ«ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ä½¿ã†ã«ã¯ã€ã“ã†ã™ã‚Œã°ã„ã„ã¨æ€ã†ã®ã ã‘ã©ã€ãªãœèª°ã‚‚ã‚„ã‚‰ãªã„ã®ã‹ãªï¼Ÿ - Excel æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ

ã‚¨ã‚¯ã‚»ãƒ«ã¯ç½«ç·šãƒ¯ãƒ¼ãƒ—ãƒã˜ã‚ƒãªã„ ãªã‚“ã§ã‚¨ã‚¯ã‚»ãƒ«ã‚’ã“ã‚“ãªä½¿ã„æ–¹ã™ã‚‹ã®ã ã‚ã†ï¼Ÿ æ¯Žå›žã€æ¯Žå›žã€ä¼šè°ã®ãŸã³ã«åŒã˜ã‚ˆã†ãªè³‡æ–™ä½œã£ã¦ã€ã‚‚ã†ç–²ã‚Œã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦ç®¡ç†ã™ã‚‹ãªã‚‰ï¼‘ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ¨ªä¸€åˆ—ã«å…¥åŠ›ã—ã¦ã€ç¸¦å‘ãã«é€£ç¶šã—ã¦ãƒ‡ãƒ¼ã‚¿ã‚’ç¹°ã‚Šè¿”ã—ã¦ç®¡ç†ã—ãªã„ã¨ã„ã‘ã¾ã›ã‚“ã€‚ ã‚¨ã‚¯ã‚»ãƒ«ã¯ç½«ç·šãƒ¯ãƒ¼ãƒ—ãƒã˜ã‚ƒãªã„ ã“ã“ã§ã‚„ã£ã¦ã¯ã„ã‘ãªã„ã“ã¨ ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ•ã‚©ãƒ¼ãƒ ç·¨é›†æ©Ÿèƒ½ã¯ã€ä½¿ãˆãªã„ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å½¢å¼ã§ã€ç®¡ç†ã™ã‚‹ å°åˆ·ã‚·ãƒ¼ãƒˆã«ã€ãƒ‡ãƒ¼ã‚¿ã‚’ãƒªãƒ³ã‚¯ã—ã¦ã¯ãƒ€ãƒ¡ï¼ å°åˆ·ã‚·ãƒ¼ãƒˆã¯ã€ï¼»å°åˆ·ä½œæ¥é ˜åŸŸï¼½ã«ãƒªãƒ³ã‚¯ã—ã¾ã™ã€‚ ã‚¨ã‚¯ã‚»ãƒ«ã‚«ãƒ¼ãƒ‰ HARI ã®ä½¿ã„æ–¹ï¼ˆå‹•ç”»ï¼‰ Excel ã¨ Access ã‚’é€£æºã—ã¦ä½¿ã†ï¼ˆå‹•ç”»ï¼‰ Acces ã¨ Excel ã‚’é€£æºã—ã¦ã€æœ¬æ ¼çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚’è¡Œã†ã«ã¯ï¼Ÿ Excel â†’ AccessÂ â†’ Azure ã¨ç§»è¡Œã—ã¦ã„ã ã‚»ãƒ¼ãƒ«ã‚¹App KATAï¼ˆå–¶æ¥æ”¯æ´ãƒŽãƒ¼ã‚³ãƒ¼ãƒ‰ã‚¢ãƒ—ãƒªï¼‰ ã“ã“ã§ã‚„ã£ã¦ã¯ã„ã‘ãªã„ã“ã¨ ï¼‘ï¼Ž

larker 2014/09/05

ã¾ã‚ã€Excelè·äººã ã‹ã‚‰ä»•æ–¹ãŒãªã„

Excel
DB

ãƒªãƒ³ã‚¯

ã‚¨ã‚¯ã‚»ãƒ«ã§ã‚«ãƒ¼ã‚½ãƒ«ã‚ãƒ¼ãŒãŠã‹ã—ããªã‚‹ - ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã•ã‹ã°

ã“ã“ã®ã¨ã“ã‚ã‚¨ã‚¯ã‚»ãƒ«(Microsoft Excel)ãŒãŠã‹ã—ããªã£ã¦ã„ã¾ã—ãŸã€‚ã‚«ãƒ¼ã‚½ãƒ«(çŸ¢å°)ã‚ãƒ¼ã‚’å‹•ã‹ã—ã¦ã‚‚ã‚»ãƒ«ãŒç§»å‹•ã›ãšã€ã‚¹ã‚¯ãƒãƒ¼ãƒ«ã—ã¦ã—ã¾ã†ã®ã§ã™ã€‚ã‚»ãƒ«ç§»å‹•ã™ã‚‹ã ã‘ãªã®ã«ã€ãƒžã‚¦ã‚¹ã‚’ä½¿ã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ã‚¨ã‚¯ã‚»ãƒ«ã®è¨å®šã‚’è¦‹ã¦ã‚‚é–¢ä¿‚ã—ãã†ãªã‚‚ã®ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ å®Ÿã¯ã“ã‚Œã¯ã€ãƒ—ãƒªãƒ³ãƒˆã‚¹ã‚¯ãƒªãƒ¼ãƒ³(PrtSC)ã®æ¨ªè¾ºã‚Šã«ã‚ã‚‹ScrLk(ã‚¹ã‚¯ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯)ãŒåŠ¹ã„ã¦ã„ãŸã®ã§ã™ã€‚ã€Œã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã®ç‰¹æ®Šã‚ãƒ¼ã€ãªã‚‹ãƒšãƒ¼ã‚¸ã‚’è¦‹ã¤ã‘ã¦ã‚ˆã†ã‚„ãã‚ã‹ã‚Šã¾ã—ãŸã€‚ã“ã®ãƒšãƒ¼ã‚¸ã‹ã‚‰ã‚¹ã‚¯ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã®ç®‡æ‰€ã‚’å¼•ç”¨ã•ã›ã¦ã„ãŸã ãã¨ å…ƒã€…ã¯3270ç«¯æœ«ã§ã‚«ãƒ¼ã‚½ãƒ«ã‚’ç§»å‹•ã•ã›ãªã„ã‚ˆã†ã«ã™ã‚‹ã‚ãƒ¼ã€‚ Excelã§ã¯ã€ScrollLockãŒã‚ªãƒ³ã«ãªã£ãŸçŠ¶æ…‹ã§ã‚«ãƒ¼ã‚½ãƒ«ã‚ãƒ¼ã‚’æŠ¼ã™ã¨ã€é¸æŠžã—ãŸã‚»ãƒ«ã¯ãã®ã¾ã¾ã§ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆå…¨ä½“ãŒç§»å‹•ã™ã‚‹ã€‚ ã‚‚ã¨ã‚‚ã¨ã¯è‰²ã€…ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚¹ã‚¯ãƒãƒ¼ãƒ«ã™ã‚‹ã¯ãšã§ã™ãŒã€ç§ã®ä½¿ã†ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®ã†ã¡ã€ã¾ã˜ã‚ã«å¯¾å¿œã—ãŸã‚‚ã®

larker 2013/09/26

Excel
tips

ãƒªãƒ³ã‚¯

Excelã§ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆ(ãƒ—ãƒ«ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆ)ã‚’ä½œæˆã™ã‚‹(å…¥åŠ›è¦å‰‡)ï¼šExcelåŸºæœ¬è¬›åº§

ã€Œé€£å‹•ã™ã‚‹ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ©ç”¨ã—ã¦ä½œæˆã™ã‚‹ã€ã‚’ä¿®æ£ã—ãŸãƒšãƒ¼ã‚¸ã§ã™ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã§ã¯ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆã®ä½œæˆæ–¹æ³•ã‚’åŸºç¤Žã‹ã‚‰æ›¸ã„ã¦ã„ã¾ã™ãŒã€ãƒ¡ã‚¤ãƒ³ã¯é€£å‹•ã™ã‚‹ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆã‚’ä½œæˆã™ã‚‹éƒ¨åˆ†ã§ã™ã€‚ ã¡ã‚‡ã£ã¨ã‚„ã‚„ã“ã—ãã†ã§ã™ãŒã€ä¾¿åˆ©ãªä½¿ã„æ–¹ãŒã§ãã‚‹æ€ã£ã¦ã„ã¾ã™ã€‚ åŒä¸€ã‚·ãƒ¼ãƒˆã®ãƒªã‚¹ãƒˆã‚’ä½¿ã†ã€€ã€€ã€€ã€€ã€€ã€€ã€€Topã¸ ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆã‹ã‚‰é¸æŠžã™ã‚‹ãŸã‚ã€å…¥åŠ›ã®é–“é•ã„ãŒå°‘ãªããªã‚Šã¾ã™ã€‚ å…¥åŠ›ã™ã‚‹å—å¥ã‚’è¦šãˆã¦ãŠãå¿…è¦ãŒç„¡ããªã‚Šã¾ã™ã€‚ ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆ(ãƒ—ãƒ«ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆ)ã«è¡¨ç¤ºã™ã‚‹å€¤ã‚’ãƒ€ã‚¤ã‚¢ãƒã‚°ãƒœãƒƒã‚¯ã‚¹ã§è¨å®šã™ã‚‹æ–¹æ³• ã“ã®æ–¹æ³•ã‚’ä½¿ãˆã°ã€å…¥åŠ›ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã®ãƒªã‚¹ãƒˆã‚’ã‚·ãƒ¼ãƒˆã«ä½œæˆã—ã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ å…¥åŠ›è¦å‰‡ã®è¨å®šæ™‚ã«å€¤ã‚’ã‚»ãƒƒãƒˆã™ã‚‹æ–¹æ³•ã§ã™ã€‚ è¨å®šã™ã‚‹ã‚»ãƒ«ã‚’é¸æŠžã—ã¾ã™ã€‚ã“ã“ã§ã¯B3ã‚»ãƒ«ã‚’é¸æŠžã—ã¦ã„ã¾ã™ã€‚ [ãƒ‡ãƒ¼ã‚¿]ã‚¿ãƒ–ã®ãƒ‡ãƒ¼ã‚¿ãƒ„ãƒ¼ãƒ«ã‚°ãƒ«ãƒ¼ãƒ—ã®[ãƒ‡ãƒ¼ã‚¿ã®å…¥åŠ›è¦å‰‡]ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿

larker 2011/09/08

Excel
tips

ãƒªãƒ³ã‚¯

Excelã‚’åˆ¥ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã§ã™ã°ã‚„ãé–‹ã

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

larker 2011/06/21

ãƒªãƒ³ã‚¯

ï¼¥ï½˜ï½ƒï½…ï½Œã§çµ±è¨ˆå‡¦ç†ã‚’ã™ã‚‹å ´åˆ - ã‚¦ã‚£ãƒªã‚¢ãƒ ã®ã„ãŸãšã‚‰ã®ã€ã¾ã¡ã‚ã‚‹ãã€ãŸã¹ã‚ã‚‹ã

åˆ†æžãƒ„ãƒ¼ãƒ«ã¨ã„ã†ã‚¢ãƒ‰ã‚¤ãƒ³ã‚’ä½¿ã†ã€‚ ã¾ãšã€ãƒ„ãƒ¼ãƒ«ã®ã‚¢ãƒ‰ã‚¤ãƒ³ã‚’é¸æŠž å‡ºã¦ããŸãƒ€ã‚¤ã‚¢ãƒã‚°ã§ã€ã€Œåˆ†æžãƒ„ãƒ¼ãƒ«ã€ã‚’ãƒã‚§ãƒƒã‚¯ã—ã¦ï¼¯ï¼« åˆ†æžãƒ„ãƒ¼ãƒ«ã‚’èµ·å‹•ã™ã‚‹ã¨ã€ çµ±è¨ˆå‡¦ç†ãŒã„ã‚ã„ã‚å‡ºã¦ãã‚‹ã€‚ ãªã‹ã‚“ã˜ã€‚

larker 2011/06/03

ãƒªãƒ³ã‚¯

Excelãƒ•ã‚¡ã‚¤ãƒ«ã®æœªä½¿ç”¨ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã‚’ä¸€ç™ºå‰Šé™¤ã™ã‚‹

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

larker 2011/04/18

æœªä½¿ç”¨ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã‚’ä¸€ç™ºå‰Šé™¤ã™ã‚‹

Excel
tools

ãƒªãƒ³ã‚¯

ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹5ã¤ã®ç°¡å˜ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ | ã‚³ãƒªã‚¹

Chandoo.orgã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‹ã‚‰ã€æ¡ä»¶ä»˜ãæ›¸å¼ã‚’åˆ©ç”¨ã—ã¦ã€ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹5ã¤ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ Learn Cool Microsoft Excel Conditional Formatting Tricks ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’ãƒã‚¤ãƒ©ã‚¤ãƒˆ æ¡ä»¶ä»˜ãæ›¸å¼ã‚’ä½¿ç”¨ã—ãŸã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆ ã‚»ãƒ«å†…ã«é…ç½®ã™ã‚‹ã‚°ãƒ©ãƒ• ãƒŸã‚¹ã‚„ã‚¨ãƒ©ãƒ¼ãƒ»ãƒ‡ãƒ¼ã‚¿æ¬ è½ãªã©ã®ãƒã‚¤ãƒ©ã‚¤ãƒˆè¡¨ç¤º ç›´æ„Ÿçš„ã«æŠŠæ¡ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ†ãƒ¼ãƒ–ãƒ« [ad#ad-2] ã‚¨ã‚¯ã‚»ãƒ«ãƒ‡ãƒ¼ã‚¿ã¯ã€Chandoo.orgã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®ä¸€ç•ªä¸‹ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’ãƒã‚¤ãƒ©ã‚¤ãƒˆ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹ãŸã‚ã«ã€æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’äº¤äº’ã«ãƒã‚¤ãƒ©ã‚¤ãƒˆè¡¨ç¤ºã«ã—ã¾ã™ã€‚ ãƒã‚¤ãƒ©ã‚¤ãƒˆã«ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«å…¨ä½“ã‚’é¸æŠžã—ã¾ã™ã€‚ ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚ˆã‚Šã€[æ›¸å¼] - [æ¡ä»¶ä»˜ãæ›¸å¼] ã‚’é¸æŠžã€‚ ã€Œæ•°å¼ã€ã‚’é¸æŠžã—ã€ã€Œ=MOD(ROW(),2)=0ã€ã‚’å…¥åŠ›ã—

larker 2011/03/25

äº¤äº’ã«ãƒã‚¤ãƒ©ã‚¤ãƒˆã€ã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆã€ã‚°ãƒ©ãƒ•ãªã©

Excel
Tips

ãƒªãƒ³ã‚¯

ä»•äº‹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ã‚¢ãƒƒãƒ—ã™ã‚‹ã€9ã¤ã®ã‚¨ã‚¯ã‚»ãƒ«ä¾¿åˆ©ãƒ¯ã‚¶ | TuiTui

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

larker 2010/08/01

Excel
tips

ãƒªãƒ³ã‚¯

Excelã®xlsxãƒ•ã‚¡ã‚¤ãƒ«ã®ä¸èº«ï¼ãˆã£ã€å½¢æ…‹ç´ è§£æžã—ãŸçŠ¶æ…‹ã§ã€æ–‡å—åˆ—å…¥ã£ã¦ãªã„ï¼Ÿï¼Ÿ - ã‚¦ã‚£ãƒªã‚¢ãƒ ã®ã„ãŸãšã‚‰ã®ã€ã¾ã¡ã‚ã‚‹ãã€ãŸã¹ã‚ã‚‹ã

ã‚¦ã‚£ãƒªã‚¢ãƒ ã®ã„ãŸãšã‚‰ãŒã€è¡—æ©ãã€é£Ÿã¹ç‰©ã€éŸ³æ¥½ç‰ã®å€‹äººçš„è¦‹è§£ã‚’ä¸»ã«æ›¸ããƒ–ãƒã‚°ã§ã™ï¼ˆãŸã¾ï½žã«ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãƒ¼é–¢ä¿‚ã‚‚ï¼‰ Excelã®xlsxãƒ•ã‚¡ã‚¤ãƒ«ã®ä¸èº«ã¯ã€xmlè¡¨ç¾ã•ã‚ŒãŸexcelãƒ‡ãƒ¼ã‚¿ãŒzipã§å›ºã‚ã‚‰ã‚Œã¦ã„ã‚‹ã“ã¨ã¯çŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ ã§ã€ã„ã¾ã€xlsxãƒ•ã‚¡ã‚¤ãƒ«ãŒè¦‹ã‚‰ã‚Œã‚‹ç’°å¢ƒã˜ã‚ƒãªã„ã®ã«ï¼ˆã¤ã¾ã‚Šã€ï¼¥ï½˜ï½ƒï½…ï½Œï¼’ï¼ï¼ï¼“ã—ã‹æŒã£ã¦ãªã„ã®ã«ï¼‰ã€xlsxãƒ•ã‚¡ã‚¤ãƒ«ã‚’è¦‹ãªãã‚ƒã„ã‘ãªã„çŠ¶æ³ã«ãªã£ã¦ã€ã‚³ãƒ³ãƒãƒ¼ã‚¿ãƒ¼ã¨ã‹ä½¿ãˆã°é–‹ã‘ã‚‹ã‚“ã ã‚ã†ã‘ã©ã€ãã‚Œã‚‚é¢å€’ãªã®ã§ã€ï¼ºï¼©ï¼°ã‚’å›žç”ã—ã¦ã¿ã¦ã³ã£ãã‚‰ã“ï¼ˆï¼ ï¼¿ï¼ ï¼ï¼‰ã¨ã„ã†ã®ã§ã€ãƒ¡ãƒ¢ãƒ¡ãƒ¢ã€‚ ã¾ãšã€xmlè¡¨ç¾ã•ã‚ŒãŸexcelãƒ‡ãƒ¼ã‚¿ã‚’ç²å¾—ã™ã‚‹ã¾ã§ ï¼ˆï¼‘ï¼‰ã€Œãªã‚“ã¨ã‹ã‹ã‚“ã¨ã‹.xlsxã€ã®æ‹¡å¼µåã‚’ã€Œãªã‚“ã¨ã‹ã‹ã‚“ã¨ã‹.zipã€ã«å¤‰ãˆã‚‹ ï¼ˆï¼’ï¼‰ï¼ˆWindowsï¼¸ï¼°ä»¥é™ã®ï¼¯ï¼³ã‚’ä½¿ã£ã¦ã„ãŸã‚‰ï¼‰ï¼ˆï¼‘ï¼‰ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’å³ã‚¯ãƒªãƒƒã‚¯ã—ã¦ã€ ã€Œã™ã¹ã¦ã‚’å±•é–‹ã€ã‚’é¸æŠžã€ï¼ºï¼©ï¼°ã‚’è§£å‡ã™ã‚‹ ï¼ˆï¼“ï¼‰ã§ããŸãƒ•ã‚©ãƒ«ãƒ€ï¼ˆã€Œãªã‚“

larker 2010/02/22

xlsxãƒ•ã‚¡ã‚¤ãƒ«ã®ä¸èº«ã«ã¤ã„ã¦

Excel

ãƒªãƒ³ã‚¯

NonSoft - ã‚¨ã‚¯ã‚»ãƒ«ã‚’ä½¿ç”¨ã—ãŸå¸³ç¥¨å°åˆ·ã®ã‚µãƒ³ãƒ—ãƒ«(VB.NET)

æ–‡å—ã‚³ãƒ¼ãƒ‰åˆ¤å®š/å¤‰æ›ãƒ„ãƒ¼ãƒ«(VB6ã®ã‚½ãƒ¼ã‚¹ä»˜) SJISã€JISã€EUCã€UNICODE(UTF-16)ã€UTF-7ã€UTF-8ã®æ–‡å—ã‚³ãƒ¼ãƒ‰åˆ¤å®š/å¤‰æ›(VB6ã®ã‚½ãƒ¼ã‚¹ä»˜) ãƒ•ã‚©ãƒ«ãƒ€å†…ã®ãƒ•ã‚¡ã‚¤ãƒ«æ¯”è¼ƒãƒ„ãƒ¼ãƒ« ãƒ•ã‚©ãƒ«ãƒ€æ¯”è¼ƒï¼ˆï¼’ã¤ã®ãƒ•ã‚©ãƒ«ãƒ€ã®æ¯”è¼ƒã€åŒä¸€ãƒ•ã‚©ãƒ«ãƒ€ã®æ™‚é–“å·®ã§ã®æ¯”è¼ƒã€ãƒ†ã‚ã‚¹ãƒˆå·®åˆ†è¡¨ç¤ºï¼‰ ãƒ†ã‚ã‚¹ãƒˆå·®åˆ†è¡¨ç¤ºãƒ„ãƒ¼ãƒ« ãƒ•ã‚¡ã‚¤ãƒ«æ¯”è¼ƒï¼ˆï¼’ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã®å·®åˆ†ã‚’è¡¨ç¤ºï¼‰ã€æ–‡å—ã‚³ãƒ¼ãƒ‰è‡ªå‹•åˆ¤å®šã€å·®åˆ†è§£æžã‚µãƒ³ãƒ—ãƒ«ã‚½ãƒ¼ã‚¹(VB6) ã‚¢ã‚¤ãƒ‰ãƒ«â˜†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã‚¿ã‚¹ã‚¯ãƒˆãƒ¬ã‚¤ã«å¸¸é§ã—ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼ãƒ•ã‚©ãƒ«ãƒ€åŒæœŸã€‚å‡¦ç†ã«ä½¿ç”¨ã™ã‚‹ï¼£ï¼°ï¼µçŽ‡æŒ‡å®šã§ä½Žè² è·å®Ÿè¡Œ ãã®ä»–ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ ãŸãã•ã‚“ã®ä¾¿åˆ©ãƒ„ãƒ¼ãƒ«ã‚’å…¬é–‹ã—ã¦ã„ã¾ã™ã®ã§ãŠè©¦ã—ãã ã•ã„ ï¼œã“ã®ã‚µãƒ³ãƒ—ãƒ«ã®æ¦‚è¦ï¼ž VB.NETã‹ã‚‰ã‚¨ã‚¯ã‚»ãƒ«ã‚’ä½¿ç”¨ã—ã¦å¸³ç¥¨ã‚’å°åˆ·ã™ã‚‹ã‚µãƒ³ãƒ—ãƒ«ã‚’ä½œã£ã¦ã¿ã¾ã—ãŸã€‚å¸³ç¥¨å°åˆ·æ©Ÿèƒ½ ã‚’ç°¡å˜ã«å®Ÿç¾ã—ãŸã„æ™‚ã«å¦‚ä½•ã§ã—ã‚‡ã†ã‹ã€‚ã“ã®ã‚µãƒ³ãƒ—ãƒ«ã®ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã¯ä»¥

larker 2009/10/20

ãƒªãƒ³ã‚¯

2007/03/14 ã€Œæ—¥ç±³ã§ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã‚’å¤‰ãˆã‚‹ã“ã¨ã‚‚è°è«–ã¨ã—ã¦ã¯ã‚ã£ãŸã€‚ã ãŒã€çµæžœã¨ã—ã¦ã¯æ—¥ç±³ã§ã»ã¼åŒã˜ã«ãªã£ãŸã€ã€‚ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆ ãƒ‡ã‚£ãƒ™ãƒãƒƒãƒ—ãƒ¡ãƒ³ãƒˆã®ãƒ—ãƒãƒ€ã‚¯ãƒˆãƒ—ãƒ©ãƒ³ãƒ‹ãƒ³ã‚°ï¼†ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¨ã‚¯ã‚¹ãƒšãƒªã‚¨ãƒ³ã‚¹ ã‚°ãƒ«ãƒ¼ãƒ— ãƒ¦ãƒ¼ã‚¶ãƒ¼ ã‚¨ã‚¯ã‚¹ãƒšãƒªã‚¨ãƒ³ã‚¹ ãƒªã‚µãƒ¼ãƒãƒ£ãƒ¼ã®ç”°ä¸å¥å²æ°ã¯3æœˆ14æ—¥ã®ä¼šè¦‹ã§ã€ã€Œ2007 Microsoft Office Systemã€ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã‚’å®Œæˆã•ã›ã‚‹ã¾ã§ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ“ãƒªãƒ†ã‚£ãƒ†ã‚¹ãƒˆã®çµŒç·¯ã‚’å…¬é–‹ã—ãŸã€‚æ—¥ç±³ã§ã¯Officeã®ä½¿ã„æ–¹ã«å·®ãŒã‚ã‚Šã€æ—¥æœ¬ç‰ˆOfficeã®UIã‚’ç‹¬è‡ªã«ã™ã‚‹ã“ã¨ã‚‚è°è«–ã¨ã—ã¦ã¯ã‚ã£ãŸã¨ã„ã†ã€‚ Office 2007ã¯Officeã®ã“ã‚Œã¾ã§ã®UIã‚’å¤§ããå¤‰æ›´ã—ã€è¤‡æ•°ã®æ©Ÿèƒ½ã‚’ã‚¿ãƒ–ã§ã¾ã¨ã‚ãŸã€Œãƒªãƒœãƒ³ã€ã‚’æŽ¡ç”¨ã—ãŸã€‚èƒŒæ™¯ã«ã¯å‰ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®Office 2003ã¾ã§ã«æ©Ÿèƒ½ã‚„ã‚³ãƒžãƒ³ãƒ‰ãŒå¢—ãˆç¶šã‘ã€ã€Œã‚¨ãƒ³ãƒ‰ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒæ©Ÿèƒ½ã‚’è¦‹ã¤ã‘ã‚‰ã‚Œãªã„ã€ï¼ˆç”°ä¸æ°ï¼‰ã¨

larker 2007/03/15

UI
Excel

ãƒªãƒ³ã‚¯

http://www.kumashoko.or.jp//ariake/jyouho/urawaza/urawaza.htm

larker 2006/10/03

ãƒªãƒ³ã‚¯

Tremend Tech Blog Spreadsheet dojo widget Click here for a demo of the spreadsheet widget. It is based on release 0.3.1 of dojo toolkit.Javascriptã‚’ä½¿ã£ãŸãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§å‹•ä½œã™ã‚‹Excelã‚·ãƒ¼ãƒˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€‚ Dojoã‚’ãƒ™ãƒ¼ã‚¹ã«ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆåŒ–ã•ã‚Œã¦ã„ã¦ã€ã‚µã‚¤ãƒˆä¸Šã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰å¯èƒ½ã§ã™ã€‚ æ›¸ä½“ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆå¤‰æ›´ã‚„ãƒ•ã‚©ãƒ³ãƒˆã‚µã‚¤ã‚ºã€é–¢æ•°ã¾ã§ä½¿ãˆã¾ã™ã€‚ ã“ã‚Œã¯ã™ã”ã„ã§ã™ãã€‚ â†’ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰

larker 2006/09/28

ãƒªãƒ³ã‚¯

Excelã‚’è¡¨çµ„ã¿ãƒ¯ãƒ¼ãƒ—ãƒã¨ã—ã¦ä½¿ã£ã¦ã„ã‚‹ãªã‚‰â”€â”€JotSpot

Webãƒ™ãƒ¼ã‚¹ã®ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã¨ã„ã†ã¨ã€é–¢æ•°ã®å¤šå¯¡ã‚„ã‚°ãƒ©ãƒ•æ©Ÿèƒ½ãªã©â€œè¨ˆç®—â€ã«ç„¦ç‚¹ãŒå½“ãŸã‚Šæ°—å‘³ã€‚ã—ã‹ã—Excelãƒ¦ãƒ¼ã‚¶ãƒ¼ã®å¤šããŒæ±‚ã‚ã¦ã„ã‚‹ã®ã¯ã€è¡¨çµ„ã¿ãƒ¯ãƒ¼ãƒ—ãƒã‚’å…±æœ‰ã§ãã‚‹ã“ã¨ã ã‚ã†ã€‚â€œè¡¨è¨ˆç®—ã®Wikiâ€ã§ã‚ã‚‹JotSpotã‚’è©¦ã—ã¦ã¿ãŸã€‚ PCã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œã£ã¦ãƒ¡ãƒ¼ãƒ«ã«æ·»ä»˜ã—ã¦å›žè¦§ã—ãŸã‚Šã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚µãƒ¼ãƒã«ç½®ã„ã¦ã¿ã‚“ãªã§å…±æœ‰ã—ãŸã‚Šã™ã‚‹ã¨ã€ã€Œã‚ã‚Œï¼Ÿ ã“ã®ãƒ•ã‚¡ã‚¤ãƒ«ã€èª°ã¾ã§å›žè¦§çµ‚ã‚ã£ã¦ã„ã‚‹ã®ï¼Ÿã€ã¨ã‹ã€Œã ã‚Œã‹ãŒãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–‹ãã£ã±ãªã—ã§ãƒãƒƒã‚¯ã•ã‚Œã¦ã„ã¦è¦‹ã‚‰ã‚Œãªã„ï¼ã€ã¨ã„ã£ãŸã“ã¨ã«ãªã‚Šã‹ããªã„ã€‚ã‚‚ã¡ã‚ã‚“æœ€æ–°ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‚µãƒ¼ãƒã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆOffice2007ã€Grooveã€Sharepointãªã©ï¼‰ã‚’ä½¿ãˆã°ã€è¤‡æ•°äººã§1ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã„ã˜ã‚‹ä»•äº‹ã‚‚ã‚„ã‚Šã‚„ã™ããªã‚‹ã‚ã‘ã ãŒã€ãã‚‚ãã‚‚è«–ã‹ã‚‰ã„ãˆã°ã€ã“ã†ã„ã†ä»•äº‹ã“ãã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã®Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å‘ã„ã¦ã„ã‚‹ã ã‚ã†ã€‚ ã•ã¦ã€Excelã¨

larker 2006/08/09

ãƒªãƒ³ã‚¯

2006/3/29 æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã¯Oracle Databaseã®ãƒ‡ãƒ¼ã‚¿ã‚’Microsoft Excelã®ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã«å–ã‚Šè¾¼ã‚“ã§ã€ãƒ‡ãƒ¼ã‚¿ã®æ¤œç´¢ã‚„æ›´æ–°ãŒã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ„ãƒ¼ãƒ«ã®æ–°ç‰ˆã€ŒKeySQL Release 6.0ã€ã‚’3æœˆ28æ—¥ã«å‡ºè·ã—ãŸã€‚æ–°ç‰ˆã§ã¯ã‚¨ãƒ³ãƒ‰ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ç®¡ç†æ©Ÿèƒ½ã‚’è¿½åŠ ã€‚æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã®ã‚·ã‚¹ãƒ†ãƒ äº‹æ¥æŽ¨é€²æœ¬éƒ¨ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚°ãƒ«ãƒ¼ãƒ— ä¸€å¿—é”ä¹Ÿæ°ã¯ã€Œã„ã‚ã„ã‚ã¨å‡ºã¦ãã‚‹ã‚¨ãƒ³ãƒ‰ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ã‚ãŒã¾ã¾ã«é–‹ç™ºè€…ãŒå¿œãˆãªãã¦ã‚‚ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã®ãƒ‡ãƒ¼ã‚¿ã‚’åˆ©ç”¨ã•ã›ã‚‹ã“ã¨ãŒã§ãã‚‹ã€ã¨ã—ã¦ã„ã‚‹ã€‚ KeySQLã¯Oracle Databaseã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ„ãƒ¼ãƒ«ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒã‚°ã‚¤ãƒ³ã—ã€å¿…è¦ãªæ¤œç´¢æ¡ä»¶ã‚’è¨å®šã™ã‚Œã°ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å–ã‚Šå‡ºã—ã€è‡ªå‹•ã§Excelã®ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã«å¼µã‚Šä»˜ã‘ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ã‚¨ãƒ³ãƒ‰ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ä½¿ã„æ…£ã‚ŒãŸExcelã§å®šåž‹ã®ãƒ¬ãƒãƒ¼ãƒˆã‚„è¦‹ç©æ›¸ãªã©ã‚’ä½œæˆå¯èƒ½ã€‚KeySQLã«ã¯ãƒ‡

larker 2006/03/29

ãƒªãƒ³ã‚¯

Open Alexandria-ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’ç´¹ä»‹

Get your song commercially competitive and ready for the world to hear! Send me your song and Iâ€™ll provide you with a free test master!

larker 2005/08/25

ãƒªãƒ³ã‚¯

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (24)

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

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (24)

Excelã«é–¢ã™ã‚‹larkerã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (20)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (24)

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

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹