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

nantan id:nantan

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

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

ç°¡å˜ã«ä½œã‚Œã‚‹äº‹æ¥è¨ˆç”»&äºˆå®Ÿç®¡ç†ã®ã‚¨ã‚¯ã‚»ãƒ«ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆ(P/Lã®ã¿) - Follow Your Heart
æ—¥æœ¬ä¸ãŒæ“å–œã—ãŸç¨€å‹¢ã®é‡Œåˆå„ªå‹ã€æ¨ªç¶±æ˜‡é€²ã€ç¨€å‹¢ã®é‡Œãƒ•ã‚¡ãƒ³ã«ã¨ã£ã¦ã“ã®1é€±é–“ã¯å¿˜ã‚Œã‚‰ã‚Œãªã„æ™‚é–“ã¨ãªã£ãŸã®ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ç¨€å‹¢ã®é‡Œã‚’è‹¥ã„é ƒã‹ã‚‰å¿œæ´ã—ã¦ã„ãŸè‡ªåˆ†ã¨ã—ã¦ã¯æ„Ÿå‹•ã®ã‚ã¾ã‚Šã€å‹¢ã„ã§äº‹æ¥è¨ˆç”»/äºˆå®Ÿç®¡ç†ã®ã‚¨ã‚¯ã‚»ãƒ«ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆï¼ˆP/Lã®ã¿ï¼‰ã‚’ä½œã£ã¦ã—ã¾ã£ãŸã€‚ ã•ã¦ã•ã¦ã€ã‚¹ã‚¿ãƒ¼ãƒˆã‚¢ãƒƒãƒ—é–¢ä¿‚ã®äººã¨è©±ã‚’ã—ã¦ã„ã¦ã€äº‹æ¥è¨ˆç”»ã«ã¤ã„ã¦è©±é¡Œã«æŒ™ãŒã‚‹ã“ã¨ãŒãŸã¾ã«ã‚ã‚‹ã€‚ï¼“æœˆæ±ºç®—ã®å ´åˆã€ä¸åº¦ã“ã®æ™‚æœŸã¯æ¥æœŸã®äºˆç®—ç·¨æˆãŒå§‹ã¾ã£ã¦ã„ã‚‹ä¼æ¥ãŒå¤šã„ã€‚ äº‹æ¥è¨ˆç”»ã®ä½œã‚Šæ–¹ã¯æ§˜ã€…ã§ã“ã‚ŒãŒæ£è§£ã¨ã„ã†ã‚‚ã®ã¯ãªã„ãŒã€ã‚ã‚‹ç¨‹åº¦ãƒ•ãƒ¬ãƒ¼ãƒ ã¿ãŸã„ãªã‚‚ã®ã¯ã‚ã‚‹ã€‚è‡ªåˆ†è‡ªèº«ã‚‚çµŒå–¶ä¼ç”»ã«æºã‚ã£ã¦ã„ã‚‹ã“ã¨ã‚‚ã‚ã‚Šã€è‰²ã€…ãªäº‹æ¥è¨ˆç”»ã‚’è¦‹ã¦ãã¦ã€åƒè¶ŠãªãŒã‚‰ï¼ˆçªè²«å·¥äº‹ã§ä½œã£ãŸãŸã‚å¤§ã—ãŸãƒ¢ãƒŽã§ã¯ãªã„ãŒï¼‰ç°¡æ˜“çš„ãªãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚’å…¬é–‹ã—ã¦ã¿ã‚ˆã†ã¨æ€ã†ã€‚ *æŠ•è³‡éŠ€è¡Œ/æˆ¦ã‚³ãƒ³å‡ºèº«è€…ã€ãã‚Œã«è¿‘ã—ã„ãƒ¬ãƒ™ãƒ«ã®äººé”ã‹ã‚‰ã—ã¦ã¿ãŸã‚‰ã€ãŸã ã®ã‚¨ã‚¯ã‚»ãƒ«ãƒžãƒŠãƒ¼ãªã®ã§ã€è¦‹ã‚‹ä¾¡å€¤ãŒç„¡ã„ã“ã¨ã¯æœ€
nantan 2017/01/30
Excel

ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆ

