#362 Exporting CSV and Excel

Jul 02, 2012 | 6 minutes | Views

As you will see it is easy to add a CSV export option to Rails. Here I also show how to export for Excel in a variety of formats.

Click to Play Video ▶

Download:
source codeProject Files in Zip (56.3 KB)
mp4Full Size H.264 Video (21 MB)
m4vSmaller H.264 Video (8.94 MB)
webmFull Size VP8 Video (9.65 MB)
ogvFull Size Theora Video (22.1 MB)

Yannick Schutz almost 6 years ago

Thanks a lot!
For a pro episode about XLS you can maybe try https://github.com/randym/axlsx
Really useful for advanced excel usage.

Ernest Shulikovski almost 6 years ago

Randy Morgan almost 6 years ago

acts_as_xlsx is also a very quick way to get up and running with rails.

grab me on #axlsx if you have any questions.

Yannick Schutz almost 6 years ago

Thanks Randy! You really helped us with that gem:)

Randy Morgan almost 6 years ago

Thanks Yannick. It has been a true community effort. Huge respect to the people out there who forked and added the feature they needed. I'd love to see a Pro cast showing chart generation, multiple sheets, styled and localized headers and all that jazz. For now, here is a blog post showing how easy it is.

http://axlsx.blogspot.jp/2011/12/using-actsasxlsx-to-generate-excel-data.html

Andy L almost 6 years ago

+1 for axlsx cast

vineelsonnathi over 5 years ago

Can we have subsheets under worksheet in axlsx? Let me know.

Ochko almost 6 years ago

+1 axlsx cast. It saved my time

Javi almost 6 years ago

This is great! Does anyone know about similar gems for Open Document?

Randy Morgan almost 6 years ago

This is the only one I know about - not quite as smooth of an API but if you are dealing with a fixed template it is great.
https://www.ruby-toolbox.com/projects/odf-report

Frank W almost 6 years ago

+1, we use axlsx for reporting and found it very helpful. Also Randy has been very responsive in case of questions!

Geoffroy Montel over 5 years ago

Thanks guys for AXLSX ! It perfectly suits my needs !

Mohammed Al-sheikh over 4 years ago

+1 for axlsx

Enrique García Cota almost 6 years ago

I needed a simple, straightforward way of exporting AR collections to excel, and I ended up doing the to_xls gem.

Zach almost 6 years ago

This is the to_xls gem that I'm using. It's perfect for spitting out simple arrays with limited formatting but unable to tackle anything more involved.

https://github.com/splendeo/to_xls

An example of my use:

http://stackoverflow.com/questions/11112581/calling-an-activerecord-association-method-from-an-array-in-rails-3-2

Ernest Shulikovski almost 6 years ago

Mr. Bates, thank you!
I thought that I need some heavy gem to be able to generate medium complex XLS files. I am so glad you showed me wrong, I am up and running without any additional dependency. Btw. you could post a link to that XML reference you mentioned in Show Notes:
http://msdn.microsoft.com/en-us/library/aa140066%28v=office.10%29

kobaltz almost 6 years ago

The only issue that I saw with the CSV export was that it would return all data from that table. I put it on a user list and has to make a index.csv.erb file that would post just the required data.

Not a big deal since I was able to put in whatever information I wanted.

          ruby
        
First Name,Last Name,Email Address,Status,Company,Last Login,Last IP

<% @users.each do |user| %>

<%= user.first_name %>,<%= user.last_name %>,<%= user.email %>,<%= "Active" if user.user_status %><%= "Inactive" if not user.user_status %>,<%= user.company.company_name %>,<%= time_ago_in_words(user.updated_at.localtime) %>,<%= user.ipaddress %>

<% end %>

Mohammad El-Abid almost 6 years ago

          
        
def self.generate_csv(fields, records, options = {})
  CSV.generate(options) do |csv|
    csv << fields.collect(&:humanize)
    records.each do |record|
      csv << record.attributes.values_at(*fields)
    end
  end
end

generate_csv([:id, :username], members, options[:csv])

Nathan D Acuff almost 6 years ago

While it is primarily a tool for making PDFs, you can also use DocRaptor to generate XLS, if what you need is more involved. Being able to select pdf instead of xls without too much additional effort is a nice bonus, and it is also available as a heroku addon. Yes, there is a small document fee after the first five, so clearly not suitable for everything.

Tom Zmyslo almost 6 years ago

