通过Spreadsheet gem直接下载xls文件，而不将其写入目录

发布于 2024-09-29 12:21:50 字数 436 浏览 8 评论 0原文

我正在使用这个 Spreadsheet gem 导出 xls 文件。

我的控制器中有以下代码：

def export
  @data = Data.all

  book = Spreadsheet::Workbook.new
  sheet = book.create_worksheet :name => "data"

  contruct_body(sheet, @data)

  book.write "data.xls"
end

这样，我可以填写数据并将其保存在根目录中。

但我想下载它而不是保存它。如何修改代码以便提示用户选择本地目录来保存文件？（如果不在服务器端保存副本更好）

请帮忙！

原文

I am using this Spreadsheet gem to export xls file.

I have the following codes in my controller:

def export
  @data = Data.all

  book = Spreadsheet::Workbook.new
  sheet = book.create_worksheet :name => "data"

  contruct_body(sheet, @data)

  book.write "data.xls"
end

In this way, I can fill in the data and save it in the root directory.

But I want to download it instead of save it. How could I modify the code so that the user prompted to select his local directory to save the file? (better if without saving a copy in the server side)

Please help!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

鹤舞 2024-10-06 12:21:51

您可以将其发送到浏览器而不将其保存为本地文件，如下所示

spreadsheet = StringIO.new 
book.write spreadsheet 
send_data spreadsheet.string, :filename => "yourfile.xls", :type =>  "application/vnd.ms-excel"

You can send it to the browser without saving it as a local file at all as follows

spreadsheet = StringIO.new 
book.write spreadsheet 
send_data spreadsheet.string, :filename => "yourfile.xls", :type =>  "application/vnd.ms-excel"

回复收藏 0 原文

静谧 2024-10-06 12:21:51

您可以尝试此代码

book.write "data.xls"

send_file "/path/to/data.xls", :type => "application/vnd.ms-excel", :filename => "data.xls", :stream => false

# and then delete the file

File.delete("path/to/data.xls")

传递 :stream =>; false 到 send_file 将指示 Rails 在流式传输之前将整个文件复制到内存中，因此在 send_file 之后立即使用 File.delete 会没问题，因为 send_file 会立即返回，而无需等待下载完成。话虽如此，对于非常大的文件，您可能会看到一些内存瓶颈，具体取决于可用内存量。

华泰

You could try this code

book.write "data.xls"

send_file "/path/to/data.xls", :type => "application/vnd.ms-excel", :filename => "data.xls", :stream => false

# and then delete the file

File.delete("path/to/data.xls")

Passing :stream => false to send_file will instruct Rails to copy the entire file into memory before streaming, so using File.delete immediately after send_file would be fine since send_file returns immediately without waiting for the download to complete. Having said that, with very large files you may see some memory bottle necks depending on the amount of memory available.

HTH

回复收藏 0 原文