下载工作簿，而不将其保存到Rails中的磁盘rubyxl

Question

Rails 4.2
RubyXL

我正在使用RubyXL创建一个工作簿。我可以用以下方式写磁盘：

workbook.write("path/to/desired/Excel/file.xlsx")

然后用这样的方式下载：

send_file(workbook.write("path/to/desired/Excel/file.xlsx")，options = {:filename => 'myworkbook.xlsx'，:disposition =>‘附件’})

对于如何下载它，而不必先将其保存到服务器，有什么建议吗？

Answer 1

您可以直接将工作簿转换为字符串：

def get_worksheet_as_string
  workbook = RubyXL::Workbook.new
  # Fill workbook here or leave as is to download empty
  send_data workbook.stream.string, filename: "myworkbook.xlsx",
                                    disposition: 'attachment'
end

Answer 2

如果你在辛纳特拉工作：

get '/download-xlsx/?' do
    content_type 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
    attachment(filename = "filename.xlsx", disposition = :attachment)

    workbook = RubyXL::Workbook.new

    # Fill the workbook with data

    workbook.stream
end

我想这对那些在辛纳特拉工作的人可能有帮助！