äº‹æ¥è¨ˆç”»
ãƒªãƒ³ã‚¯
é¸æŠžã—ãŸExcelã®ã‚»ãƒ«ã‚’Markdownå½¢å¼ã§ã‚³ãƒ”ãƒ¼ã™ã‚‹Excelã‚¢ãƒ‰ã‚¤ãƒ³ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ - nuits.jp blog
é¸æŠžã—ãŸExcelã®ã‚»ãƒ«ã‚’Markdownå½¢å¼ã§ã‚³ãƒ”ãƒ¼ã™ã‚‹Excelã‚¢ãƒ‰ã‚¤ãƒ³ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ æ—¥ä»˜ã®æ›¸å¼ã€é‡‘é¡ã€ã‚«ãƒ³ãƒžãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆãªã©ã‚‚ç”Ÿã‹ã—ãŸã¾ã¾ã‚³ãƒ”ãƒ¼ã§ãã¾ã™ï¼ å³å¯„ã›ãƒ»å·¦å¯„ã¯å…ˆé è¡Œã®è¨å®šã«å¾“ã„ã¾ã™ã€‚ è‰¯ã‹ã£ãŸã‚‰ä½¿ã£ã¦ã‚ã’ã¦ãã ã•ã„ã€‚ å‹•ä½œç¢ºèªæ¸ˆã¿ã®Officeï¼†Windows Windows 7 64bit & Office 2010 Windows 10 64bit & Office 2016 å¿…è¦ç’°å¢ƒ .NET Framework 4.5.2ä»¥ä¸Š Visual Studio 2010 Tools for Office Runtimeã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒæ±‚ã‚ã‚‰ã‚Œã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ (VSã®å…¥ã£ã¦ã„ãªã„Windows 7ã§ã¯æ±‚ã‚ã‚‰ã‚Œã¾ã—ãŸ) ä¸Šè¨˜ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ãªã„å ´åˆã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ãƒ¼ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã•ã‚Œã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã‚‹ã€‚ã€‚ã€‚ã¨æ€ã„ã¾ã™ã€‚ æ“ä½œæ–¹æ³• è²¼ã‚Šä»˜ã‘ãŸã„ç¯„å›²
nantan 2016/10/20
excel

MarkDown
ãƒªãƒ³ã‚¯
ã€ç‰¹åˆ¥ä¼ç”»ã€‘ã‚‚ã†ã€ŒExcelã€ã¯ã„ã‚‰ãªã„ï¼Ÿã€€æœ€å¼·CSVã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ã¨åŒ–ã—ãŸã€ŒEmEditorã€ã‚’ä½¿ã„ã“ãªã™
nantan 2016/07/19
EmEditor

excel

ã‚¨ãƒ‡ã‚£ã‚¿
ãƒªãƒ³ã‚¯
Excelã§ä½ã€…æœ¨å¸Œã‚’æã with python - Qiita
#ã€ç’°å¢ƒã€‘ windows8.1 Excel 2013 python2.7 opencv3 #ã€æ¦‚è¦ã€‘ ä½ã€…æœ¨å¸Œã®å†™çœŸã‹ã‚‰è‰²ã®æƒ…å ±ã‚’å–å¾—ã—ã¦ã€Excelã®ã‚»ãƒ«ã«å¡—ã‚Šã¤ã¶ã—ã¾ã™ã€‚ #ã€ãƒ•ã‚©ãƒ«ãƒ€æ§‹æˆã€‘ |---sasaki_excel |---sasaki_excel.py |---sasaki_nozomi.jpgï¼ˆä½ã€…æœ¨å¸Œã®ç”»åƒï¼‰ |---sasaki_nozomi.xlsxï¼ˆæç”»ç”¨ã®ã‚¨ã‚¯ã‚»ãƒ«ï¼‰ ã“ã¡ã‚‰ã®ç”»åƒã‚’ä½¿ç”¨ã—ã¾ã—ãŸã€‚ #ã€ãƒ—ãƒã‚°ãƒ©ãƒ ã€‘ # -*- coding:utf-8 -*- import cv2 from openpyxl import load_workbook from openpyxl.styles import PatternFill # ç”»åƒèªã¿è¾¼ã¿ image = cv2.imread("sasaki_nozomi.jpg") # ã‚¨ã‚¯ã‚»ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«èªã¿è¾¼ã¿ wb
nantan 2016/05/30
Python

