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

kishir id:kishir

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

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

ASCII.jpï¼šExcelã³ã£ãã‚ŠæŠ€6ã€€ã“ã‚“ãªã“ã¨ã‚‚ã§ããŸã®ã‹ï¼ (1/2)ï½œExcelé”äººã®æ–°å®šç•ªãƒ†ã‚¯60ã€€çŸ¥ã‚‰ãªã„ã‚ãªãŸã¯æã—ã¦ã‚‹ï¼
ãƒžãƒ³ãƒãƒªåŒ–ã—ãŸæ–¹æ³•ã§Excelã‚’ä½¿ã£ã¦ã„ãªã„ã§ã—ã‚‡ã†ã‹ã€‚å®Ÿã¯ã‚‚ã£ã¨ç°¡å˜ã§æ‰‹æ—©ãã§ãã‚‹æŠ€ãŒã‚ã‚‹ã®ã§ã™ã€‚ä½¿ã‚ãªã„ãªã‚“ã¦ã‚‚ã£ãŸã„ãªã„ã€‚ã‚¢ãƒŠã‚¿ã®çŸ¥ã‚‰ãªã„ã€Œæ–°ã€ExcelæŠ€å¤§ç‰¹é›†ï¼ã€€ç¬¬4å›žã§ã¯Excelã®ä¾¿åˆ©æŠ€ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚æ©Ÿèƒ½åŒå£«ã‚’ã†ã¾ãçµ„ã¿åˆã‚ã›ãŸã‚Šã€ãŠãªã˜ã¿ã®æ©Ÿèƒ½ã§ã‚‚æ–°ã—ã„ä½¿ã„æ–¹ã‚’ã—ã¦ã¿ã‚‹ã¨ã€æ„å¤–ãªã“ã¨ãŒã§ãã‚‹ã®ã§ã™ï¼ è¦šãˆã¦ãŠããŸã„ã€€Excelã³ã£ãã‚ŠæŠ€6â€•â€•ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ æŠ€49â€•â€•ã€€è¨ˆç®—å¼ã‚’è¦‹ã›ãšæ•°å€¤ã«å¤‰ãˆã‚‹ æŠ€50â€•â€•ã€€ãƒ†ã‚ã‚¹ãƒˆãƒœãƒƒã‚¯ã‚¹ã«ã‚»ãƒ«ã®å†…å®¹ã‚’è¡¨ç¤ºã™ã‚‹ æŠ€51â€•â€•ã€€çµæžœãŒãƒžã‚¤ãƒŠã‚¹ã«ãªã‚‹æ™‚é–“è¨ˆç®—ã‚’ã™ã‚‹ã«ã¯ï¼Ÿ æŠ€52â€•â€•ã€€ã‚³ãƒ¡ãƒ³ãƒˆã«ä»˜ãåå‰ã‚’å®šåž‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã«å¤‰ãˆã‚‹ æŠ€53â€•â€•ã€€ãƒªã‚¹ãƒˆã‹ã‚‰é¸ã‚“ã§å°åˆ·ã™ã‚‹è¡¨ã‚’åˆ‡ã‚Šæ›¿ãˆã‚‹ æŠ€54â€•â€•ã€€ãƒ„ãƒ¼ãƒ«ãƒãƒ¼ã®ãƒœã‚¿ãƒ³ã‚’å¤§ããã—ã¦è¦‹ã‚„ã™ãã™ã‚‹ æŠ€-49 è¨ˆç®—å¼ã‚’è¦‹ã›ãšæ•°å€¤ã«å¤‰ãˆã‚‹ å®¢å…ˆã«è¦‹ã›ã‚‹è¡¨ãªã©ã¯ã€è¨ˆç®—ã®çµæžœã ã‘ãŒå¿…è¦ã§ã€ãã®è¨ˆç®—å†…å®¹ã¯è¦‹ã›ãŸããªã„ã¨ã„ã†
kishir 2008/11/21
excel

