Invalid byte sequence in UTF-8 when generating spreadsheet about caxlsx_rails HOT 10 CLOSED

@straydogstudio I figured it out!!

xlsx = (render_to_string handlers: [:axlsx], formats: [:xlsx],
    template: "report", layout: false)
attachments["#{subject}.xlsx"] = { mime_type: Mime::XLSX, content: xlsx }

  mail(
      to: [email protected],
      from: "[email protected]",
      subject: subject,
      template_path: 'mailer',
      template_name: "report"
    )

The template in the xlsx block report can't have the same name as the html template. So I had to rename it to

xlsx = (render_to_string handlers: [:axlsx], formats: [:xlsx],
    template: "xls_report", layout: false)
attachments["#{subject}.xlsx"] = { mime_type: Mime::XLSX, content: xlsx }

It was always breaking on mail( ....), so I was thinking it might be getting the template names confused even when I wasn't attaching the xlsx file, so there it is 😄

from caxlsx_rails.

@straydogstudio any updates?

from caxlsx_rails.

Sorry @samuelshih I haven't been able to get to it. One way you could help is to create a simple Rails repo in Github that demonstrates the issue. Then I won't have to set that up, and it will make sure I have the setup you do (with the entire Gemfile.) Would you be willing to do that?

from caxlsx_rails.

Fantastic! That's great. I think I may know what that means then, but I'll have to check on that. Nice to have a simple solution!

from caxlsx_rails.

I'm going to leave this open as a reminder to look into this.

from caxlsx_rails.

Hey @straydogstudio , I also faced the same problem. It looks like rails are trying to surround the xlsx file with layouts:

To fix this problem I have to either rename the axlsx template or by passing render layout: false, so my controller action looks like this:

respond_to do |format|
  format.html
  format.xlsx { render layout: false } # avoid surrounding xml with layout
end

I prefer the later one.

from caxlsx_rails.

@kikihakiem Thanks for the update. The format.xls really shouldn't come into play, as I don't register anything under that MIME type. But that is interesting.

What Rails / Axlsx / axlsx_rails versions do you have?

from caxlsx_rails.

Rails 4.2.4, axlsx 2.0.1, axlsx_rails 0.4.0
I'm using stdlib for format.xls. However I got the same issue when generating xls file and the solution is also same, so I think it's rails issue.

from caxlsx_rails.

I have not been able to reproduce this bug. But, based on the experience of others (here and in other issues) the latest release of axlsx_rails (0.5.0) explicitly sets layout to false. Advising others to set the layout to false appears to fix these issues. I am cautiously optimistic. Please try 0.5.0 and comment on this issue (or open another) if the failure happens again.

from caxlsx_rails.

ref #29 (dupe)

from caxlsx_rails.