Superfast CSV Imports Using PostgreSQL's COPY Command
Dealing with various sources of data in web applications requires us to create services that will extract information from CSV, Excel, and other file types. In that case, it’s best to use some existing libraries, or if your backend is on Rails, use gems. There are many gems with very cool features like CSVImporter and Roo. But you can also use plain Ruby CSV. Either way, if those are small CSV fil
roo
The parseexcel-gem does not support the celltype ‘percentage’ but uses ‘float’ instead. This is not a big deal as you can also use ‘float’ to do calculations with these cells. Old .sxc OpenOffice files are currently not supported – please load these files and save it as an “OpenDocument Spreadsheet (.ods)”. Instead of a filename the Google#new method needs the ‘key’ of a Google-Spreadsheet. This k
RailsでExcelを扱うGemまとめ - Qiita
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
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
処理を実行中です
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
How to efficiently process large Excel files using Ruby — Infinum
