利用Rails控制器实现.xlsx文件在SQL数据库中的存储

gem 'roo'
gem 'axlsx'

class ExcelFilesController < ApplicationController
  def upload
    file = params[:file]
    spreadsheet = Roo::Spreadsheet.open(file.path)
    header = spreadsheet.row(1)
    data = []
    (2..spreadsheet.last_row).each do |i|
      row = Hash[[header, spreadsheet.row(i)].transpose]
      data << row
    end
    ExcelFile.create(data: data.to_json)
    redirect_to root_path, notice: 'Excel file uploaded successfully.'
  end
end

Rails.application.routes.draw do
  # ...
  resources :excel_files, only: [:upload]
  # ...
end

class ExcelFile < ApplicationRecord
  serialize :data, JSON
end

<%= form_with(url: excel_files_upload_path, local: true, multipart: true) do |form| %>
  <%= form.file_field :file %>
  <%= form.submit 'Upload' %>
<% end %>