python2.7

Excel

Windows8.1

OpenCV
ãƒªãƒ³ã‚¯
git diff ã§ Office ãƒ•ã‚¡ã‚¤ãƒ«ã®å·®åˆ†ã‚’è¦‹ã‚‹ - Qiita
å…¥ã‚ŒãŸããªã„ã¨ã¯æ€ã£ã¦ã„ã¦ã‚‚ã€æ¢ã‚€ã«æ¢ã¾ã‚Œã¬äº‹æƒ…ã§ Word, Excel, PowerPoint ãªã©ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ git ãƒ¬ãƒã‚¸ãƒˆãƒªã®ä¸ã§ç®¡ç†ã™ã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿã“ã®è¨˜äº‹ã§ã¯ã€Mac ã§ Office ãƒ•ã‚¡ã‚¤ãƒ«ã® diff ã‚’å–ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚Linux ã§ã‚‚å¤šåˆ†å‹•ãã¯ãšã€‚ textconv æ™®é€šã€ãƒã‚¤ãƒŠãƒªãƒ•ã‚¡ã‚¤ãƒ«ã‚’ git diff ã—ã¦ã‚‚ã€å¤‰æ›´å†…å®¹ãŒã‚ã‹ã‚Šã¾ã›ã‚“ã€‚ã¨ã“ã‚ãŒã€git ã«ã¯ textconv ã¨ã„ã†ã€ãƒã‚¤ãƒŠãƒªãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆåˆ¥ã«ãƒã‚¤ãƒŠãƒªã˜ã‚ƒãªãã¦ã‚‚ã„ã„ã‚“ã§ã™ãŒï¼‰ã‚’ã‚³ãƒžãƒ³ãƒ‰ã«æ¸¡ã—ãŸçµæžœã‚’ diff ã«ä½¿ã†æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã¯ã€JPEG ã® Exif æƒ…å ±ã® diff ã‚’å–ã‚‹ä¾‹ç‰ãŒè¼‰ã£ã¦ã„ã¾ã™ã€‚ Office ãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ã®ãƒ†ã‚ã‚¹ãƒˆæŠ½å‡º ã§ã¯ã€Office ãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ãƒ†ã‚ã‚¹ãƒˆã‚’æŠ½å‡ºã™ã‚‹ã«ã¯ã©ã†ã™ã‚Œã°ã„ã„ã§ã—ã‚‡ã†ï¼ŸWindows ã® msysgit ã«ã¯ as
nantan 2016/04/18
Git

Mac

PowerPoint

Excel

