simple-excel-import
Target
Get data from excel file and save into database model
Support
-
xls, xlsx format, Microsoft Office 1997 - 2003
-
sxc format, Libre Office
Install
include in Gemfile:
gem 'simple-excel-import'How to use
in a model
class Book < ActiveRecord::Base
simple_excel_import :common, :fields => [:title, :price, :kind]
simple_excel_import :program, :fields => [:title, :price, :url],
:default => {
:kind => '编程'
}
endthen, you can call Model.parse_excel_xxx
# parse excel file without saving
Book.parse_excel_common(excel_file)
# -> return a array of <#Book> with fields title, price, kind filled
Book.parse_excel_program(excel_file)
# -> return a array of <#Book> with fields title, price, url filled, and kind of default value '编程'you can call Model.import_excel_xxx to save models into database
Book.import_excel_common(excel_file)
Book.import_excel_program(excel_file)TODO
-
support nil field in field list :fields => [:tid, nil, :gender, :nation]
-
more format files, etc, ods, good doc..