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

hiby id:hiby

excelã«é–¢ã™ã‚‹hibyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ã“ã‚Œã¯ä¾¿åˆ©ã ï¼Excelâ†’TableåŒ–ã™ã‚‹jQueryãƒ—ãƒ©ã‚°ã‚¤ãƒ³
Webãƒšãƒ¼ã‚¸ã«æŽ²è¼‰ã™ã‚‹é¢å€’ãªè¡¨ï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ï¼‰ã®ä½œæˆã‚’æ¥½ã«ã—ãŸã„â€•â€•ã€‚ä»¥å‰ã€æœ¬ã‚µã‚¤ãƒˆã§ã¯Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç°¡å˜ã«HTMLï¼ˆTableã‚¿ã‚°ï¼‰ã«å¤‰æ›ã™ã‚‹Excelã‚¢ãƒ‰ã‚¤ãƒ³ã€ŒXLS2HTMLTableã€ã‚’ç´¹ä»‹ã—ãŸï¼ˆé–¢é€£è¨˜äº‹ï¼‰ã€‚XLS2HTMLTableã¯ã¨ã¦ã‚‚ä¾¿åˆ©ãªãƒ„ãƒ¼ãƒ«ã ãŒã€ãã‚Œã§ã‚‚è¡¨ãŒå¤§é‡ã«å¿…è¦ãªæ™‚ã«ã¯ã‚„ã¯ã‚Šæ‰‹é–“ãŒã‹ã‹ã‚‹ã€‚ ä»Šå›žã¯ã•ã‚‰ã«æ¥½ã‚’ã§ãã¦ä¾¿åˆ©ãªã‚¢ã‚¤ãƒ†ãƒ ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ãã‚ŒãŒã€CSVãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šãƒ†ã‚ã‚¹ãƒˆï¼‰ã‚’èªã¿è¾¼ã¿ã€Tableã«æ•´å½¢ã—ã¦è¡¨ç¤ºã™ã‚‹JavaScriptãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€Œjquery.csv2table.jsã€ã ã€‚ JavaScripté–¢é€£ã®è‘—æ›¸ã‚‚å¤šã„é«˜æ©‹ç™»å²æœ—æ°ãŒä½œã£ãŸã€Œjquery.csv2table.jsã€ã¯ã€åå‰ã®ã¨ãŠã‚ŠjQueryã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã¨ã—ã¦å‹•ä½œã™ã‚‹ã‚‚ã®ã§ã€HTMLã«ã‚ãšã‹æ•°è¡Œã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ãåŠ ãˆã‚‹ã ã‘ã§ä½¿ãˆã‚‹æ‰‹è»½ãªãƒ©ã‚¤ãƒ–ãƒ©ãƒªã ã€‚ã•ã£ããå®Ÿéš›ã«jquery.
hiby 2008/12/17
excel
ãƒªãƒ³ã‚¯
5ç§’ã§ã§ãã‚‹ã€çŸ¥ã£ã¦ã„ã‚‹ã¨ä¾¿åˆ©ãªã‚¨ã‚¯ã‚»ãƒ«ã®15ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
Chandoo.orgã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‹ã‚‰ã€5ç§’ã§çŸæ™‚é–“ã«å®Ÿè·µã§ãã‚‹ã€çŸ¥ã£ã¦ã„ã‚‹ã¨ä¾¿åˆ©ãªã‚¨ã‚¯ã‚»ãƒ«ã®15ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ Excel can be Exciting - 15 fun things you can do with your spreadsheet in less than 5 seconds â€»5ç§’ã¯ç„¡ç†ã€ã¨ã„ã†ã®ã‚‚ã‚ã‚Šã¾ã—ãŸã€‚ ã‚³ãƒ¡ãƒ³ãƒˆã®è‰²ãƒ»å›³å½¢ã®å¤‰æ›´
hiby 2008/08/06
ã‚°ãƒ©ãƒ•ã®è§’ä¸¸ã‚ã‚‰ã‚ŒãŸã‚“ã ã€‚

excel

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