Word
ãƒªãƒ³ã‚¯
Gitã§ç®¡ç†ã—ã¦ã„ã‚‹Excelãƒ•ã‚¡ã‚¤ãƒ«ã®å·®åˆ†ã‚’è¦‹ã‚‹ - Qiita
å‹•æ©Ÿ Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’Gitã§ç®¡ç†ã—ã¦ã„ã‚‹ã¨ãã«ã€å·®åˆ†ã‚’è¦‹ã‚‰ã‚Œã‚‹ã¨å¬‰ã—ã„ã€‚Git for Windows (msysgit)ã¯ã€Wordãƒ•ã‚¡ã‚¤ãƒ«ã‚„PDFãƒ•ã‚¡ã‚¤ãƒ«ã¯å·®åˆ†ã‚’è¦‹ã‚‰ã‚Œã‚‹ã‚ˆã†ã«è¨å®šæ¸ˆã§é…å¸ƒã•ã‚Œã¦ã„ã‚‹ãŒã€Excelãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã„ã¦ã¯æœªå¯¾å¿œã€‚ ã§ããŸã“ã¨ git diffã§Excelãƒ•ã‚¡ã‚¤ãƒ«ã«åŠ ãˆãŸå¤‰æ›´ã‚’ç¢ºèªã—ã¦ã‹ã‚‰git commitã§ãã‚‹ ã‚‚ã¡ã‚ã‚“éŽåŽ»ã®å±¥æ´ã®å·®åˆ†ã‚‚è¦‹ã‚‰ã‚Œã‚‹ è¡Œé ã«ã‚·ãƒ¼ãƒˆåãŒå«ã¾ã‚Œã¦ã„ã¦è¤‡æ•°ã‚·ãƒ¼ãƒˆã«ã‚‚å¯¾å¿œã—ã¦ã„ã‚‹ CUIã§ã®Excelãƒ•ã‚¡ã‚¤ãƒ«ã®å·®åˆ†è¡¨ç¤ºä¾‹ GUI (Git Extensions)ã§ã®Excelãƒ•ã‚¡ã‚¤ãƒ«ã®å·®åˆ†è¡¨ç¤ºä¾‹ è¶…ä¾¿åˆ©ï¼ï¼ï¼ ä½¿ã£ãŸã‚‚ã® Git for Windows (msysgit) version 1.8.4.msysgit.0 Go 1.4.2 git-xlsx-textconv ab71fc84ecd7ae97b19305ba05159
nantan 2016/04/11
Git

msysGit

Excel
ãƒªãƒ³ã‚¯
http://lorefnon.me/plain-text-table/
Plain Text Table Interactively create and edit tables and export them to plain text Huh ? At a lot of places, like Stackoverflow questions/answers, source code comments, plain text em ails etc. HTML tables are not an option. We can always format ascii characters to simulate tables but unless you are a ninja with keyboard, doing so is a headache. This web based tool provides a dead simple way for
nantan 2015/06/16
table

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

excel
ãƒªãƒ³ã‚¯
Excelæ–¹çœ¼ç´™ã‚’æ”¯ãˆã‚‹æŠ€è¡“ - ãŸã‘ãžã†ç€•æ»ãƒ–ãƒã‚°
æœ€è¿‘ä»•äº‹ã§Excelæ–¹çœ¼ç´™ã‚’èªã‚“ã ã‚Šæ›¸ã„ãŸã‚Šã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã°ã‹ã‚Šæ›¸ã„ã¦ã„ã‚‹ã®ã§ã™ãŒã€ãã‚“ãªExcelæ–¹çœ¼ç´™ã‚’æ”¯ãˆã‚‹æœ€æ–°ã®Java æŠ€è¡“ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ãªã«ã¯ãªãã¨ã‚‚POI Javaã§Excelã¨è¨€ãˆã°å¤–ã›ãªã„ã®ãŒPOIã§ã™ã€‚ä»¥å‰ã¯JExcel APIã¨ã„ã†å¯¾æŠ—é¦¬ã‚‚ã‚ã£ãŸã®ã§ã™ãŒã€Excel 2007ã«å¯¾å¿œã—ã¦ã„ãªã„ã®ã§ç¾åœ¨ã§ã¯POIãŒå”¯ä¸€ã®é¸æŠžè‚¢ã¨ã„ã£ã¦ã„ã„ã§ã—ã‚‡ã†ã€‚ POIã¯éžå¸¸ã«ãƒ—ãƒªãƒŸãƒ†ã‚£ãƒ–ãªAPIã‚’æä¾›ã™ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã€ä½¿ã„ã“ãªã™ã«ã¯ãã‚Œãªã‚Šã®ä¿®ç·´ãŒå¿…è¦ã§ã™ã€‚ãã®ãŸã‚ã€å¯èƒ½ã§ã‚ã‚Œã°å®Ÿéš›ã®èªã¿æ›¸ãã«ã¯å¾Œè¿°ã™ã‚‹XLSBeansã‚„jXLSãªã©ã‚’ä½¿ã£ãŸæ–¹ãŒã‚ˆã„ã§ã—ã‚‡ã†ã€‚ãŸã ã—ã€jXLSã®ã‚ˆã†ãªãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ³ã§ã¯ç´°ã‹ã„ã‚»ãƒ«ã®ã‚¹ã‚¿ã‚¤ãƒ«è¨å®šãªã©ã¯ã§ããªã„ãŸã‚ã€POIã‚’ä½µç”¨ã—ãªã„ã¨ãªã‚‰ãªã„ã‚±ãƒ¼ã‚¹ã‚‚å¤šã„ã§ã™ã€‚Excelæ–¹çœ¼ç´™ã‚’æ”¯ãˆã‚‹æŠ€è¡“ã®ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦æŠ¼ã•ãˆã¦ãŠãã¹ããƒ©ã‚¤ãƒ–ãƒ©ãƒªã¨ã„ãˆã‚‹ã§ã—
nantan 2014/01/07
excel

