Skip to content

Instantly share code, notes, and snippets.

@KakoozaJerry
Created December 29, 2021 15:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save KakoozaJerry/ec90d77b892d61ee3404da469d275f08 to your computer and use it in GitHub Desktop.
Save KakoozaJerry/ec90d77b892d61ee3404da469d275f08 to your computer and use it in GitHub Desktop.
to run do >>>>>> rake excel:export
namespace :excel do
desc "This task will export posts to excel sheet"
task export: :environment do
book = Spreadsheet::Workbook.new
sheet = book.create_worksheet :name => 'Jobs'
posts = Job.all
posts.each_with_index do |post, i|
sheet.row(i).push post.id, post.title, post.location, post.description
end
book.write 'Jobs.xls'
end
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment