Contents

xlsx_package.simple('Test Report') do |sheet,styles|

  sheet.workbook.package.core.created = Time.zone.local(2016, 12, 8, 15, 0)

  # add the header row.
  sheet.add_combined_row [
      [ 'Code', :bold ],
      [ 'Name', :bold ],
      [ 'Email', :bold ],
      [ 'Date of Birth', :bold ],
      [ 'Hire Date', :bold ],
      [ 'Pay Rate', :bold ],
      [ 'Hours', :bold ]
  ]

  # now the data rows.
  @data.each do |row|
    sheet.add_combined_row [
                               row.code,
                               row.name,
                               row.email,
                               [ row.date_of_birth, :date ],
                               [ row.hire_date, :date ],
                               [ row.pay_rate, :currency ],
                               [ row.hours, :integer ]
                           ]
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
barkest_core-1.5.4.0	app/views/test_report/index.xlsx.axlsx
barkest_core-1.5.3.0	app/views/test_report/index.xlsx.axlsx