Java
ãƒªãƒ³ã‚¯
https://www.getnext.net/wp/?p=185
nantan 2012/08/15
office

word

powerpoint

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
nantan 2012/08/13
excel

Python
ãƒªãƒ³ã‚¯
ã‚·ãƒ•ãƒˆè¡¨ã€€ï¼ˆã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆã‚¿ã‚¤ãƒ—ã€€é€±é–“ï¼‰ã€€:ã€€ç„¡æ–™ã‚¨ã‚¯ã‚»ãƒ« ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆ
nantan 2012/03/26
ã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆ

Excel
ãƒªãƒ³ã‚¯
EXCELã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ä½œæˆ
CopyrightÂ© Torigoe 2005 Object Oriented XBASE Forum FoxProã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰Excelã‚’æ“ä½œã™ã‚‹ ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§Excelã‚’æ“ä½œã™ã‚‹ã¨ã€ã‚¤ãƒ³ãƒ†ãƒªã‚»ãƒ³ã‚¹ã®ã‚µãƒãƒ¼ãƒˆã‚’å—ã‘ã‚‰ã‚Œã‚‹ã®ã§ã€å„ã‚³ãƒžãƒ³ãƒ‰ã®å‹•ä½œã‚’ç¢ºèªã—ãªãŒã‚‰é€²ã‚ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚å„ã‚³ãƒžãƒ³ãƒ‰ã®å‹•ä½œç¢ºèªãŒã§ãã‚Œã°å¾Œã¯ç°¡å˜ã€ã‚¢ãƒ—ãƒªã‚’çµ„ã‚€ã ã‘ã§ã™ã€‚ å–ã‚Šåˆãˆãšã€ã“ã‚“ãªæ„Ÿã˜ã®Excelã‚·ãƒ¼ãƒˆã‚’FoxProã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰ä½œæˆã—ã¦ã¿ã‚ˆã†ã€‚ã€Œç¶²ãŒã‘ã€ã•ã‚Œã¦ã„ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã‚’FoxProã®ã‚³ãƒžãƒ³ãƒ‰ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã«å…¥åŠ›ã—ã¦å‹•ä½œã‚’ç¢ºèªã—ã¦ãã ã•ã„ã€‚ ï¼‘ï¼Žæº–å‚™ ã‚¿ã‚¹ã‚¯ãƒžãƒãƒ¼ã‚¸ãƒ£ãƒ¼ã‚’èµ·å‹•ã—ã€â€EXCEL.EXEâ€ãŒèµ·å‹•ã•ã‚Œã¦ã„ãªã„ã“ã¨ã‚’ç¢ºèªã—ã¦ãŠãã¾ã™ã€‚ ï¼’ï¼ŽEXCELã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ä½œæˆ ã‚³ãƒžãƒ³ãƒ‰ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã«ä¸‹è¨˜ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å…¥åŠ›ã—ã¾ã™ã€‚ oExcel = CREATEOBJECT("Excel.Appli
nantan 2011/02/08
win32ole

excel

ruby
ãƒªãƒ³ã‚¯
- Ruby ã«ã‚ˆã‚‹ Win32OLE ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚° - Excel ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ï¼ˆåˆç´šç·¨ï¼‰
You are here: Home Â» ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ Â» masarl memorial Â» homepage3.nifty.com Â» masarl Â» article Â» ruby-win32ole Â» Ruby ã«ã‚ˆã‚‹ Win32OLE ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚° - Excel ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ï¼ˆåˆç´šç·¨ï¼‰ ã¯ã˜ã‚ã« ã“ã“ã§ã¯ï¼Œå‰ã®ã‚»ã‚¯ã‚·ãƒ§ãƒ³ã§ä½œæˆã—ãŸ FileSystemObject ã‚¯ãƒ©ã‚¹ã‚’ä½¿ã£ã¦ Excel ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æ›¸ã„ã¦ã¿ã¾ã—ã‚‡ã†ï¼ŽãŸã ã‚ªãƒ¼ãƒ—ãƒ³ã™ã‚‹ã®ã§ã¯ãªãï¼Œèªã¿å–ã‚Šå°‚ç”¨ã§ Excel ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã‚’ä½œã£ã¦ã¿ã¾ã™ï¼Ž ãªãœã“ã‚“ãªãƒ„ãƒ¼ãƒ«ã‚’ä½œã‚‹ã®ã‹ã¨ã„ã†ç†ç”±ã‚’å°‘ã—ã ã‘æ›¸ã„ã¦ãŠãã¾ã—ã‚‡ã†ï¼Žä»¥å‰ã‹ã‹ã‚ã£ãŸä»•äº‹ã§ã™ãŒï¼Œãã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã¯é–‹ç™ºæ–‡æ›¸ãŒ Excel ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã—ã¦ Unix ä¸Šã«å¤§é‡ã«ã‚ã‚Šã¾ã—ãŸï¼Žã¨ã“ã‚ãŒï¼Œ Samba çµŒç”±ã§ Excel ãƒ•ã‚¡ã‚¤
nantan 2011/02/03
ruby

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

ãƒ¡ãƒ¼ãƒ«

ã‚½ãƒ•ãƒˆ

ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆ

ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
Browse code samples
nantan 2011/01/20
è‰²ã€ã‚«ãƒ©ãƒ¼

ruby

excel
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«æ“ä½œã®ã‚µãƒ³ãƒ—ãƒ«: å€‹äººçš„ãƒ¡ãƒ¢
#!ruby -Ks require 'win32ole' class Excel # å¤‰æ•° attr_reader :app attr_reader :book # åˆæœŸåŒ– def initialize @app = WIN32OLE.new('Excel.Application') WIN32OLE.const_load(@app, Excel) @app.visible = false end # ãƒ•ã‚¡ã‚¤ãƒ«ã‚ªãƒ¼ãƒ—ãƒ³ def open(path, readOnly = false) @book = @app.workBooks.open('FileName' => path, 'ReadOnly' => readOnly) begin yield @book ensure @book.saved true if readOnly # ä¿å˜ã—ãªã„ã§é–‰ã˜ã‚‹ @book.close @app
nantan 2011/01/20
ruby

excel
ãƒªãƒ³ã‚¯
Rubyã§Excelã‚’æ“ä½œã™ã‚‹ã¨ãã®Tipsã‚’ãƒ¡ãƒ¢ã‚‹ - Kwappaé–‹ç™ºå®¤
CUI ãª Git ãƒ–ãƒ©ã‚¦ã‚¶ tig ã‚’å…¥ã‚Œã¦ã¿ãŸ (Born Too Late) [git][scm][tig] tig ã‚’ä½¿ã£ã¦ã¿ãŸ (do_akiã®å¾’ç„¶æƒ³è¨˜) Twitter Trackbacks () ã¨ã¹ã¨ã¹å¤ç¥ã‚Š2010é›»è¨éƒ¨ã«å‚åŠ ã—ãŸ #tobesetu (key-cc) EC-CUBE LC_Page::sendRedirect()ã«å¼•æ•°ã‚’æ¸¡ã›ãªã„ (å¼±å°PHPerã®æ†‚é¬±) [densetu][å‹‰å¼·ä¼š][å¦æ ¡]é›»è¨éƒ¨ITå‹‰å¼·ä¼š#3ã‚„ã‚Šã¾ã™ãŸï¼ˆéšæ™‚è¿½è¨˜ (å¦å†…ITå‹‰å¼·ä¼šã®ã‚¹ã‚¹ãƒ¡ - atcorp) é›»è¨éƒ¨ITå‹‰å¼·ä¼š#3ã«å‚åŠ ã—ãŸã£ï¼ (Curious) GLT #24 ï¼ˆæ‡‡è¦ªä¼šï¼‰ã«ä¹±å…¥ã—ã¦ããŸï¼ (Curious) GLT (Genesis Lightning Talks) Vol.24ã«å‚åŠ ã—ã¾ã—ãŸ (key-cc) GLT (Genesis Lightning Talks
nantan 2010/12/08
excel

ruby
ãƒªãƒ³ã‚¯
Xcelsius | SAP Business Objects è£½å“ã®ã”æ¡ˆå†…
Xcelsiusã¯ã€Excelãƒ‡ãƒ¼ã‚¿ã‚’ã¾ã‚‹ã§ãƒ—ãƒã®ã‚ˆã†ãªãƒ‡ã‚¶ã‚¤ãƒ³ã®ãƒ¬ãƒãƒ¼ãƒˆã¸å¤‰æ›ã—ã€ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã«ã‚·ãƒŸãƒ¥ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã§ãã‚‹å¯¾è©±åž‹è¡¨ç¾ã§ã€é‡è¦ãªæ„æ€æ±ºå®šã«ãŠã‘ã‚‹å…±é€šç†è§£ã‚’ä¿ƒé€²ã—ã¾ã™ã€‚ ã¾ãŸã€ã•ã¾ã–ã¾ãªè£½å“ã¨çµ±åˆã•ã‚ŒãŸãƒ¯ãƒ¼ã‚¯ãƒ•ãƒãƒ¼ã‚’å®Ÿç¾ã—ã€åŠ¹çŽ‡çš„ãªé–‹ç™ºã‚’è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ›ãƒ¼ãƒ XCELSIUS ç‰¹é•· 1: ãƒ‡ãƒ¼ã‚¿æ´»ç”¨ ç‰¹é•· 2: ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ«åŒ– ç‰¹é•·03ãƒ¡ãƒ‡ã‚£ã‚¢ ãƒ‡ãƒ¢ ä»•æ§˜ è£½å“ã‚„Webãƒšãƒ¼ã‚¸ã«é–¢ã™ã‚‹ã€€ã”è³ªå•ã¯ã“ã¡ã‚‰ã¾ã§ â€»Business ObjectsãŠã‚ˆã³Business Objectsãƒã‚´ã€BusinessObjectsã€Crystal Reportsã€Crystal Decisionsã€ Web Intelligenceã€Xcelsiusã€ãŠã‚ˆã³æœ¬ã‚µã‚¤ãƒˆã§å¼•ç”¨ã•ã‚Œã¦ã„ã‚‹ãã®ä»–ã®Business Objectsè£½å“ã€ã‚µãƒ¼ãƒ“ã‚¹ã€ ãªã‚‰ã³ã«ãã‚Œãžã‚Œã®ãƒã‚´ã¯ã€ç±³å›½ãŠã‚ˆã³ãã®ä»–ã®å›½ã€…ã«ãŠã‘
nantan 2010/11/01
excel

flex
ãƒªãƒ³ã‚¯
æ‰‹ç´™æ–‡ä¾‹é›†(å¤šç¨®å¤šæ§˜ãªæ–‡ä¾‹/ä¾‹æ–‡ã‚’å¤šæ•°æŽ²è¼‰ã—ã¦ã„ã¾ã™)
æ›¸å¼/ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆé›†
nantan 2010/03/02
word

excel

ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆ
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