ruby-on-rails – 如何在Rails中上传和解析Excel文件？

你说你使用Paperclip的附件是好的.但是,如果您在S3中存储附件(我认为使用Heroku后),则将该文件传递给电子表格的语法有所不同但并不困难.

以下是可以使用和不放置在任何类或模块中的纯语法的示例,因为我不知道您打算如何开始解析联系人.

# load the gem
require 'spreadsheet'

# In this example the model MyFile has_attached_file :attachment
@workbook = Spreadsheet.open(MyFile.first.attachment.to_file)

# Get the first worksheet in the Excel file
@worksheet = @workbook.worksheet(0)

# It can be a little tricky looping through the rows since the variable
# @worksheet.rows often seem to be empty,but this will work:
0.upto @worksheet.last_row_index do |index|
  # .row(index) will return the row which is a subclass of Array
  row = @worksheet.row(index)

  @contact = Contact.new
  #row[0] is the first cell in the current row,row[1] is the second cell,etc...
  @contact.first_name = row[0]
  @contact.last_name = row[1]

  @contact.save
end