How to generate an application/excel type download?

Add the following to initializers/mimetypes.rb:

Mime::Type.register "application/vnd.ms-excel", :xls
Then in your show method:

def show
    respond_to do |format|
       format.html { # render normal show here }
       format.xls { # render excel file here }
    end
end

Best regards

Peter De Berdt

Thanks for your quick reply.

For a quick test, I entered http://localhost:3000/data/5.xls into the
browser.

The response is: "Template is missing"

The code fragment in show is:

    respond_to do |format|
      format.html # show.html.erb
      format.xls { render :to_excel_2003 => @data }
    end

and to_excel_2003 only contains a debugger call, which is never reached.

Two more questions:
How to overcome the "Template is missing" - an .erb-file doesn't make
sense here.
How to build the link_to to generate a link to the .xls-file?

Fritz Trapper wrote:

The code fragment in show is:

    respond_to do |format|
      format.html # show.html.erb
      format.xls { render :to_excel_2003 => @data }
    end

OK, that's nonsense. should be:

Thanks for your quick reply.

For a quick test, I entered http://localhost:3000/data/5.xls into the
browser.

The response is: “Template is missing”

The code fragment in show is:

respond_to do |format|
format.html # show.html.erb
format.xls { render :to_excel_2003 => @data }
end

and to_excel_2003 only contains a debugger call, which is never reached.

Two more questions:
How to overcome the “Template is missing” - an .erb-file doesn’t make
sense here.

Use a valid render command. And to send the file:

http://api.rubyonrails.org/classes/ActionController/Streaming.html

How to build the link_to to generate a link to the .xls-file?

Just like you would generate a normal link, but with :format => xls as an extra parameter.

Best regards

Peter De Berdt

This is just as wrong, you just need to serve up data using what’s available in Rails. Anyway, send_data is the thing you want.

Best regards

Peter De Berdt

Peter De Berdt wrote:

This is just as wrong, you just need to serve up data using what's
available in Rails. Anyway, send_data is the thing you want.

There is an example in responde_to:

  def index
    @people = Person.find(:all)

    respond_to do |format|
      format.html
      format.xml { render :xml => @people.to_xml }
    end
  end

For me, to_xml looks like method of the class of @people. Right?

My data is in @data, which needs to be rendered into the excel xml
format using a template consisting of xml fragments and variables, that
will be expanded using the content of @data.

send_data will be the very last step.

The point is, that the excel file doesn't exist and should be created on
the fly.

This is just as wrong, you just need to serve up data using what’s
available in Rails. Anyway, send_data is the thing you want.
Peter De Berdt wrote:

There is an example in responde_to:

def index
@people = Person.find(:all)

respond_to do |format|
format.html
format.xml { render :xml => @people.to_xml }
end
end

For me, to_xml looks like method of the class of @people. Right?

Well, it’s actually a method from Enumerable or Array which renders it to an XML format according to Rails specifications. That doesn’t mean Excel will be able to read it (and it won’t, I can tell you right now).

My data is in @data, which needs to be rendered into the excel xml
format using a template consisting of xml fragments and variables, that
will be expanded using the content of @data.

send_data will be the very last step.

The point is, that the excel file doesn’t exist and should be created on
the fly.

Uhu, and your point is?

You have three options:

  • Make a template in excel with some variables (I would recommend using something like liquid instead of erb) and run them through the template parser of your choice

  • Generate an excel file using one of the gems you find when googling “ruby excel”, your mileage may vary on those

  • Generate an excel file using your own code based on the public spec available from Mickeysoft

Best regards

Peter De Berdt

Peter De Berdt wrote:

     format.html
     format.xml { render :xml => @people.to_xml }
   end
end

For me, to_xml looks like method of the class of @people. Right?

Well, it's actually a method from Enumerable or Array which renders it
to an XML format according to Rails specifications. That doesn't mean
Excel will be able to read it (and it won't, I can tell you right now).

It's really a member function of

class data < ActiveRecord::Base
  def to_excel_2003
    debugger
  end
end

and gets called from format.xls { render :xls => @data.to_excel_2003 }

My problem now is to find a trick to redirect back to show after
downloading the file.

As a result, the client should ge a download dialog to store the file.

You have three options:
- Make a template in excel with some variables (I would recommend
using something like liquid instead of erb) and run them through the
template parser of your choice
- Generate an excel file using one of the gems you find when googling
"ruby excel", your mileage may vary on those

This is too much efford. I developed the xml-solution for javascript and
it works very well.

To design and format such a sheet, simply use excel or OpenOffice and
export it as excel 2003 format, then take a xml editor like XML Copy
Editor, pretty print it and extract varable blocks to xml fragments and
set variables instead.

This is something like a template and my to_excel_2003 should act as a
template parser. Any idea, how to do this?

- Generate an excel file using your own code based on the public spec
available from Mickeysoft

This is even more efford...

Instead of render :xls, use send_data with the correct options to serve the file with disposition attachment (see the docs), this will bring up the dialog box right away and you never have to redirect to show, since a file download doesn’t do a page refresh.

You’ll need to implement the to_excel_2003 method to return a string at the end that will constitute the contents of the file. It’s up to you to figure out which method of actually generating the string fits your project best and implement it.

Best regards

Peter De Berdt

Similar to what Peter is pointing out, I use a similar construct to
generate and send a pdf to the user off a link on the 'show' form...

def pdf
  if @project = Project.find(params[:id])
    filename =
@project.name+"-"+Time.now.strftime("%Y-%m-%d-%H%M")+".pdf"
    filename = filename.gsub(" ","_")
    send_data @project.as_pdf(params[:detail_level]), :filename =>
filename, :type => "application/pdf"
  end
end

Where I use @project.as_pdf, you might have @data.to_excel_2003 to
create your file, and you'll need a different :type on your send_data
call.

i have installed
ruby 1.8.6 window version,
rails 2.0.2

everything runs fine except SCAFFOLD
when i run
ruby script/generate scaffold modelname controllername actions
e,g. C:depot>ruby script/generate scaffold Album albums
           it gives following error
"WRONG NUMBER OF ARGUMENTS (1 FOR 2)"
i tried with many dummyprojects and tutorial,
BUT if i run
   ruby script/generate scaffold modelname
e.g ruby script/generate scaffold Album
IT'S RUN FINE
SEE THE FOLLOWING

C:\InstantRails-2.0-win_2\rails_apps\music_library_development>ruby
script/generate scaffold Album albums
      exists app/models/
      exists app/controllers/
      exists app/helpers/
      create app/views/products
      exists app/views/layouts/
      exists test/functional/
      exists test/unit/
      create app/views/products/index.html.erb
wrong number of arguments (1 for 2)

C:\InstantRails-2.0-win_2\rails_apps\music_library_development>ruby
script/generate scaffold Album
      exists app/models/
      exists app/controllers/
      exists app/helpers/
      exists app/views/albums
      exists app/views/layouts/
      exists test/functional/
      exists test/unit/
      create app/views/products/index.html.erb
      create app/views/products/show.html.erb
      create app/views/products/new.html.erb
      create app/views/products/edit.html.erb
      create app/views/layouts/albums.html.erb
      create public/stylesheets/scaffold.css
  dependency model
      exists app/models/
      exists test/unit/
      exists test/fixtures/
      create app/models/album.rb
      create test/unit/album_test.rb
      create test/fixtures/albums.yml
      create db/migrate
      create db/migrate/20080628070012_create_albums.rb
      create app/controllers/albums_controller.rb
      create test/functional/albums_controller_test.rb
      create app/helpers/albums_helper.rb
       route map.resources :albums

C:\InstantRails-2.0-win_2\rails_apps\music_library_development>

BUT RESULTS ARE A BIT DIFFERENT ,
i am looking for Modelname "album", Controllername " albums "
and Actions "show.rhtml, new.rhml, edit.rhtml,_form.rhtml"

BUT RESULTS ARE
Modelname " album" , Controllername " albums",and Actions
"show.html.erb,new.html.erb,edit.html.erb,index.html.erb"

PLZ HELP ME WHAT'S GOING WRONG
Thanks

Pravin Mishra
Pravinmishra88@gmail.com

Ar Chron wrote:

Similar to what Peter is pointing out, I use a similar construct to
generate and send a pdf to the user off a link on the 'show' form...

def pdf
  if @project = Project.find(params[:id])
    filename =
@project.name+"-"+Time.now.strftime("%Y-%m-%d-%H%M")+".pdf"
    filename = filename.gsub(" ","_")
    send_data @project.as_pdf(params[:detail_level]), :filename =>
filename, :type => "application/pdf"
  end
end

Where I use @project.as_pdf, you might have @data.to_excel_2003 to
create your file, and you'll need a different :type on your send_data
call.

Thanks for your reply. I'm about to solve it. Downloading a file works,
now I have to render the xml string.