[B! spreadsheet] patorashã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

patorash id:patorash

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

pure ruby ã®å„ç¨®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆå¯¾å¿œSpreadsheetãƒ‘ãƒ¼ã‚µ(xlsxå¯¾å¿œ!): ã²æ—¥è¨˜
roo - rubyforge ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãƒšãƒ¼ã‚¸ OOo, Google Document, Excel(2007ã®æ–°ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆå¯¾å¿œ)ã¨ã€å¹…åºƒã„ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã¸ã®å¯¾å¿œã‚’è¬³ã†ã€ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ãƒ‘ãƒ¼ã‚µ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®æ›´æ–°ãŒè¿½ã„ä»˜ã„ã¦ã„ãªã„ã‚ˆã†ã§ã™ãŒã€æœ€æ–°ç‰ˆã¯1.3.9 ãƒ•ã‚¡ã‚¤ãƒ«ã®æ–°è¦ä½œæˆã«ã¯æœªå¯¾å¿œ ãƒ•ã‚¡ã‚¤ãƒ«ã®æ›´æ–°ã¯ã€Google Spreadsheetã®ã¿å¯¾å¿œ (ã‚»ãƒ«ã«å€¤ã‚’è¨å®šã™ã‚‹ãƒ¡ã‚½ãƒƒãƒ‰ã¾ã§ã¯å…¨ã¦ã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã«å¯¾ã—ã¦å®Ÿè£…ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã§ã™ãŒ) xlsxãªãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ‰±ã†å¿…è¦ãŒã‚ã£ã¦ã€è‡ªå‰ã§ãªã‚“ã¨ã§ã‚‚ãªã‚Šãã†ã ã£ãŸã‘ã©ã€æ—¢å˜ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’è¦‹ä»˜ã‘ãŸã®ã§ãƒ¡ãƒ¢ã€‚ ã¡ãªã¿ã«xlsã‚‚å¯¾å¿œã—ã¦ã„ã‚‹ã“ã¨ã«ãªã£ã¦ã„ã¾ã™ãŒã€Spreadsheetã«ä¸¸æŠ•ã’ãªã®ã§ã€ xlsã ã‘ã®å¯¾å¿œã§è‰¯ã„å ´åˆã¯ã€Spreadsheetã‚’ç›´æŽ¥åˆ©ç”¨ã™ã‚‹ã¹ãã ã¨æ€ã„ã¾ã™ã€‚ (Spreadsheetæ–¹ãŒé«˜æ©Ÿèƒ½ã§ã€å®Ÿè£…ã®ç‹ã‚‚è‰¯ã„) ã¾ãŸ
patorash 2013/02/13
spreadsheet

Ruby

gem

Excel

roo
ãƒªãƒ³ã‚¯
ruby ã§Excelã€€ã‚’èªã¿æ›¸ã
ã“ã¡ã‚‰ã§ã‚‚è¨˜è¼‰ã—ã¦ã„ã¾ã™ã€‚ â—Excelã‹ã‚‰èªã¿è¾¼ã‚€å ´åˆã®ã‚µãƒ³ãƒ—ãƒ«ï¼‘ require 'rubygems' require 'spreadsheet' xls = Spreadsheet.open('tests.xls', 'rb') #Excelãƒ•ã‚¡ã‚¤ãƒ«ã®èªã¿è¾¼ã¿ sheet = xls.worksheet(0) #0ç•ªç›®ã¤ã¾ã‚Š1ç•ªå§‹ã‚ã®sheetã‚’èªã¿è¾¼ã‚€ #èªã¿è¾¼ã¿ã®é–‹å§‹ãŒ'ï¼'ã‹ã‚‰å§‹ã¾ã‚‹ã€‚ print sheet[0,1] #å®Ÿéš›ã®Excelã§ã¯ã€1è¡Œç›®ã®2åˆ—ç›®ã®å€¤ã‚’èªã¿è¾¼ã¿ print "\n" #è¡Œå˜ä½ã§èªã¿è¾¼ã‚€äº‹ã‚‚å‡ºæ¥ã¾ã™ã€‚ row = sheet.row(2) #3è¡Œç›®ã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿è¾¼ã¿ print row[2] #3è¡Œç›®ã®3åˆ—ç›®ã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿è¾¼ã¿ print "\n" â—Excelã‹ã‚‰èªã¿è¾¼ã‚€å ´åˆã®ã‚µãƒ³ãƒ—ãƒ«ï¼’ require 'rubygems' require 'par
patorash 2013/02/13
axlsxã§ã¯èªã¿è¾¼ã¿ã§ããªã„ã®ã‹ãªãƒ¼ï¼Ÿ

