felixbuenemann
commented
6 years ago You need to tell the controller, that it should send the file, eg.:
# after closing the xlsx
send_file "#{current_user.callsign}.xlsx",
type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"However it's better to write the file to a Tempfile (if it is large) or a StringIO if it is small.
If you always write to the same file, you risk file corruption if the action is called in parallel by users with the same callsign. You would also have to remove the file manually, while the Tempfile is automatically deleted after the action finishes.
Example with Tempfile:
Tempfile.open do |io|
xlsx = Xlsxtream::Workbook.new(io)
# write worksheet …
xlsx.close
send_file io.path,
filename: "#{current_user.callsign}.xlsx",
type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
endExample with StringIO:
io = StringIO.new
xlsx = Xlsxtream::Workbook.new(io)
# write worksheet …
xlsx.close
send_data io.string,
filename: "#{current_user.callsign}.xlsx",
type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
zmd94
Hi, I want to ask how to configure xlsxtream properly so that user can download the .xlsx file.
Firstly, what I have done is create code as below to link to export path:
Above code is located in my index.html.erb file.
Then, below is the code in my dashboard_controller.erb file for the export function:
Yet, when I click the "Export All" button, it return below errors:
However, although there is errors, the .xlsx file still being successfully created. Yet it is in local directory. Why?