Another useful idea for a "Pro" episode on this topic would be generating the document while using pagination for just a page of data, or after filtering results and exporting a document with just those results.

Awesome episode as always though, thanks!

a3gis almost 6 years ago

Well that's maybe a bit short for a "Pro", you just need a few lines to do that ;)

sdstoic over 5 years ago

I would like to export the filtered results, as well. What are those few lines I'd need? Appreciate the help...

Paz Aricha almost 6 years ago

How about an episode on Importing csv/xls files to your app?

murdoch almost 6 years ago

Ryan almost 6 years ago

Peter Meszaros almost 6 years ago

Synthmax almost 6 years ago

Yes ++
I need it all the time when a customer has a huge amount of legacy date in XLS format they want to move online

Muhammad Fauzi almost 6 years ago

i need it..

Misha Tatinets almost 6 years ago

I need it too

Alex Watt over 5 years ago

Percy Keeley over 5 years ago

I use the Roo gem to import data in .xls files.

See http://roo.rubyforge.org/ -and- https://github.com/hmcgowan/roo

Anthony Barone over 5 years ago

+1 Please do this Ryan... I'm a pro customer too : ).

Bob Walsh almost 6 years ago

in an index view that already does sorting and filtering, stuck on one point: creating a link_to that passes those parameters back to index.

so from http://0.0.0.0:3000/users/198/contacts?letter=C

this link_to
<%= link_to "Excel", user_contacts_path(format: 'xls') %>

passes
{"action"=>"index", "controller"=>"contacts", "user_id"=>"198"}

How do I preserve my variable number of parameters?

Erick Alvarez almost 6 years ago

You can use
<%= link_to "Excel", user_contacts_path(params.merge(format: 'xls')) %>

and this will maintain the current parameters you have plus the ones you add or edit inside merge.

memoht over 5 years ago

A bit belated, but I just implemented this feature into a new app I am working on and was looking for how to download only records in the current view or in a query. +1 for your tip above. Thank you. It works! It works!

James Jelinek over 4 years ago

I was banging my head on how to preserve my search criteria into the CSV/XLS export. This worked great! Thanks for saving me the headache. I owe you Starbucks.

Anukrity Jain 7 months ago

Hi. Does this work only for xls? I am trying to do the same thing for 'csv' but it does not seem to work. Would really appreciate some help on this.

Juergen Helmers almost 6 years ago

<%= link_to "Excel", user_contacts_path(format: 'xls'), :letter => 'c' %>

should do it...

Ray Rogers almost 6 years ago

Importing CSV files would be a great pro epsidoe also.

Anthony Barone over 5 years ago

ewige over 5 years ago

Juergen Helmers almost 6 years ago

I am using will_paginate in a search page. After restricting the number of records according to the search form fields I am calling paginate on them.

When I export to CSV I only export the current number of records on the page as defined in :per_page. How do I trick my controller to export all records when export to CSV?

Erick Alvarez almost 6 years ago

apply the pagination until the format.html inside respond_to
format.html { over here }

this way format.csv is not affected by paging

Dana almost 5 years ago

Erick, is there any way you could provide an example of your suggestion? I'm also using pagination and would like the exported files to contain only the search results. (Not just the first 25 results as defined in my controller.)

Rob Jones almost 6 years ago

Keep in mind that Excel XML output is not readable by Apple Numbers.

Numbers will display the raw XML. It will take the older 'native' Excel format.

Come on, Apple, I want to like the program but the last update was 2009...

Randy Morgan almost 6 years ago

While there are some things like graphs that do not interop very well, I have never experienced Numbers opening up an xlsx file as raw XML. Interested to hear what version of Numbers you are working with. I Currently using 1.2 (436) for confirming https://github.com/randym/axlsx interoperability with LibraOffice and Numbers

Rob Jones almost 6 years ago

Numbers '09 version 2.1 (436) ... should be the latest (did you transpose 1 and 2?)

Randy Morgan almost 6 years ago

yes, you are quite right. the version numbers where transposed. sorry about that That version supports a considerable amount of the ECMA-376 specification - also known as office open xml. what did you use to generate your data that opened raw xml? I think you'll find axlsx to actually work. we've been sucessful in interop with Numbers and LibreOffice and expect to release google docs operability this week.

Oliver Prater almost 6 years ago

We had the same error described above in a legacy App, but the cause was that the XML is sent with an extension of XLS not XLSX.

Changing the extension to .XLSX solved it for us.

Rob Jones almost 6 years ago