tips
ãƒªãƒ³ã‚¯
ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã§ä¿è·ã•ã‚ŒãŸExcelã‚·ãƒ¼ãƒˆã‚’è§£é™¤ã™ã‚‹ãƒ•ãƒªãƒ¼ã®ã‚¢ãƒ‰ã‚¤ãƒ³ã€ŒExcel Password Remover 2008ã€ - GIGAZINE
Excelã®ã‚·ãƒ¼ãƒˆã‚„ãƒ¯ãƒ¼ã‚¯ãƒ–ãƒƒã‚¯å˜ä½ã§ã‹ã‘ã‚‰ã‚ŒãŸä¿è·ï¼ˆãƒãƒƒã‚¯ï¼‰ã‚’è§£é™¤ã™ã‚‹ãŸã‚ã«å¿…è¦ãªãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’æŽ¢ã‚Šå½“ã¦ã‚‹ç„¡æ–™ã®ã‚¨ã‚¯ã‚»ãƒ«ã‚¢ãƒ‰ã‚¤ãƒ³ã§ã™ã€‚ç·¨é›†ã—ã‚ˆã†ã¨ã—ãŸã‚‰ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒå¿…è¦ã ã£ãŸãŒã€å‰ä»»è€…ãªã©ãŒé€€è·ã—ã¦ã‚‚ã†ã„ãªã„ã®ã§ã©ã†ã—ã‚ˆã†ã‚‚ãªã„ã¨ã„ã†å ´åˆã«éžå¸¸ã«å½¹ç«‹ã¡ã¾ã™ã€‚ ä½¿ç”¨ã§ãã‚‹Excelã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯Excel 2000/XP/2003ã§ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¨ä½¿ã„æ–¹ã¯ä»¥ä¸‹ã‹ã‚‰ã€‚ Excel password: Excel password remover http://www.straxx.com/excel/password.html ä¸Šè¨˜ãƒšãƒ¼ã‚¸ã‹ã‚‰ã€Œpassword.xlaã€ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã€é©å½“ãªå ´æ‰€ã«ä¿å˜ã—ã¾ã™ã€‚ æ¬¡ã«Excelã‚’èµ·å‹•ã—ã€ã€Œãƒ„ãƒ¼ãƒ«ã€ã‹ã‚‰ã€Œã‚¢ãƒ‰ã‚¤ãƒ³ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€Œå‚ç…§ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ å…ˆã»ã©ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸã€Œpassword.xlaã€ã‚’é¸ã‚“ã§ã€ŒOKã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€ŒPas
hiby 2008/01/24
security

excel

tips
ãƒªãƒ³ã‚¯
3åˆ†LifeHackingï¼šExcelã®ã€Œã‚»ãƒ«å†…æ”¹è¡Œã€ã‚’ã¾ã¨ã‚ã¦å–ã‚Šé™¤ã - ITmedia Biz.ID
Excelã§ã‚»ãƒ«å†…æ”¹è¡Œã‚’ã™ã‚‹ã«ã¯ï¼»Altï¼½ï¼‹ï¼»Enterï¼½ã€‚ã§ã¯ã€ã“ã®ã‚»ãƒ«å†…æ”¹è¡Œã‚’ã¾ã¨ã‚ã¦å–ã‚Šé™¤ãã«ã¯ï¼»Ctrlï¼½ï¼‹ï¼»Jï¼½ã‚’ä½¿ãŠã†ã€‚ã•ã‚‰ã«ã“ã®ï¼»Ctrlï¼½ï¼‹ï¼»Jï¼½ã«ã¯ä¾¿åˆ©ãªåˆ©ç”¨æ–¹æ³•ã‚‚ã‚ã‚‹ã®ã ã€‚ Excelã®ã‚»ãƒ«å†…ã§æ–‡å—åˆ—ã‚’æ”¹è¡Œã—ãŸã„å ´åˆï¼»Altï¼½ï¼‹ï¼»Enterï¼½ã‚’æŠ¼ã™ã¨ã„ã†ãƒ¯ã‚¶ã¯ã€Excelã‚’æ‰±ã†ä¸Šã§ãœã²çŸ¥ã£ã¦ãŠããŸã„ã€‚ã‚¹ãƒšãƒ¼ã‚¹ã‚’é€£ç¶šå…¥åŠ›ã—ã¦ç”»é¢ä¸Šã§ç„¡ç†ã‚„ã‚Šæ”¹è¡Œã™ã‚‹ã¨ã€ã‚»ãƒ«å¹…ã‚’å¤‰æ›´ã—ãŸéš›ã«ã‚ºãƒ¬ã¦ã—ã¾ã†ã—ã€è¦‹ãŸç›®ã¯ã¡ã‚ƒã‚“ã¨æ”¹è¡Œã§ãã¦ã„ã¦ã‚‚ã†ã¾ãå°åˆ·ã§ããªã„ã“ã¨ã‚‚å¤šã„ã€‚Officeã®äº’æ›ã‚½ãƒ•ãƒˆã§é–‹ã„ãŸå ´åˆã«ã‚ºãƒ¬ã‚‹åŽŸå› ã«ã‚‚ãªã‚‹ã€‚ ã§ã¯ã€ï¼»Altï¼½ï¼‹ï¼»Enterï¼½ã§æ”¹è¡Œã—ãŸãƒ†ã‚ã‚¹ãƒˆã‚’å…ƒã®1è¡Œã®ãƒ†ã‚ã‚¹ãƒˆã«æˆ»ã™ãŸã‚ã«ã¯ã©ã†ã™ã‚Œã°ã‚ˆã„ã ã‚ã†ã‹ã€‚ ã‚‚ã¡ã‚ã‚“ã€ï¼»Backspaceï¼½ã‚„ï¼»Deleteï¼½ã§æ”¹è¡Œã‚’1ã¤ãšã¤å‰Šé™¤ã—ã¦ã‚‚ã‚ˆã„ã®ã ãŒã€æ”¹è¡ŒãŒå¤šã„å ´åˆã¯é¢å€’ãã•ã„ã€‚ã“ã†ã—ãŸå ´åˆã¯ã€Excelã®ç½®æ›æ©Ÿèƒ½ã‚’ç”¨ã„ã‚‹
hiby 2007/12/20
excel

