CODEWITHSUNDEEP
rubyruby-on-rails-3spreadsheetexport-to-excel
Yuval Karmi
Yuval Karmi

Reputation: 26713

How to generate an Excel file with Rails?

I was searching Ruby toolbox for a popular, well-supported tool to generate XSLX (Excel 2007 and on) document, but I didn't manage to find anything. I also spent a good amount of time searching on Google, but most of the answers I found seem outdated.

I'll need to include inline images in the document I generate.

I'm working with Ruby 1.9.2 and Rails 3.

Any suggestions?

Thank you very much!

Upvotes: 13

Views: 39806

Answers (3)

natedavisolds
natedavisolds

Reputation: 4295

I've used the spreadsheet gem. Here is some code that I've used to write it to a file and send.

spreadsheet_name = @role.title

   book = Spreadsheet::Workbook.new 
   sheet1 = book.create_worksheet :name => spreadsheet_name

   @people.each_with_index  { |person, i| 
     sheet1.row(i).replace [person.first_name, person.last_name, person.email, person.title, person.organization, person.phone, person.street, person.street2, person.city, person.state, person.zip, person.country]
   }        

   export_file_path = [Rails.root, "public", "uploads", "exports", "#{ @team.sort_name }_#{ DateTime.now.to_s }.xls"].join("/")
   book.write export_file_path
   send_file export_file_path, :content_type => "application/vnd.ms-excel", :disposition => 'inline'

There is probably a way to do this in memory and not write a file.. but I didn't take the time to look into it.

I didn't see the inline images need, but I'll leave this because it might help someone else.

Upvotes: 10

randym
randym

Reputation: 2460

Bit late to the game, but there you go. You should use the axlsx gem

On Github: https://github.com/randym/axlsx

On Rubygems: https://rubygems.org/gems/axlsx

On Rubytookbox: https://www.ruby-toolbox.com/projects/axlsx

From the README

p = Axlsx::Package.new
p.workbook do |wb|
  wb.add_worksheet(:name => "Image with Hyperlink") do |sheet|
    img = File.expand_path('../image1.jpeg', __FILE__)
    sheet.add_image(:image_src => img, :noSelect => true, :noMove => true,  :hyperlink=>"http://axlsx.blogspot.com") do |image|
      image.width=720
      image.height=666
      image.hyperlink.tooltip = "Labeled Link"
      image.start_at 2, 2
    end
  end
end

Upvotes: 40

fl00r
fl00r

Reputation: 83680

You can try this gem

https://github.com/harvesthq/simple_xlsx_writer

And

https://github.com/cxn03651/writeexcel/

Upvotes: 1

Related Questions