In general I find using a csv view template to be more useful that a to_csv method in a model.

The problem with the view template is that the file will be downloaded with the last component of the URL as the name.

For example from a Show action with a URL like /posts/2.csv you'll get a file called 2.csv, which is not very friendly

Clinton Nixon has a nice solution in this stackoverflow post

http://stackoverflow.com/questions/94502/in-rails-how-to-return-records-as-a-csv-file

He creates a render_csv method in the application controller that adds headers to the response that use either the user supplied filename or defaults to the action name

For example, this produces a file called 'myfile.csv'

          ruby
        
   respond_to do |format|
      format.html
      format.csv {
        render_csv('myfile')
      }
  end 

Ryan Johnson almost 6 years ago

Excel XML is known as SpreadsheetML

FAIR WARNING:

SpreadsheetML file sizes will be about 3-4 times larger than native XLS files. Not really a problem for small files, but with large data sets this could eat up your system resources to generate the file.
SpreadsheetML will only be readable by Microsoft Office. Other mainstream office suites will open it as an XML document.

The CSV approach fits my needs 9 times out of 10. However if you require a native Excel format, please use a gem and avoid using the SpreadsheetML method.

Zach almost 6 years ago

Excel will also always throw a "unreadable content" error when opening a SpreadsheetML file. It's just a crappy user experience all the way around; do not want.

ano1chan almost 6 years ago

+1
A painful memory while you are exporting 50K above of row in SpreadsheetML
And this occupy one of the worker while in production.
Even you finish export with SpreadsheetML, your customer may can't open it because it is too big and eat up the memory in excel.
I end up writing a rake task and put that in background with spreadsheet gem.
Smaller output and better user experience.
May be I am doing it wrong but that's my experience.

paritycube almost 4 years ago

Hi ano1chan

I am having the same Issue now , i am exporting excel files with large records , consuming my all memory, can you help ?

Kevin Chambers almost 6 years ago

I haven't used it, but this looks like a viable option for more complex needs where you really want to use a template approach:
https://github.com/dasil003/csv_builder

Johnny Shields almost 5 years ago

I followed this RailsCast tutorial, then later discovered csv_builder. Like you said, the template/view approach is much better! I think this RailsCast should be revised to use csv_builder rather than putting CSV view logic in the Controller as it recommends!

Note new repo URL: https://github.com/gtd/csv_builder

devwout almost 6 years ago

It is possible to get around the encoding issues for csv-formatted excel files: use UTF-16 little endian encoding (with a byte order mark).

          ruby
        
BOM = "\377\376"
BOM + Iconv.conv('utf-16le', 'utf8', data)

Deb almost 5 years ago

Where did you put that code?

Greg V almost 6 years ago

XML spreadsheets MUST have the .xlsx extension

digitig over 3 years ago

Maybe that's changed. In Office 2013 I can open the XML file (with a warning) if it has a .xml extension, but Excel rejects it completely if I rename it to .xlsx.

Akshay Rawat almost 6 years ago

Remember to set the Content-Disposition header for such downloads.

Cirdes almost 6 years ago

Using send_data method I can pass filename like that
format.csv { send_data @attendees.to_csv, {filename: filename}}
How can I change the default filename for xls without using send_date?

format.xls # { send_data @products.to_csv(col_sep: "\t") }

Thomas Maximini over 5 years ago

want to know that as well... did you find a solution?

oxleyj over 5 years ago

I'd like to know this as well.

Esteban Arango Medina over 5 years ago

Put it before your render ;)

          ruby
        
headers["Content-Disposition"] = "attachment; filename=\"#{filename}\"" 

Lucas Repolês about 5 years ago

Thank you very much Esteban. It was just what I was looking for.

Joshua Pinter about 3 years ago

Genius, thank you very much.

Alex Blakemore almost 6 years ago

Can anyone explain why the class method Products::to_csv is successfully getting called from the controller code below?

@products = Product.order(:name)
send_data @products.to_csv

@products is not the Products class object, but the method gets called. Then inside to_csv, it calls the all method. Does that repeat the query? or does it somehow apply all to the array @products?

To make it even more confusing, if I repeat this setup with an arbitrary method name instead of to_csv inside the rails console, I get NoMethodError. What's going on?

Alexei Danchenkov over 5 years ago

That is because @products.class is Array, which responds_to? :to_csv. I guess you should call to_csv or whatever method name you have as class method: send_data Products.order(:name).to_csv

