Weird encoding rendering .xlsx.axlsx template

[mikeLspohn]

I have a worker (tried from mailer alos) that renders an .xlsx.axlsx template and writes it to a Tempfile. I'm using this in one worker and it works perfectly. In another place I'm trying to user it that uses almost the same exact code, but it doesn't render the xlsx properly, it just writes out a file with 0 bytes. If I do a puts in the terminal from render 'path/to/template.xlsx.axlsx it outputs stuff but it looks like some encoding is wrong. I can see hints of xml in the obfuscated output, but something is definitely wrong.

Here's the code

    xls = render template: 'admin/raw_salary_reports/show.xlsx.axlsx', layout: false

    file = Tempfile.new(['position-salary-report', '.xlsx'], 'tmp')

    file.write(xls)

And here's the show.xlsx.axlsx file

wb = xlsx_package.workbook

wb.add_worksheet(name: 'Position Salary Reports') do |sheet|
  sheet.add_row ['Asset Size', 'Number Receiving', '75th Percentile', 'Median', '25th Percentile', 'Average']
  sheet.add_row []
end

gem 'axlsx', '2.1.0.pre'
gem 'axlsx_rails'
rails 4.2.6

[mikeLspohn]

I'm not sure what was up, but I got it working by doing what was mentioned in #55 using the Axlsx::Package.new and the p.to_stream. I would prefer not to do it this way if anyone knows how to fix this, but it works for now 😄

[straydogstudio]

Thanks for the update @mikeLspohn. Where is the "other" location where it fails? Is it in a controller action? Rake task? Script?

[mikeLspohn]

Sorry, I never got back to you on this. It was in the context of a Resque job.