spreadsheet zdavatz/spreadsheet TheRubyToolboxによると、一番多く使われているらしい .xlsx, .xlsmは扱えない 新規作成、読み込み、書き出しが可能 セルの書式設定は面倒そう # 新規作成 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
![RailsでExcelを扱うGemまとめ - Qiita](https://cdn-ak-scissors.b.st-hatena.com/image/square/0d61f83d00bb6890edba673726772c337948b908/height=288;version=1;width=512/https%3A%2F%2Fqiita-user-contents.imgix.net%2Fhttps%253A%252F%252Fcdn.qiita.com%252Fassets%252Fpublic%252Farticle-ogp-background-9f5428127621718a910c8b63951390ad.png%3Fixlib%3Drb-4.0.0%26w%3D1200%26mark64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTkxNiZoPTMzNiZ0eHQ9UmFpbHMlRTMlODElQTdFeGNlbCVFMyU4MiU5MiVFNiU4OSVCMSVFMyU4MSU4NkdlbSVFMyU4MSVCRSVFMyU4MSVBOCVFMyU4MiU4MSZ0eHQtY29sb3I9JTIzMjEyMTIxJnR4dC1mb250PUhpcmFnaW5vJTIwU2FucyUyMFc2JnR4dC1zaXplPTU2JnR4dC1jbGlwPWVsbGlwc2lzJnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnM9NGM0ZWEyZDM3OWIyOGU1YTVhYzUzN2U4MzYxOWUzZTQ%26mark-x%3D142%26mark-y%3D112%26blend64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTYxNiZ0eHQ9JTQwS3RhLU0mdHh0LWNvbG9yPSUyMzIxMjEyMSZ0eHQtZm9udD1IaXJhZ2lubyUyMFNhbnMlMjBXNiZ0eHQtc2l6ZT0zNiZ0eHQtYWxpZ249bGVmdCUyQ3RvcCZzPThkZjhkNGZhMWFjOTY0ZTg0MDQ2MjE0YTAxYzAwYWRm%26blend-x%3D142%26blend-y%3D491%26blend-mode%3Dnormal%26s%3D020c3ef198a1f28ed987545ac74139c7)