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

inokara id:inokara

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

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

Rubyist Magazine - ã‚¹ã¯ã‚¹ãƒšãƒƒã‚¯ã®ã‚¹ ã€ç¬¬ 1 å›žã€‘ RSpec ã®æ¦‚è¦ã¨ã€RSpec on Rails (ãƒ¢ãƒ‡ãƒ«ç·¨)
ã€Žã‚‹ã³ã¾ã€ã¯ã€Ruby ã«é–¢ã™ã‚‹æŠ€è¡“è¨˜äº‹ã¯ã‚‚ã¡ã‚ã‚“ã®ã“ã¨ã€Rubyist ã¸ã®ã‚¤ãƒ³ã‚¿ãƒ“ãƒ¥ãƒ¼ã‚„ã‚¨ãƒƒã‚»ã‚¤ã€ãã®ä»–ã‚’ãŠå±Šã‘ã™ã‚‹ã‚¦ã‚§ãƒ–é›‘èªŒã§ã™ã€‚ Rubyist Magazine ã«ã¤ã„ã¦ ã€ŽRubyist Magazineã€ã€ç•¥ã—ã¦ã€Žã‚‹ã³ã¾ã€ã¯ã€Rubyist ã® Rubyist ã«ã‚ˆã‚‹ã€Rubyist ã¨ãã†ã§ãªã„äººã®ãŸã‚ã®ã‚¦ã‚§ãƒ–é›‘èªŒã§ã™ã€‚ æœ€æ–°å· Rubyist Magazine 0063 å· ãƒãƒƒã‚¯ãƒŠãƒ³ãƒãƒ¼ Rubyist Magazine 0063 å· Rubyist Magazine 0062 å· Kaigi on Rails ç‰¹é›†å· RubyKaigi Takeout 2020 ç‰¹é›†å· Rubyist Magazine 0061 å· Rubyist Magazine 0060 å· RubyKaigi 2019 ç›´å‰ç‰¹é›†å· Rubyist Magazine 0059 å· Rubyist
inokara 2013/09/14
Excel

ruby
ãƒªãƒ³ã‚¯
Rubyã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿å‡¦ç†
TSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’CSVãƒ•ã‚¡ã‚¤ãƒ«ã« ã‚¿ãƒ–åŒºåˆ‡ã‚Šï¼ˆTSVï¼ŒTab-Separated Valuesï¼‰ãƒ†ã‚ã‚¹ãƒˆã‚’èªã‚“ã§CSVï¼ˆComma-Separated Valuesï¼‰ã«ã—ã¦å‡ºåŠ›ã™ã‚‹ã€‚ç°¡æ˜“ç‰ˆã§ã‚ã‚Šï¼Œå…ƒã®ãƒ‡ãƒ¼ã‚¿ã«ã‚³ãƒ³ãƒžãŒå«ã¾ã‚Œã¦ã„ã‚‹ã¨ã¾ãšã„ã€‚1è¡Œç›®ã® -w ã¯warningã‚’onã«ã™ã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§ã‚ã‚‹ãŒï¼Œ/usr/bin/env ã¨çµ„ã¿åˆã‚ã›ã‚‹ã¨ï¼Œç’°å¢ƒã«ã‚ˆã£ã¦ã¯ã†ã¾ãã„ã‹ãªã„ã€‚ãã®å ´åˆã¯ -w ã‚’å–ã‚‹ã‹ï¼Œã‚ã‚‹ã„ã¯ #! /usr/bin/ruby -w ã®ã‚ˆã†ã«ãƒ•ãƒ«ãƒ‘ã‚¹ã«ã™ã‚‹ã€‚2è¡Œç›®ã¯çœç•¥å¯ã€‚ #! /usr/bin/env ruby -w # coding: utf-8 while line = gets puts line.split("\t").join(",") end ã‚¿ãƒ–ï¼ˆ"\t"ï¼‰ã‚’åŒºåˆ‡ã‚Šã¨ã—ã¦é…åˆ—ã«åˆ†å‰²ã—ï¼Œãã‚Œã‚’å†ã³ã‚³ãƒ³ãƒžï¼ˆ","ï¼‰ã§çµåˆã—ã¦ã„ã‚‹ã€‚å®Ÿã¯ï¼Œline ã«ã¯æ”¹è¡Œã‚‚ä»˜ã„
inokara 2013/09/14
Ruby

