require 'csv'

file = "#{Rails.root}/public/company_data.csv"

companies = Company.order(:code)

column_headers = ["code", "name", "area"]

CSV.open(file, 'w', write_headers: true, headers: column_headers) do |csv|
  companies.each do |company|
    csv << [company.code, company.name, company.area ]
  end
end