CODEWITHSUNDEEP
ruby-on-railsruby-on-rails-3rubygemsruby-on-rails-plugins
Aadi
Aadi

Reputation: 295

generating excel in rails

I am trying to create an excel sheet in ruby on rails. So I used the plugin Rexcel. When I am running the application I am getting the following error.

uninitialized constant Rexcel::Workbook::Builder

I had added the following code, then this error hitting

workbook = Rexcel::Workbook.new

worksheet = workbook.add_worksheet("Customers")

worksheet.add_line("name","test")

headers['Content-Type'] = "application/vnd.ms-excel"

headers['Content-Disposition'] = 'attachment; filename="excel-export.xlsx"'
headers['Cache-Control'] = 'max-age=0'
headers['pragma']="public"
workbook.build

How to solve this?

Upvotes: 3

Views: 6455

Answers (2)

oma
oma

Reputation: 40840

+1 to tommasop

I'd like to add. If you, like me, you consider this as presenting data, just like xml, html or json, you don't want to write to disc. Heroku is read-only if you're considering using that.

I would change the book.write '/somepath..' to

def xls
  .. your stuff .. 
  blob = StringIO.new("")
  book.write blob
  blob.string
end

then, in the controller do 

send_data @customer.xls, :type => :xls, :filename => @customer.xls_file_name

remember to add the mime type in your initializer NOTE, I just realized that these examples are from my rails 2.3.10 app. Maybe it differs in rails 3.

Mime::Type.register "application/vnd.ms-excel", :xls

Upvotes: 5

tommasop
tommasop

Reputation: 18765

I would advice to use Spreadsheet instead of Rexcel because is definitely more mature and I'm using it with Rails 3 with no problems.

Here is the documentation.

The overall process would be:

book = Spreadsheet::Workbook.new
sheet = book.create_worksheet :name => 'Customers'
sheet.row(0).concat %w{Name Country Acknowlegement}
book.write '/path/to/output/excel-file.xls'

Upvotes: 8

Related Questions