module Reporting
Public Instance Methods
export_excel(filename)
click to toggle source
# File lib/generators/report/templates/report.rb, line 15 def export_excel(filename) start = Time.now @recon = Reporting::<%= file_name.camelize %>.details output = StringIO.new Spreadsheet.client_encoding = 'UTF-8' report = Spreadsheet::Workbook.new sheet = report.create_worksheet sheet.name = "HotelEngine <%= file_name.titleize %> Report" headers = ["Name"] num_format = Spreadsheet::Format.new(:number_format => '0') dec_format = Spreadsheet::Format.new(:number_format => '0.00') curr_format = Spreadsheet::Format.new(:number_format => '$0.00') sheet.row(0).concat headers.flatten @recon.each_with_index do |eq, index| row = sheet.row(index+1) row.push eq[:name] end final_time = Time.now - start if Rails.env != "development" http = Net::HTTP.new("api.hotelengine.com") request = Net::HTTP::Get.new("/job_timers?time=#{final_time}") response = http.request(request) end