excel

spreadsheet

rubygems

ruby
ãƒªãƒ³ã‚¯
writeexcel/writeexcel.rdoc at master Â· cxn03651/writeexcel
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
patorash 2012/07/09
Ruby

excel

spreadsheet

ãƒ©ã‚¤ãƒ–ãƒ©ãƒª
ãƒªãƒ³ã‚¯
JExcelApi
Java Excel API - A Java API to read, write, and modify Excel spreadsheets Java Excel API is a mature, open source java API enabling developers to read, write, and modifiy Excel spreadsheets dynamically. Now java developers can read Excel spreadsheets, modify them with a convenient and simple API, and write the changes to any output stream (e.g. disk, HTTP, database, or any socket). Any operating s
patorash 2011/12/08
excel

java

development

library

ãƒ©ã‚¤ãƒ–ãƒ©ãƒª

spreadsheet

API
ãƒªãƒ³ã‚¯
spreadsheetã‚’jsonãƒ•ã‚¡ã‚¤ãƒ«ã«å¤‰æ›ã™ã‚‹ãƒ„ãƒ¼ãƒ«sheet2jsonå…¬é–‹ã—ã¾ã—ãŸã€‚ - ã—ã‹ã˜ã‚ã†ãŒãƒ—ãƒã‚°ãƒ©ãƒ ä½œã‚‹ã‚ˆï¼
æ¦‚è¦ ã“ã‚Œã¯Google Docs spreadsheetã«æ›¸ã‹ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’jsonã«å¤‰æ›ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚å…¥ã‚Œåæ§‹é€ ã‚‚å†ç¾ã§ãã¾ã™ã€‚ ã©ã‚“ãªæ™‚ã¤ã‹ã†ã®ï¼Ÿ é–‹ç™ºæ™‚ã®ãƒ†ã‚¹ãƒˆç”¨ã« webã‚¢ãƒ—ãƒªé–‹ç™ºã§ajaxå´ã¨ã‹ä½œã£ã¦ã‚‹ã‘ã©ã€ã¾ã ã‚µãƒ¼ãƒãƒ¼å´ãŒã§ãã¦ãªãã¦ã€ã§ã‚‚ã¨ã‚Šã‚ãˆãšãƒ†ã‚¹ãƒˆç”¨ã®jsonãŒæ¬²ã—ã„æ™‚ã¨ã‹ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã£ã¨ã€‚ ç›´æŽ¥jsonãƒ•ã‚¡ã‚¤ãƒ«ä½œã£ã¦ã‚‚ã„ã„ã‘ã©ã€ã‚ã‚‹ç¨‹åº¦å¤§ããªjsonãƒ•ã‚¡ã‚¤ãƒ«ã«ãªã‚‹ã¨ç®¡ç†ã‚‚å¤§å¤‰ã ã—ã€å…¥ã‚Œåæ§‹é€ ã«ãªã‚‹ã¨ã‚ã‘ã‚ã‹ã‚“ãªããªã‚‹ã—ã€jsonå¤‰æ›´ã—ãŸã‚‰å‹•ä½œãŒå¤‰ã‚ã£ãŸã¨ã‹ãªã£ãŸã‚‰ã‚ã‚“ã©ã„ã§ã™ã‚ˆãã€‚ ãŠå®¢ã•ã‚“ã«ç›´æŽ¥å…¥åŠ›ã—ã¦ã‚‚ã‚‰ãˆã‚‹ google docsãªã®ã§ã€ãŠå®¢ã•ã‚“ã‹ã‚‰ç›´æŽ¥ãƒ‡ãƒ¼ã‚¿ã‚’å…¥åŠ›ã—ã¦ã‚‚ã‚‰ãˆã¾ã™ã€‚ITã«ã†ã¨ã„ãŠå®¢ã•ã‚“ã‚‚Excelãªã‚‰ä½¿ãˆã‚‹äººã‚‚å¤šã„ã§ã™ã€‚ãã‚“ãªæ¡ˆä»¶ã®æ™‚ã«ã”ä½¿ç”¨ãã ã•ã„ã€‚ çµ„è¾¼ã¿æ–¹æ³• ãƒ„ãƒ¼ãƒ« -> ã‚¹ã‚¯ãƒªãƒ—ãƒˆ -> æŒ¿å…¥ ã§sheet2jsonã‚’æ¤œç´¢ã—ã¦ãã
patorash 2011/04/02
json

spreadsheet

JavaScript

Google
ãƒªãƒ³ã‚¯
1