Andy Weber over 5 years ago

For me Products::to_csv did not successfully get called. Instead, a comma separated list of objecs was rendered. e.g #<MyObject:0x007fb05ee9eb00>,#<MyObject:0x007fb05ee9e4e8> (which is the same output as when there is no def self.to_csv)

I was only able to use this design by changing
format.csv { send_data @products.to_csv }
to
format.csv { send_data Product.to_csv(@products) }

ruby-1.9.3-p125
Rails 3.2.8

Anthony DeFreitas over 5 years ago

I had the same issue but your change gave me the error: can't convert Array into Hash

format.csv { send_data Product.to_csv } worked for me.

bstruck over 5 years ago

Thank you, I had to do the same.

LucasCioffi about 5 years ago

I got the same "can't convert Array into Hash" error from

          products_controller.rb
        
format.csv { send_data Product.to_csv(@products) }

but it seems to work if you pass @products as a variable into the model by adding it in the parentheses and in the .each loop as I'm passing all_products in below.

          product.rb
        
def self.to_csv(all_products)
  CSV.generate do |csv|
    csv << column_names
    all_products.each do |product|
      csv << user.attributes.values_at(*column_names)
    end
  end
end

The advantage is that you can define @products in the controller in order to only get the products you want such as in this example:

          products_controller.rb
        
@products = Product.find_all_by_color("green")
respond_to do |format|
  format.csv { send_data User.to_csv(@products) }
end      

Tony almost 5 years ago

Thank you, I had run into the same issue. This fixed it.

M Rossetti over 4 years ago

thanks @lucascioffi

LucasCioffi about 4 years ago

Update: To make this work in XLS format, we need to pass in the tab character, so I modified my controller to look like this:

          ruby
        
@products = Product.find_all_by_color("green")
respond_to do |format|
  format.csv { send_data Product.to_csv({},@products) }
  format.xls { send_data Product.to_csv({col_sep: "\t"}, @products) }
end

And then this is how product.rb receives the call of .to_csv with the tab character and @products passed in as variables from the controller:

          
        
  def self.to_csv(options,products)
    CSV.generate(options) do |csv|
      csv << column_names
      products.each do |product|
        csv << product.attributes.values_at(*column_names)
      end
    end
  end

Dana almost 5 years ago

I tried following this screencast and gave up because I was running into an issue identical to what Andy Weber found.

Am currently using the following code, which does work:

format.csv { render :text => Product.to_csv }

Mike O'Dell almost 5 years ago

I ran into the exact same issue. Thanks for sharing, really helped me out.

sergeyki over 5 years ago

I think you define products as following:

@products = Product.all
@products.class #---> Array

but when you fetch data by calling order():

@products = Product.order(:name)
@products.class #---> ActiveRecord::Relation
in this case you do not have to call Product twice, like Product.to_csv.

Thomas Maximini over 5 years ago

Does anybody know how I can rename the .xls file when using

respond_to do |format|
format.html
format.xls
end

The file is always called as the controller actions...
thanks !

Paul Springett over 5 years ago

You might be interested in this gem I made called CSV shaper that allows you to create CSV output using a really nice Ruby DSL.

https://github.com/paulspringett/csv_shaper

minifigmaster125 over 5 years ago

I'm having a problem with the xls.erb file. HTML or XML, when I open it in excel, the file isn't being parsed. I just see all the code, line by line, the way it is in the erb file. However, any of the erb lines, like <% if ... %> statements are correctly interpreted.

I've done the mime type in the initializer as well.

Any help?

vineelsonnathi over 5 years ago

How to use subsheets in a worksheet. Any idea?

Thanks

Ace Suares over 5 years ago

Great!

Thomas Klemm over 5 years ago

Knight's Spreadsheets (Ruby) section compiles a list of gems that can help with parsing and writing Spreadsheets and CSV. Knight.io is a gem wiki for developers, a current project of mine.

TEE JIA HEN over 5 years ago

not working after joins

viniciusgati over 5 years ago

is there a way to insert images on the "non dependency way" to export xls with html in the file?

my images dont work fine, i think i can't do this by this way.

cao7113 over 5 years ago

Wonderful cast! I used roo to import some legency-excel data. Exporting excel is useful in rails application.

Thanks a lot!

Patrick Espake over 5 years ago

Not working with Office in Windows and Google Docs.
Office in Windows and Google Docs don't show de spreadsheet (corrupted file) :(

Confiz about 5 years ago

