how to write CSV file in rails

To write a CSV file in Rails using Ruby, you can follow these steps:

  1. First, make sure you have the CSV library included in your application by adding the following line to your Gemfile:

gem 'csv'

  1. Next, create a new file with a .csv extension where you want to store your data. For example, you can create a file called "data.csv" in the "public" folder of your Rails application.

  2. In your Rails controller or model, use the CSV library to open the file and write data to it. Here's an example:

```ruby require 'csv'

CSV.open("#{Rails.root}/public/data.csv", "w") do |csv| csv << ["Name", "Email"] # Write the header row

 users = User.all # Assuming you have a User model

 users.each do |user|
   csv << [user.name, user.email] # Write data for each user
 end

end ```

In this example, we open the "data.csv" file in write mode ("w") using the CSV.open method. We then write the header row, which contains the column names (in this case, "Name" and "Email"). Finally, we iterate over the users and write their name and email to the CSV file.

  1. Save the file and run your Rails application. The data will be written to the CSV file specified in the code.

That's it! You have successfully written a CSV file in Rails using Ruby. Remember to adjust the code according to your specific requirements and file paths.