Railsã§Excelを扱ã†Gemã¾ã¨ã‚ - Qiita# æ–°è¦ä½œæˆ book = Spreadsheet::Workbook.new sheet = book.create_worksheet(name: 'curry') # ã„ã‚ã„ã‚ãªæ–¹æ³•ã§ãƒ‡ãƒ¼ã‚¿ã‚’入れられる # 計算å¼ã¯å…¥åŠ›ã§ããªã„ sheet.row(0).concat %w{å“å å˜ä¾¡ æ•°é‡ è¨ˆ} sheet[1,0] = 'ã«ã‚“ã˜ã‚“' sheet[1,1] = 80 sheet[1,2] = 1 sheet[1,3] = 80 row = sheet.row(2) row.push 50 row.push 2 row.push 100 row.unshift 'ãŸã¾ããŽ' sheet.row(3).replace [ 'ã˜ã‚ƒãŒã„ã‚‚', 40, 2, 80 ] sheet.row(4).push '牛肉', 1, 200 sheet.row(4).insert 1, 200 shee
Axlsx
http://spreadsheet.rubyforge.org/
{{#tags}}- {{label}}
{{/tags}}