49 lines
1.2 KiB
Ruby
49 lines
1.2 KiB
Ruby
|
=begin
|
|||
|
|
Date: 2016.12.28
|
|||
|
|
创建基于Importex::Base的类
|
|||
|
|
使用导入excel的ruby插件 importex
|
|||
|
|
gem install importex
|
|||
|
|
或者使用
|
|||
|
|
./script/plugin install git://github.com/ryanb/importex.git
|
|||
|
|
=end
|
|||
|
|
|
|||
|
|
|
|||
|
|
require 'importex'
|
|||
|
|
class Excel <Importex::Base
|
|||
|
|
column "Name",:required=> true
|
|||
|
|
column "class",:required=> true
|
|||
|
|
column "Grades",:type=> Integer
|
|||
|
|
column "Date",:type=> Date
|
|||
|
|
column "Discontinued",:type=> Boolean
|
|||
|
|
end
|
|||
|
|
|
|||
|
|
#导入excel文件
|
|||
|
|
Excel.import("course.excel")
|
|||
|
|
|
|||
|
|
#使用导入数据
|
|||
|
|
#all代表所有的数据，各个字段作为hash
|
|||
|
|
excel = Excel.all
|
|||
|
|
excel.first["Discontinued"] # => false
|
|||
|
|
|
|||
|
|
#数据验证和容错处理
|
|||
|
|
#当excel的数据格式不能处理的时候，或者数据格式不符合时
|
|||
|
|
begin
|
|||
|
|
Excel.import()
|
|||
|
|
rescue Importex::ImportError => e
|
|||
|
|
puts e.message
|
|||
|
|
end
|
|||
|
|
|
|||
|
|
|
|||
|
|
#允许导入的字段指向Ruby对象，
|
|||
|
|
# 例如，下面的例子，可以增加一个字段表示上面导入Product的类型情况
|
|||
|
|
class Category < ActiveRecord::Base
|
|||
|
|
def self.importex_value(str)
|
|||
|
|
find_by_name!(str)
|
|||
|
|
rescue ActiveRecord::RecordNotFound
|
|||
|
|
raise Importex::InvalidCell, "No category with that name."
|
|||
|
|
end
|
|||
|
|
end
|
|||
|
|
|
|||
|
|
class Product < Importex::Base
|
|||
|
|
column "Category", :type => Category
|
|||
|
|
end
|