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

tomoemon id:tomoemon

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

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

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
tomoemon 2012/08/12
ãŠã„ãŠã„ã€‚ã“ã„ã¤ã¯ã‚„ã°ã™ãŽã‚“ã ã‚

python

excel

plugin

programming
ãƒªãƒ³ã‚¯
https://pythonhosted.org/openpyxl/
tomoemon 2012/04/16
python

excel

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

excel
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«ã§ã€ç‰¹å®šã®æ–‡å—å€‹æ•°ã‚’ã‚«ã‚¦ãƒ³ãƒˆã™ã‚‹æ–¹æ³•ã¯ï¼Ÿ - OKWAVE
ã‚¨ã‚¯ã‚»ãƒ«ã«ã¦ã€ä¾‹ãˆã° | A | B | C | 1| X | | XX| ï¼ˆA1ã«ã¯XãŒï¼‘å€‹ã€B1ã¯ç©ºç™½ã‚»ãƒ«ã€C1ã¯XãŒï¼’å€‹ï¼‰ ã¨ã„ã†ã¨ãã€A1ã‹ã‚‰C1å†…ã®Xã®æ•°ã‚’ã‚«ã‚¦ãƒ³ãƒˆã—ãŸã„ï¼ˆã“ã®ä¾‹ã§ã¯3å€‹ï¼‰ã®ã§ã™ãŒã€è¨ˆç®—å¼ã¯ã©ã†ã™ã‚Œã°ã„ã„ã§ã—ã‚‡ã†ã‹ï¼Ÿä¸Šè¨˜ã®ä¾‹ã§è¨€ã†ã¨ã€D1ã«è¨ˆç®—å¼ã‚’è¨˜å…¥ã—ãŸã„ã§ã™ã€‚
tomoemon 2010/07/28
excel
ãƒªãƒ³ã‚¯
ã€Œå²è·¯ã«ç«‹ã¤ã‚¹ãƒ¼ãƒ€ãƒ³ã€â€•å—éƒ¨ç‹¬ç«‹ã¨å’Œå¹³ã®ç‹é–“ã§(pdf)
ã‚ãªãŸã®è²·ã„ç‰©ãŒã€ç¾åœ°ã®æ˜Žæ—¥ã«ã¤ãªãŒã‚‹ æ›¸ç±ã§çŸ¥ã‚‹ã€ç’°å¢ƒã‚„äººæ¨©ã«é…æ…®ã—ãŸè£½å“ã‚„ã€ç¾åœ°ã®äººã€…ãŒä½œã£ãŸã‚¯ãƒ©ãƒ•ãƒˆã§ç”Ÿæ´»ã‚’å½©ã‚‹ã€‚ ã‚ãªãŸã®ãŠè²·ã„ç‰©ãŒã€ç¾åœ°ã®äººã€…ã®æ”¯æ´ã«ç¹‹ãŒã‚Šã¾ã™ã€‚
tomoemon 2008/05/30
excel

tool
ãƒªãƒ³ã‚¯
Excelãƒ‡ãƒ¼ã‚¿ã‚’ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ©ã‚¤ã‚ºã—ã‚ˆã† - DesignWalker
tomoemon 2008/04/10
ã‚»ãƒ«å†…ã‚°ãƒ©ãƒ•ãŒé¢ç™½ãã†

excel

tool

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

howto
ãƒªãƒ³ã‚¯
1