Excel

ãƒ‡ãƒ¼ã‚¿å‡¦ç†
ãƒªãƒ³ã‚¯
Rubyã§Excelã‚’æ“ä½œã™ã‚‹ã¨ãã®Tipsã‚’ãƒ¡ãƒ¢ã‚‹
æ˜¨å¹´ã€ŒRubyã§Excelã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿è¾¼ã‚€ã€ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã‚’ç«‹ã¦ãŸã€‚Excelã®ãƒ‡ãƒ¼ã‚¿ã‚’Rubyã§å‡¦ç†ã™ã‚‹ã¨ã€ã‚ªãƒ•ã‚£ã‚¹ã‚¢ãƒ—ãƒªã‚’ä½¿ã†ãƒ¬ã‚¤ãƒ¤ã¨ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’ã™ã‚‹ãƒ¬ã‚¤ãƒ¤ã®æ©‹æ¸¡ã—ãŒç°¡å˜ã«ãªã‚Šã¾ã™ã‚ˆã€ã¨ã„ã†è¨˜äº‹ã ã£ãŸã€‚ ä»Šå›žã¯ãã®ç¶šç·¨ã€‚Rubyã®æ–¹ã‹ã‚‰Excelã«å€¤ã‚„æ›¸å¼ã‚’è¨å®šã—ã¦ã„ãéš›ã®Tipsã‚’ãƒ¡ãƒ¢ã£ã¦ãŠãã€‚ TipsExcelã®ãƒ—ãƒã‚»ã‚¹ã‚’æ®‹ã•ãªã„ã‚ˆã†ã«ã™ã‚‹ãƒã‚°ãªã©ã§Rubyã‚¹ã‚¯ãƒªãƒ—ãƒˆã®å®Ÿè¡ŒãŒæ¢ã¾ã£ã¦ã—ã¾ã£ã¦ã‚‚ã€Excelã®ãƒ—ãƒã‚»ã‚¹ã¯ç”Ÿãæ®‹ã£ã¦ã„ã‚‹ã€‚å¾Œã§ã‚¿ã‚¹ã‚¯ãƒžãƒãƒ¼ã‚¸ãƒ£ã‚’è¦‹ã¦æ…Œã¦ã‚‹ã“ã¨ã«ãªã‚‹ã®ã§ã€ã¾ãšã¯ä¾‹å¤–ã‚’ã¤ã‹ã¾ãˆã¦ãƒ—ãƒã‚»ã‚¹çµ‚äº†ã™ã‚‹ã‚ˆã†ä»•è¾¼ã¿ã‚’ã—ã‚ˆã†ã€‚ @app = WIN32OLE.new('Excel.Application') begin # do_something ensure @app.quit end å®šæ•°ã‚’èªã¿è¾¼ã‚€ / ä½¿ã†æ›¸å¼æŒ‡å®šã‚„ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãªã©ã«Excelã§å®šç¾©ã•ã‚Œã¦ã„ã‚‹
inokara 2013/09/13
memo

Ruby