tips
ãƒªãƒ³ã‚¯
ç‰¹å®šã®ãƒ•ã‚©ãƒ«ãƒ€ä»¥ä¸‹ã®Excelãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚·ãƒ¼ãƒˆã‚’ã²ã¨ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¾ã¨ã‚ã‚‹JScript - Bouldering & Com.
Windows Scriptãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¨ã€Excel VBAã®ãƒ˜ãƒ«ãƒ—ã‚’è¦‹ãªãŒã‚‰æ›¸ãæ›¸ãã€‚ ã¤ã„ã§ã«ã‚·ãƒ¼ãƒˆåã‚‚ãƒ•ã‚¡ã‚¤ãƒ«åã«ãã†ã‹ãŸã¡ã«å¤‰æ›´ã€‚ copy_and_merge(); function copy_and_merge() { var excel = WScript.CreateObject("Excel.Application"); var fso = new ActiveXObject("Scripting.FileSystemObject"); wb_dest = excel.Workbooks.Add(); var dir_inFiles = fso.GetFolder(".\\data").files; var enume_Obj = new Enumerator(dir_inFiles); for (var i = 0; !enume_Obj.atEnd(); enume
kishir 2008/07/15
javascript

excel
ãƒªãƒ³ã‚¯
RSSã‚’ã‚¨ã‚¯ã‚»ãƒ«ã«æ›¸ãå‡ºã—ã¦ãã‚Œã‚‹ã€ŒFeedpourã€ ï¼šã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ¡ãƒ‡ã‚£ã‚¢.jp
RSSã‚’ã‚¨ã‚¯ã‚»ãƒ«ã«æ›¸ãå‡ºã—ã¦ãã‚Œã‚‹ã€ŒFeedpourã€ã€‚ RSSï¼ˆAtomï¼‰ã®ãƒ•ã‚£ãƒ¼ãƒ‰URLã‚’å…¥åŠ›ã™ã‚‹ã¨ã€ã‚¨ã‚¯ã‚»ãƒ«ã‹ã€RTFã€PDFã§æ›¸ãå‡ºã—ã¦ãã‚Œã‚‹ã€‚ ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªã®ã¯ã€ãƒ¦ãƒ¼ã‚¶ç™»éŒ²ãªã—ã§å…¬é–‹ã•ã‚Œã¡ã‚ƒã†ç‚¹ã€‚ãŸã—ã‹ã«å…ƒã€…ãŒå…¬é–‹ã•ã‚Œã¦ã„ã‚‹Feedã ã‹ã‚‰ã‚ˆã„ã‚‚ã®ã®ã€‚ãªãŠã€æ—¥æœ¬èªžã¯æ–‡å—åŒ–ã‘ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¯å°ç²‹ãªãƒ„ãƒ¼ãƒ«ã§ã™ãã€‚ãªã«ã‹ã«ä½¿ãˆãã†ãƒ»ãƒ»ãƒ»ã€‚ Â» Feedpour
kishir 2008/05/27
rss

excel
ãƒªãƒ³ã‚¯
PiTaPaã®CSVã‹ã‚‰TabåŒºåˆ‡ã‚Šãƒ†ã‚ã‚¹ãƒˆã«ç·¨é›† - mitszoã®æ—¥è¨˜
PiTaPa ã®åˆ©ç”¨æ˜Žç´°ãŒCSVãƒ•ã‚¡ã‚¤ãƒ«ã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã®ã§ã€ãã‚Œã‚’ä¼šç¤¾ã®äº¤é€šè²»æ¸…ç®—ç”¨Excelã‚·ãƒ¼ãƒˆã«è²¼ã‚Šä»˜ã‘ã‚‰ã‚Œã‚‹ã‚ˆã†ã«TabåŒºåˆ‡ã‚Šã«ç·¨é›†ã—ã¦ã¿ãŸã€‚ #!/usr/bin/env python # -*- encoding: shift_jis -*- import sys, re, fileinput # å‡ºåŠ›ãƒ‡ãƒ¼ã‚¿ã‹ã‚‰çœãçµŒè·¯ TUKIN_KEIRO = [ set(['è¥¿ä¸å³¶å—æ–¹','é›£æ³¢']), set(['æ–°å¤§é˜ª', 'é›£æ³¢']), set(['æ±ä¸‰å›½', 'é›£æ³¢']), set(['é›£æ³¢', 'è›¸åœ°è”µ']) ] def for_transport(array): if len(array) == 6 : if re.match('\d{4}/\d{2}/\d{2}',array[0]): # æ—¥ä»˜ if re.match('\d{2}:\d{2}',array[2])
kishir 2008/04/27
python

excel
ãƒªãƒ³ã‚¯
Excelãƒ‡ãƒ¼ã‚¿ã‚’ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ©ã‚¤ã‚ºã—ã‚ˆã† - DesignWalker
kishir 2008/04/10
excel
ãƒªãƒ³ã‚¯
æ‰‹ç´™æ–‡ä¾‹é›†(å¤šç¨®å¤šæ§˜ãªæ–‡ä¾‹/ä¾‹æ–‡ã‚’å¤šæ•°æŽ²è¼‰ã—ã¦ã„ã¾ã™)
æ›¸å¼/ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆé›†
kishir 2008/04/08
template

excel
ãƒªãƒ³ã‚¯
ç½«ç·š - å¼·ç«ã§é€²ã‚
# -*- coding: utf-8 -*- import pyExcelerator w = pyExcelerator.Workbook() ws = w.add_sheet(u'ã‚·ãƒ¼ãƒˆ(1)') for i in range(18): brd = pyExcelerator.Borders() brd.left = i brd.right = i brd.top = i brd.bottom = i style = pyExcelerator.XFStyle() style.borders = brd ws.write(i*2, 0, i) ws.write(i*2, 1, '', style) w.save('boders.xls') ã€ä½œæˆã—ãŸExcelã®å†…å®¹ã€‘ ã€è§£èª¬ã€‘ ä»¥ä¸‹ã®æ§˜ã«å„è¾ºã«ç½«ç·šã®ç¨®é¡žã‚’è¨å®šã—ã€ä½¿ç”¨ã—ã¾ã™ã€‚å€¤ã¯0ã€œ13ãŒä½¿ãˆã‚‹æ§˜ã§ã™ã€‚ brd = pyExcele
kishir 2008/03/26
python

excel
ãƒªãƒ³ã‚¯
ãƒ“ã‚¸ãƒã‚¹æ–‡æ›¸ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆé›†
ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯ç„¡æ–™ã€‚ä¼šå“¡ç™»éŒ²ã‚‚ä¸è¦ã€‚çµŒé©åºƒå ´ã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã¯æ¥å‹™ã ã‘ã§ãªãã€çµŒå–¶ã«ã‚‚å½¹ç«‹ã¤ãƒ¯ãƒ¼ãƒ‰ãƒ»ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆé›†ã§ã™ã€‚ ãƒžã‚¯ãƒã®è¨ˆç®—å¼ãŒçµ„ã¿è¾¼ã¾ã‚ŒãŸã‚¨ã‚¯ã‚»ãƒ«ã¯ã€ ç¨Žç†å£«ãƒ»å…¬èªä¼šè¨ˆå£«ã®è³‡æ ¼ã‚’ã‚‚ã¤ITã‚³ãƒ¼ãƒ‡ã‚£ãƒãƒ¼ã‚¿ã‚°ãƒ«ãƒ¼ãƒ— ã€Œå…¨å›½ITæŽ¨é€²ç ”ç©¶ä¼šï¼ˆMSITC)ã€ã«ã€ åˆ¶ä½œå”åŠ›ã‚’ã„ãŸã ã„ã¦ã„ã¾ã™ã€‚
kishir 2008/02/21
template

excel

word
ãƒªãƒ³ã‚¯
1