Same for me. File is corrupted. "General input/output" error.
I am using liber-office on Debian Ubuntu 12.04. Dont know why its corrupted.

Morgan J Lopes about 5 years ago

I am not sure why this is happening but .xls is showing up in the browser window and not downloading.

Matt Slay about 5 years ago

Here's another nice gem that can handle exporting data to CSV, Excel, JSON, and HTML:

Dossier

https://github.com/adamhunter/dossier

Chip about 5 years ago

Is there a way to follow this same direction for a partial? My view starts with a form that passes params back to the same URI which formats a partial. I'm struggling to make this lesson translate to my scenario. Advice? Ideas?

Chip about 5 years ago

see this SO question for details on my problem: http://stackoverflow.com/questions/15121588/rails-3-export-csv-from-partial

Confiz about 5 years ago

File is corrupted. "General input/output" error.
I am using liber-office on Debian Ubuntu 12.04. Dont know why its corrupted.

umdstu about 5 years ago

For CSV files, I was able to set the send_data type param as "text/csv". For the XLS xlm schema approach, are you all getting the file downloaded to have the .xls extension? My filename is just the name of the view, without extension.

Thanks

Jun Lin almost 5 years ago

JavaScript way, for table:

http://datatables.net/extras/tabletools/

Al almost 5 years ago

Followed the cast and for some reason when it exports CSV file, i get all records in one row and each cell is #User:0x007fb87415c460 and etc...any idea what could be causing this?

Dana almost 5 years ago

Might want to try something like this, Al. (Stolen from a post above.)

format.csv { render :text => Product.to_csv }

Sandeep Kumar almost 5 years ago

Can anyone tell how to export 100,000 records of data to csv in seconds.

Thanks in advance.

Skully almost 5 years ago

Anyone know how to solve encoding issues with xls files generated by the simple "html" definition of a table described in the cast?

I have problems on import in LibreOffice, MS Office with special characters and umlauts (§, ö etc.).

brunocalado almost 5 years ago

Use
csv << product.attributes.values

instead of:
csv << product.attributes.values_at(*column_names)

Edwin almost 5 years ago

Anyone know how I can do a spec test about a csv export? Thanks

jaywengrow almost 5 years ago

Is anyone else getting the message (when opening up in Windows Excel): 'The file you are trying to open, .... , is in a different format than specified by the file extension. etc..' ? I don't get this when using Mac Excel (2011), but it seems to be an issue with Windows Excel (2010). Any workarounds?

David Acevedo over 4 years ago

I'm having the same issue with Windows Excel (2007) the file opens correctly just throws that error every time.

matt-stringer over 4 years ago

I have a document that has spanish characters, accents and ñ. Is there way ensure that these are exported correctly? Or better put, how can I change the encoding to 'Latin-1'?

Piyush Gupta over 4 years ago

I am pasting my code here, it does the following
- downloads the file, not only make it in file system
- libre complaint, also windows, and browser

Even though I dont like to write and delete , but with spreadsheet seems like the only solution.

          ruby
        
puts "# write the file
    
book.write "Employee_History_#{ params[:id]}.xls"
    
# send the file
    
send_file "Employee_History_#{ params[:id]}.xls", :type => "application/vnd.ms-excel", :filename => "data.xls", :stream => false
    
# and then delete the file
    
File.delete("Employee_History_#{ params[:id]}.xls")"

Piyush Gupta over 4 years ago

I am pasting my code here, it does the following
- downloads the file, not only make it in file system
- libre complaint, also windows, and browser

Even though I dont like to write and delete , but with spreadsheet seems like the only solution.

          ruby
        
puts "# write the file
    
book.write "Employee_History_#{ params[:id]}.xls"
    
# send the file
    
send_file "Employee_History_#{ params[:id]}.xls", :type => "application/vnd.ms-excel", :filename => "data.xls", :stream => false
    
# and then delete the file
    
File.delete("Employee_History_#{ params[:id]}.xls")"

Greg Blass over 4 years ago

Has anyone figured out how to insert a new line in a cell using the Microsoft XML approach?

Greg Blass almost 4 years ago

The answer is:

.join("").html_safe

christina2013 over 4 years ago

Hi,
How can I format the index.xls.erb so that the xls which is exported has columns with different width and :word-wrap: normal ?
Thanks,
christina2013

Luis Bivar Ramos over 4 years ago

Does anyone know how to add totals with this approach?

srinu4122 about 4 years ago