Excel
ãƒªãƒ³ã‚¯
Rubyã§Excelãƒ‡ãƒ¼ã‚¿ã‚’JSONå½¢å¼ã«å¤‰æ›ã™ã‚‹ã«ã¯ï½œTechRacho by BPSæ ªå¼ä¼šç¤¾
Excelã§ä½œã£ãŸè¡¨ãƒ‡ãƒ¼ã‚¿ã‚’JavaScriptã§ã‚ã‚Œã“ã‚Œã—ãŸã„æ™‚ã«ï¼ŒExcelãƒ‡ãƒ¼ã‚¿ã‚’JSONã«å¤‰æ›ã—ãŸã„ã“ã¨ãŒã‚ã£ãŸã®ã§ï¼Œã•ã£ãã‚Šæ›¸ã„ã¦ã¿ã¾ã—ãŸï¼Žç‰¹å¾´ã¨ã—ã¦ã¯ï¼Œã‚»ãƒ«å†…æ”¹è¡ŒãŒã‚ã£ã¦ã‚‚æ£ã—ããƒ‡ãƒ¼ã‚¿ãŒå–ã‚Œã‚‹ã®ã§ï¼ŒCSVã‚„TSVã«æ¯”ã¹ã‚‹ã¨ãƒ‡ãƒ¼ã‚¿ã«è‡ªç”±ãŒåŠ¹ãç‚¹ãŒã‚ã‚Šã¾ã™ï¼ŽHTMLã‚’å…¥ã‚Œã¦ã¿ãŸã‚Šï¼ŒJavaScriptã‚’å…¥ã‚Œã¦èªã¿è¾¼ã¿å´ã§eval()ã—ã¦ã¿ãŸã‚Šã¨è‰²ã€…å¿œç”¨ãŒåˆ©ãã¨æ€ã„ã¾ã™ï¼Ž å‹•ä½œç’°å¢ƒ å‹•ä½œç’°å¢ƒã¯Ruby 1.9.3ï¼ŒActiveSupport 3.2.13ï¼Œroo 1.11.2ã§ã™ï¼ŽMacç’°å¢ƒã§ã®ã¿ç¢ºèªã—ã¦ã„ã¾ã™ï¼Žã”åˆ©ç”¨ã¯è‡ªå·±è²¬ä»»ã§ãŠé¡˜ã„ã—ã¾ã™ï¼Ž åˆ©ç”¨æ–¹æ³• ã¾ãšï¼Œä»¥ä¸‹ã®gemã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ï¼Ž $ gem install active_support roo ãã®å¾Œï¼Œä»¥ä¸‹ã®ã‚³ãƒ¼ãƒ‰ã‚’excel2json.rbã¨ã—ã¦ä¿å˜ã—ã¾ã™ï¼ŽExcelãƒ‡ãƒ¼ã‚¿ã®ãƒ•ã‚¡ã‚¤ãƒ«åã¯é©å®œå¤‰æ›´ã—ã¦ãã ã•ã„ï¼Ž #
inokara 2013/08/09
ãŠã‚‚ã‚ãƒ¼ã€‚

Ruby

json

Excel
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (4)

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

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (4)

Excelã«é–¢ã™ã‚‹inokaraã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

Rubyist Magazine - ã‚¹ã¯ã‚¹ãƒšãƒƒã‚¯ã®ã‚¹ ã€ç¬¬ 1 å›žã€‘ RSpec ã®æ¦‚è¦ã¨ã€RSpec on Rails (ãƒ¢ãƒ‡ãƒ«ç·¨)

Rubyã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿å‡¦ç†

Rubyã§Excelã‚’æ“ä½œã™ã‚‹ã¨ãã®Tipsã‚’ãƒ¡ãƒ¢ã‚‹

Rubyã§Excelãƒ‡ãƒ¼ã‚¿ã‚’JSONå½¢å¼ã«å¤‰æ›ã™ã‚‹ã«ã¯ï½œTechRacho by BPSæ ªå¼ä¼šç¤¾

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (4)

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

Rubyist Magazine - ã‚¹ã¯ã‚¹ãƒšãƒƒã‚¯ã®ã‚¹ ã€ç¬¬ 1 å›žã€‘ RSpec ã®æ¦‚è¦ã¨ã€RSpec on Rails (ãƒ¢ãƒ‡ãƒ«ç·¨)

Rubyã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿å‡¦ç†

Rubyã§Excelã‚’æ“ä½œã™ã‚‹ã¨ãã®Tipsã‚’ãƒ¡ãƒ¢ã‚‹

Rubyã§Excelãƒ‡ãƒ¼ã‚¿ã‚’JSONå½¢å¼ã«å¤‰æ›ã™ã‚‹ã«ã¯ï½œTechRacho by BPSæ ªå¼ä¼šç¤¾

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