tips
ãƒªãƒ³ã‚¯
Wikiã‚µãƒãƒ¼ãƒˆã‚¢ãƒ‰ã‚¤ãƒ³ï¼ˆãƒ„ãƒ¼ãƒ«ï¼‰ - ã‚¢ã‚¤ãƒ‡ã‚¢ãƒžãƒ³ã‚ºæ ªå¼ä¼šç¤¾
ç‰¹å¾´ Excelã®ã‚¢ãƒ‰ã‚¤ãƒ³ã¨ã—ã¦é¸æŠžç¯„å›²ã‚’PukiWikiãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã®è¡¨çµ„ã«å¤‰æ›ã—ã€ã‚¯ãƒªãƒƒãƒ—ãƒœãƒ¼ãƒ‰ã«ã‚³ãƒ”ãƒ¼ã—ã¾ã™ã€‚ PukiWikiä¸Šã§è¤‡é›‘ãªè¡¨çµ„ã¿ã‚’ã™ã‚‹å ´åˆã‚„ã€è¡¨çµ„ã¿ãŒè‹¦æ‰‹ãªæ–¹ã¯ã©ã†ãžãŠè©¦ã—ãã ã•ã„ã€‚ ã“ã‚Œã‚’æ›¸å¼ä»˜ãPukiWikiå½¢å¼ã§ã‚³ãƒ”ãƒ¼ã™ã‚‹ã¨ã€ã‚¯ãƒªãƒƒãƒ—ãƒœãƒ¼ãƒ‰ã« |>|RIGHT:|>|>|>|>|BGCOLOR(#C0C0C0):CENTER:2003å¹´| |~|~|>|>|>|BGCOLOR(#C0C0C0):CENTER:ç¬¬1å››åŠæœŸ|BGCOLOR(#C0C0C0):CENTER:åˆè¨ˆ| |~|~|BGCOLOR(#C0C0C0):CENTER:4æœˆ|BGCOLOR(#C0C0C0):CENTER:5æœˆ|BGCOLOR(#C0C0C0):CENTER:6æœˆ|BGCOLOR(#C0C0C0):CENTER:åˆè¨ˆ|~| ... ãŒã‚³ãƒ”ãƒ¼ã•ã‚Œã¦ã€PukiWikiã«è²¼ã‚Šä»˜ã‘ã‚‹ã¨ã“ã®
hiby 2006/09/26
EXCELWIKIã‚³ãƒ³ãƒãƒ¼ã‚¿ãƒ¼

wiki

excel

tool
ãƒªãƒ³ã‚¯
i d e a * i d e a - Excelã§ã‚¦ãƒ«ãƒˆãƒ©ã‚·ãƒ³ãƒ—ãƒ«ãªã‚°ãƒ©ãƒ•ã‚’ä½œæˆã™ã‚‹æ–¹æ³•
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
hiby 2006/08/28
biz

excel

design
ãƒªãƒ³ã‚¯
1