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

ma_ko id:ma_ko

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

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

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
ma_ko 2017/01/15
gitã®textconvã«Apache Tikaã‚’ä½¿ã£ã¦æ¯”è¼ƒå¯èƒ½ãªçŠ¶æ…‹ã«ã‚‚ã£ã¦ã

git

Excel

diff
ãƒªãƒ³ã‚¯
xlrd, xlwtã§Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã¨ã—ã¦ä½¿ã† â€“ æ—¥æ›œç ”ç©¶å®¤
Pythonã§Excelãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆBIFFå½¢å¼ã€æ‹¡å¼µåã§ã„ãˆã°xlsï¼‰ã‚’æ‰±ã†å ´åˆã«ã¯ã€ pyExcelerator xlrd, xlwt, xlutils Win32OLEï¼ˆWindowsç’°å¢ƒã®ã¿ï¼‰ è¾ºã‚Šã‚’ä½¿ã†ã®ãŒä¸€èˆ¬çš„ã‹ã¨æ€ã„ã¾ã™ã€‚ä»–ã®é¸æŠžè‚¢ã¯çŸ¥ã‚Šã¾ã›ã‚“ã€‚ ä»Šå›žã¯é–‹ç™ºç’°å¢ƒãŒMac OS X 10.6ã€ãƒ‡ãƒ—ãƒã‚¤ç’°å¢ƒãŒCentOS 5.4ã ã£ãŸã®ã§å½“ç„¶Win32OLEã®é¸æŠžè‚¢ã¯é™¤å¤–ã—ã¾ã—ãŸã€‚ pyExceleratorã¯ã€ç½«ç·šã‚„ãƒ•ã‚©ãƒ³ãƒˆã‚„ã‚»ãƒ«ã®ã‚¹ã‚¿ã‚¤ãƒ«ãªã©ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç´°ã‹ãæŒ‡å®šã—ã¦æ›¸ãå‡ºã›ã‚‹ã‚ˆã†ã§ã™ãŒã€èªã¿è¾¼ã¿æ©Ÿèƒ½ãŒå‡„ãã‚·ãƒ³ãƒ—ãƒ«ã§ã€ã‚»ãƒ«ã®å€¤ã¨ãã®åº§æ¨™ã®ã¿æŠ½å‡ºã§ãã‚‹ï¼ˆç½«ç·šã‚„ãƒ•ã‚©ãƒ³ãƒˆã‚„ã‚»ãƒ«ã®ã‚¹ã‚¿ã‚¤ãƒ«ãªã©ã¯èªã¿è¾¼ã‚ãªã„ï¼‰ã‚ˆã†ã§ã€ã€Œè£…é£¾ã‚’æ–½ã—ã¦ä½“è£ã‚’æ•´ãˆãŸExcelãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿è¾¼ã‚€ã€â†’ã€Œå¿…è¦ãªéƒ¨åˆ†ã ã‘ä¸Šæ›¸ãã—ã¦ä¿å˜ã€ã¨ã„ã†ã„ã‚ã‚†ã‚‹ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆæ–¹å¼ã®Excelãƒ•ã‚¡ã‚¤ãƒ«ã®åˆ©ç”¨ãŒã§ãã¾ã›ã‚“ã€‚ï¼ˆã¾ãã€ã‹ãªã‚Š
ma_ko 2014/02/14
python

Excel
ãƒªãƒ³ã‚¯
ãƒ©ã‚¤ãƒ–ãƒ©ãƒª: xlrd
xlrd ã¯ Excel (xls) ã®ãƒ‡ãƒ¼ã‚¿ã‚’ Python ã§èªã‚€ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã™ã€‚ xlrd ã¯èªã¿è¾¼ã¿å°‚ç”¨ã§ã€æ›¸ãè¾¼ã¿ç”¨ã® xlwt ã¨ã„ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚‚å˜åœ¨ã—ã¾ã™ã€‚ xlrd ã§ã¯ Book â†’ Sheet â†’ Cell ã¨ã„ã†æ§‹é€ ã§ã‚¨ã‚¯ã‚»ãƒ«ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã—ã¾ã™ã€‚ ã¾ãšã¯ Book ã‚’é–‹ãã¨ã“ã‚ã‹ã‚‰è¦‹ã¦ã„ãã¾ã—ã‚‡ã†ã€‚ Excel ãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–‹ãã«ã¯é–¢æ•° open_workbook() ã‚’ç”¨ã„ã¾ã™ã€‚å¼•æ•°ã¯å¯¾è±¡ãƒ•ã‚¡ã‚¤ãƒ«ã®ãƒ‘ã‚¹ã§ã™ã€‚
ma_ko 2014/02/14
xlsx ã‚‚ã„ã‘ã‚‹

python

Excel
ãƒªãƒ³ã‚¯
Mr. Data Converter
Takes CSV or tab-delimited data from Excel and converts it into several web-friendly formats, include JSON and XML. Comments, suggestions and complaints are welcome at mr.dataconverter@gmail.com. Receive notices about upgrades and bugfixes on twitter: @mrdataconverter.
ma_ko 2012/05/15
CSV ã‹ TSV ã§ã‚¤ãƒ³ãƒ—ãƒƒãƒˆ

Excel
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«ã‚·ãƒ¼ãƒˆã‚’HTMLãƒ†ãƒ¼ãƒ–ãƒ«ã«å¤‰æ›ã—ã¡ã‚ƒã†å› (Î²Î²)
STEP1. ã‚¨ã‚¯ã‚»ãƒ«ã¨ã‹ã‹ã‚‰CSV (TSV)ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã‚’è²¼ã‚Šä»˜ã‘ STEP2. ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’é¸æŠžã—ã¦å¤‰æ› ç´°ã‹ã„è¨å®š åˆ—ç›®ã¾ã§ã‚’THEADã¨ã™ã‚‹ã€‚(0ã§THEADãªã—) TBODYã®è¡Œç›®ã¾ã§ã‚’THã¨ã™ã‚‹ã€‚ TBODY THã«æ·±åº¦ã‚’åŸ‹ã‚è¾¼ã‚“ã ã‚¯ãƒ©ã‚¹åã‚’è¿½åŠ ã™ã‚‹ã€‚(1ã€œ) ã‚¯ãƒ©ã‚¹åï¼š " + n" ã²ã¨ã¤ã‚ã®THã«æ·±åº¦ã‚¯ãƒ©ã‚¹ã‚’è¿½åŠ ã—ãªã„ã€‚(lv1ã‚’è¿½åŠ ã—ãªã„) nåˆ—ã”ã¨ã«TRã«ã‚¯ãƒ©ã‚¹åã‚’è¿½åŠ ã™ã‚‹ã€‚(0ã€œ) ã‚¯ãƒ©ã‚¹åï¼š åˆ—æ•°ã€€ã€€ï¼š ã‚¯ãƒ©ã‚¹åã«åˆ—æ•°ã‚’è¿½åŠ ã™ã‚‹ã€‚(nrow0, nrow1,,)
ma_ko 2012/05/06
Excel

Webã‚µãƒ¼ãƒ“ã‚¹
ãƒªãƒ³ã‚¯
1