Hello,
I had an application with rails 4 & rubyzip gem installed.
I have 3 tables - students, exams & results.

I followed this video http://railscasts.com/episodes/362-exporting-csv-and-excel

I'm able to download individual table csv files but not all 3 at a single click.

And I want to download all these 3 table csv files as a zip file with rubyzip or something else.

Please help me. I searched every end of google but didn't find an accurate result.

newextasy almost 4 years ago

Please, help srinu4122. I have same question)

mbratch almost 4 years ago

I am running Excel 2007 and the XLS/XML format described in this Railscast doesn't work. I copied it over carefully. Excel 2007 just says that there's something wrong with the "Table" format but doesn't tell me what. It says to see a log file in a long path name it gives me for the details, but that path doesn't even exist (thanks Microsoft). Has anyone gotten an XLS format to work on Windows?

mbratch almost 4 years ago

Oh nvm, operator error on my part. I actually does work, but does show a warning message up front.

Synthmax over 3 years ago

I'm having a problem with many browsers opening the file instead of downloading it.

The best solution so far has been to use send_data and set ' disposition: "attachment; filename=A_COOL_TITLE" instead

          ruby
        
respond_to do |format|
      format.html
      format.csv { 
        send_data(
          @products.to_csv, 
          disposition: "attachment; filename=A_COOL_TITLE",
          type: 'text/csv',
          stream: 'true', 
          buffer_size: '4096' 
        )

      }
end

I also found that turbo-link can cause issues so I added 'data-no-turbolink' => true to the download link

Ben Hughes over 3 years ago

This doesn't seem to work at all - file download or not. No matter what I do - even with the most basic example 100% identical to the shown source code - I get a "can’t be opened" error with Numbers (have not tried with windows). Just going to have to find a different solution entirely.

R|S|L about 3 years ago

For those who have need PDFtoXLS...

https://github.com/Ricardosluiz/Ruby_on_Rails-PDFtoXLS

wingleungchoi about 3 years ago

The XML Spreadsheet does not work. :(
My OS X 10.02 and Numbers version: 3.5
what i can see in Numbers are the following
<?xml version="1.0"?>

Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"

xmlns:o="urn:schemas-microsoft-com:office:office"

xmlns:x="urn:schemas-microsoft-com:office:excel"

xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"

xmlns:html="">http://www.w3.org/TR/REC-html40">

Worksheet ss:Name="Sheet1">

Table>

Row>

ID

Name

Release Date

Price

/Row>
........

Sithara almost 3 years ago

What if we have something like

          
        
class CouponController < ApplicationController
  def index
    @coupons = Coupon.all.page(params[:page])
    @coupons = @coupons.for_amount(params[:amount]) if params[:amount].present?
    @coupons = PaginatingDecorator.new(@coupons)

    respond_with(@coupons) do |format|
      format.html
      format.csv { render :text => coupons_csv }
    end
  end

 private

  def coupons_csv
    column_names = %w(code name id amount expiration_date)
    CSV.generate do |csv|
      csv << column_names
      @coupons.each do |coupon|
        csv << column_names.map{ |attr| coupon.public_send(attr) }
      end
    end
  end

Here in coupons_csv I'll not receive the entire coupon list - I'll receive only the paginated set.So what would be the best way to get ALL filtered coupons into the csv and get per-page#paginated coupons in the index page?

barshn over 2 years ago

Thanks you so much,saved a lot of time for a feature I had to add.
Wondering if there is a way for generating the same .csv file so it would be saved in the rails public direcoty instead.
I have a script I wrote for that csv file
help will be much appriciated,thanks

Steven over 2 years ago

This gem may be helpful, pretty useful julia_builder

Igor Kasyanchuk over 2 years ago

You can use this gem too

if you simply need to export data as admin to excel you can use this gem https://github.com/igorkasyanchuk/rails_db to excel or csv

bparanj almost 2 years ago

This episode has been updated to Rails 5 as a blog post Exporting Records in CSV and Excel Formats in Rails 5

dericky over 1 year ago

I know this is a pretty old thread, but I had a question about updating inputted files. I'm at the point where I can get files (only working with CSV right now) to update (adding new entries and updating existing ones) but I've noticed that deleting entries from the CSV file does not delete from the database. Would I have to write code to check each entry in the database with each on in the CSV?

rainahuang 8 months ago

www.shoesmaxs.com
www.nikeyeah.com
www.lightupshoe.sale
www.nikeshoesales.com