Rails-使用axlsx gem将记录导出到可下载的excel文件（Keep MVC）

Dinesh Saini 发表于 Dev

迪内什·塞尼（Dinesh Saini）

我已经从https://github.com/randym/axlsx成功安装了axlsx gem。这是我用来通过此gem创建excel文件的控制器代码。

但是这段代码没有任何反应，相反，它向我显示了一个未初始化的mime错误

class Coaches::PaymentsController < ApplicationController

  before_filter :authenticate_coach!

  # List all the payments
  def index
    if !params[:sort].blank?
      @payments = Payment.includes(:member).paginate(:page => params[:page], :order => sort_column + " " + sort_direction)
    else
      @payments = Payment.includes(:member).paginate(:page => params[:page], :order=>'id desc')
    end
    respond_to do |format|
      format.html
      # Change format to xlsx
      format.xlsx
      format.json { render json: @payments }
    end
  end
end

其次，我尝试使用以下代码：

wb = xlsx_package.workbook
wb.add_worksheet(name: "Buttons") do |sheet|
  @buttons.each do |button|
    sheet.add_row [button.name, button.category, button.price]
  end
end

但不幸的是，它不起作用。谁能告诉我仅暗示没有解决方案来完成我的任务？

我已经按照建议尝试了三次：

   def index
    if !params[:sort].blank?
      @payments = Payment.includes(:member).paginate(:page => params[:page], :order => sort_column + " " + sort_direction)
    else
      @payments = Payment.includes(:member).paginate(:page => params[:page], :order=>'id desc')
    end
    respond_to do |format|
      format.xlsx do
        p = Axlsx::Package.new
        wb = p.workbook
        wb.add_worksheet(name: "Your worksheet name") do |sheet|
          sheet.add_row ["First Column", "Second", "Third"]
          sheet.add_row [1, 2, 3]
          sheet.add_row [' preserving whitespace']
        end
        send_data p.to_stream.read, type: "application/xlsx", filename: "filename.xlsx"
      end
    end
  end

它引发了我HTTP 406错误

阿米T

尝试将axlsx_rails Gem与模板一起使用。就我而言，我使用下面的配置来使其工作。以及扩展名为.xlsx的链接，以xlsx格式呈现。

宝石文件

gem 'axlsx', '~> 2.0'
gem "axlsx_rails"

控制器文件-payments_controller.rb

def download
    @payments = Payment.all
    respond_to do |format| 
       format.xlsx {render xlsx: 'download',filename: "payments.xlsx"}
    end
end

查看文件-download.xlsx.axlsx

wb = xlsx_package.workbook
wb.add_worksheet(name: "Payments") do |sheet|
    sheet.add_row ["ID", "Notes","Amount($)","Deposit Date"]
    @payments.each do |payment|
        sheet.add_row [payment.id, payment.notes,payment.amount,payment.date_deposite]
    end
end

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。