从excel读数据到数据库表中

来源：互联网发布：天刀唐门少女捏脸数据编辑：程序博客网时间：2024/04/28 05:19

######################表结构LibTableInfo#################################
-------------------------------
column        type        name
-------------------------------
column_1    S            字段一
column_2    S            字段二
column_3    S            字段三
###################数据结构lib_table_info.xls####################################
32    323        32
32    323        32
32    323        32
##################import_excel_table.rb#####################################
# -*- coding: utf-8 -*-
require 'rubygems'
require 'activerecord'
require 'spreadsheet'

class ImportExcelTable
def self.open_xlsfile(source_name)
    path = File.join(RAILS_ROOT , 'doc/' + source_name)
    book = Spreadsheet.open(path)
    sheet1 = book.worksheet 0
    return sheet1
end

    # lib_table = "LibTableInfo"
    # source_name = "lib_table_info.xls"

def self.run_import(lib_table,source_name)
    sheet1 = open_xlsfile(source_name)
    eval(lib_table).delete_all
    sheet1.each do |row|
      @lib_table_info = eval(lib_table).new(:column_1 => row[0],:column_2 => row[1],:column_3 => row[2])
      @lib_table_info.save
    end
end
end