Open tigershen23 opened 9 years ago
straydogstudio
commented
9 years ago @tigershen23 Try passing layout: false:
xlsx = (render_to_string handlers: [:axlsx], formats: [:xlsx], template: "report", layout: false)Let me know if that helps.
tigershen23
commented
9 years ago @straydogstudio no dice :(, same error.
straydogstudio
commented
9 years ago @tigershen23 A few people have had this error, and I've never been able to duplicate it. Is it possible for you to create a simple Rails app in a Github repo that duplicates the error? Perhaps a stripped down version of your application?
tigershen23
commented
9 years ago @straydogstudio Yeah, I'll see what I can do. Do you know of a way to force encoding on the render itself? I've found some general solutions to error in Ruby/Rails (not for axlsx_rails specifically), but it seems like the render_to_string return (I pasted an example above) is already a lost cause. Sorry, don't know much about byte encoding or else I would try to dig in more.
straydogstudio
commented
9 years ago @tigershen23 These can be hard errors to track down. Sorta vague. When I have time I will investigate forcing encoding in render to string.
There was another issue that solved this problem with their smtp_settings and ActionMailer. I've no idea what you have, but it might be worth taking a look just in case.
tigershen23
commented
9 years ago @straydogstudio yeah I saw that, I'm afraid of messing up other mailers by fiddling with those but I could try. Thanks!
straydogstudio
commented
9 years ago @tigershen23 By the way, another option instead of a github repo is to send me your Gemfile and describe your setup (including platform, versions, etc.)
straydogstudio
commented
9 years ago @tigershen23 A recent issue showed a possible solution. Make sure your template for the attachment does not have the same name as the mailer template. If you try it let me know if it works.
straydogstudio
commented
8 years ago 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.
ghost
commented
7 years ago I still have this issue
straydogstudio
commented
7 years ago First I'd double check that your sidekiq job isn't receiving parameters that are messed up when it tries to run. E.g. binary data, or something like it. Passing parameters to sidekiq isn't always straight forward.
Second, if you can create a stripped down repo with the error, that would be very helpful. I've never been able to reproduce it and have something to debug. I realize that takes time.
ghost
commented
7 years ago Actually sidekiq just receives ID and then run mailer, and the mailer service do a report render csv or xlsx. CSV is ok, xlxs not.
ghost
commented
7 years ago Found what caused problem! Problem is not with axlsx render_to_string indeed. In mailer:
file = render_to_string .... and rest of xlsx params
file = Base64.encode64(file) # this line is important
....
# attaching file to mail (encoding param is important)
attachments.inline['File.xlsx'] = { :mime_type => Mime:XLSX, :content => file, :encoding => 'base64' }
mail() ....Excellent. I'm glad to hear it. I will update the README and any examples to make sure it is clear. We will find out if that helps.
straydogstudio
commented
7 years ago I'm reopening this issue until I can test the encoding.
nachokb
commented
7 years ago I've got a similar situation. I'm using axlsx-rails with render_anywhere (it's a gem which provided the ability to use actionpack's templating functionality from wherever you need it -- I've for a "Form" model which can have different types, each with a different template).
I've triggered this bug a few times, particularly when rendering partials from within partials (though only in a small percentage of cases so I don't really know what's happening and it's very hard to debug).
2 funny things:
render template: '...', handlers: [...], formats: [...], locals: { ... }and that fails, but this one doesn't:
[1].each do
render template: '...', handlers: [...], formats: [...], locals: { ... }
endand I've got no idea WHY.
I also checked the data I'm rendering, and everything is valid UTF-8 (in fact, I tried it with different data). So I'm fairly certain that's not the problem.
[1] https://gist.github.com/nachokb/f3cc995cf44acbfd0e63ee25515f4cb8
straydogstudio
commented
7 years ago @nachokb Now that is an interesting solution. I've guessed it is a scope issue, though I've never been able to replicate the problem and test it. I agree, whatever this is, it is hard to debug. Thanks for sharing what you've found.
hcyildirim
commented
6 years ago Hi,
I am getting same error.
ruby '2.5.0'
'rails', '~> 5.2.0'
'rubyzip', '~> 1.1.0'
'axlsx', '2.1.0.pre'
'axlsx_rails'
Hi,
I reset the database, the excel file to be created is empty and I still get an error. Here is my base64 attachment.
Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Content-Transfer-Encoding: base64
Content-Disposition: inline;
filename=ExcelFile.xlsx
Content-ID: <5b97b917b3a08_94653fcfed48b794707fa@mac-name.local.mail>
UEsDBBQAAAAIAAAQIexP8WLf1wAAAEACAAALAAAAX3JlbHMvLnJlbHOtksFO
wzAMhl8l8n1NNySE0LJdJqTdECoPYBK3jdrEUWKgvD2BA2JoCA47Wvb//d/B
2/0SZvVCuXiOBtZNC4qiZefjYOCxu1vdwH63faAZpV6U0aeiaiQWA6NIutW6
2JECloYTxbrpOQeUOuZBJ7QTDqQ3bXut83cGnDJVh3kgMbDM+pXz9MQ8NRUG
qntL9J8q7ntv6cD2OVCUM40/LkAdnYF8dGvQv7g4tveZa9JypkvbBBJ0KPgJ
X6XaQ1k8lS+vzd9emNKltWgRio7cOaOrDyN98gq7d1BLAwQUAAAACAAAECHs
1SfqzcUBAAAIBQAADQAAAHhsL3N0eWxlcy54bWylVF2L3CAU/SviD6hx2i50
iIFSCBTapbD70FdnopOAH0HNkvTX96ppYqDLDm0exuuZc869Xm9S+7Ao8dQL
EdCslfEM9yGMZ0L8tRea+3d2FAb+kdZpHmDrbsSPTvDOR5FW5FRVD0TzweCm
NpNudfDoaicTGD5tEMrL145hWlUYZbsvthMML/AQrUnXYUT+KqCvCVDfn7U+
e5+UZE3f1NKavQqKMwDWXAv0whXDn93AFQaN/5UBSuNOcj2oZUUiQLIwLdF3
UOpwugg09chDEM60sEFr/LyMUKmxRgCLFIRolpY3pDfHF3r6+Jo6LVDRxbpO
uENNGULAyVGBKCEDSlfOcOjTlV2tsg6524Xhtq3Sk5sZuU3thlt/tySRmzrY
8V4FUGN5IVh9rySzi9OtATTjKpR6ii4/5eH2Z4kyJ44T2OyzlUbRbCH0dA3B
dpbwU1rmBIX3+3/znuUxycGC/r/FoQr64U0PPo5qeZz0Rbg2vWapirID2+FT
Kw693VAU3y6GH6ODKtxJ2UWw6ea9gVUc7wjA0PALfIiyfSckn1R43iCG9/i7
6IZJf8J/WD+GFxtW1h5/i6NIH/CeKR6oSAK7/dvX/AZQSwMEFAAAAAgAABAh
7JvbRkAMAQAA5QEAABEAAABkb2NQcm9wcy9jb3JlLnhtbG2RwU7DMAyGX6XK
vXWzsWlEbXYA7QQSEkUgblFiuogmjZKwlren67bSSTva/+cvjlxse9MkB/RB
t7YkNMtJgla2Stu6JG/VLt2QLS+kY7L1+OJbhz5qDMkwZgOTriT7GB0DCHKP
RoRsIOwQfrXeiDiUvgYn5LeoERZ5vgaDUSgRBRyFqZuM5KxUclK6H9+MAiUB
GzRoYwCaUfhnjY6/Dm9OXMIZHdGbcBMek4nsg56oruuybjlyw/4UPp6fXsev
ptqGKKxEwgslmfQoYuu56JvQFzDrFOeHTw1UyaBnp7Uvyfvy4bHaEb7I6SbN
71NKK7pid2tGV59H19X8eA6PB328Gc8LmJdjdX0r/gdQSwMEFAAAAAgAABAh
7MjB8ieLAAAA4QAAABAAAABkb2NQcm9wcy9hcHAueG1snY6xCsIwFEV/pWRv
Ux1ESpIu4uxQ3Uvy2gbMeyF5lvr3RgTdHS/ncjiq38K9WiFlT6jFrmlFBWjJ
eZy1uA7n+ih6oy6JIiT2kKvyx6zFwhw7KbNdIIy5KRgLmSiFkctMs6Rp8hZO
ZB8BkOW+bQ8SNgZ04Or4FYqPsVv5X6kj++7Lt+EZi88o+cs1L1BLAwQUAAAA
CAAAECHsniikzbgAAACWAQAAGgAAAHhsL19yZWxzL3dvcmtib29rLnhtbC5y
ZWxzrZDbCsIwDIZfpeTeZYqKiNUbEXYr8wFKlx3Y1pamHvb2VgVRUPDCqxCS
fN9PVptL34kTeW6skTBOUhBktC0aU0k45LvRAjbr1Z46FeIG141jEU8MS6hD
cEtE1jX1ihPryMRJaX2vQmx9hU7pVlWEkzSdo39lwDtT5MpXFCScrW+5JgqM
9zJOIhJEPjj6RWjLstG0tfrYkwkfvPgUgMgKCT4rpoBfwnAYOuJ/J3hQn/rZ
TY9vD15fAVBLAwQUAAAACAAAECHs9oueoSABAACEAwAAEwAAAFtDb250ZW50
X1R5cGVzXS54bWytk7tuwzAMRX/F0FpYSjoURWE7Qx9jmyH9AFWiYyF6QVRS
5+9L202HLHHQTARF3nOvBKha9c4WB0hogq/Zki9YAV4Fbfy2Zp+bt/KRrZpq
c4yABa16rFmXc3wSAlUHTiIPETxN2pCczNSmrYhS7eQWxP1i8SBU8Bl8LvPA
YE31Aq3c21w8T+cDumYyRmuUzJRCHLw+g5a/QJ7AjjvYmYh3tMCK154oU3qa
IhMzHM6FQ0+6D3qHZDQUa5nyu3SkEjqodQoRBen5qLsmd2hbo4AYe0cSDoOl
Bl1GQkLKBqZLXPJWIcH15qdHG9QzHXsrMB8t4L+vijGB1NgBZGf5BL3g/B3S
7iuE3a29h8qdNH6G/7iMYizLGwf5459yiPFbNT9QSwMEFAAAAAgAABAh7HsK
SNXGAAAAMgEAAA8AAAB4bC93b3JrYm9vay54bWyNj8FuwjAMhl8l8h1SEJpG
1ZYLQuIwicP2AKFxadQmruyw8fizCogrp9/2b33+Xe1ucTS/yBIo1bBaFmAw
teRDutTw831YfMKuqf6IhzPRYHQ7SQ19zlNprbQ9RidLmjCp0xFHl7Xli5WJ
0XnpEXMc7booPmx0IcGdUPI7DOq60OKe2mvElO8QxtFlzSp9mAReyU5svMu4
2habGjo3CoJtqvm+PNQkF1GfEuQvIi9g5vHR699guAxa8NFvlGpn56kKsM87
zT9QSwMEFAAAAAgAABAh7D1YYjxwAAAAigAAACMAAAB4bC93b3Jrc2hlZXRz
L19yZWxzL3NoZWV0MS54bWwucmVsc1WMSw4CIRAFr0J67zS6MMYAs/MARg/Q
wRaIwyc0MR5flrqsvHpl1k/e1Ju7pFos7BcNiouvj1SChfvtsjvB6syVNxrT
kJiaqHkpYiGO0c6I4iNnkqU2LnN51p5pTOwBG/kXBcaD1kfsvw1wBv+i7gtQ
SwMEFAAAAAgAABAh7BeHnCjrAQAAyQMAABgAAAB4bC93b3Jrc2hlZXRzL3No
ZWV0MS54bWyNU9tu2zAM/RVD74uTAt2CIE4fUmQdkC3B3AuwN8WmbaGyaEh0
vfbrR0mOmw0osDfyiNdzqPXN71YnL2CdQpOJxWwuEjAFlsrUmXi4331aipvN
ekD77BoASjjcuEw0RN0qTV3RQCvdDDsw/FKhbSWxa+vUdRZkGZJanV7N55/T
ViojYoWV/Z8aWFWqgFss+hYMxSIWtCQe1jWqc6HaynWygExwQwf2BcRmHdoe
bbJZd7KGHOihY69SdI9HBjLBa6abdTrGjQmPCgZ3YSeDMiUOR4sEBQWCOI/k
KQfNAJTBdw0OT40iyOMYI3ToSSsD+Wt7Qu0meMfr9VpGwKq64ZH2UNEU8Ass
8usiej97Dfbdw2GL+o55ZcEm9KtV5Z5bRaSESvaaPMixGJPfENu8kJrHW8y5
kdfzhPjst/wW15hCcr/+Xr5iH0j4+9Gz99HbD6+cDtiZWh90aZ/Z3QWRWZKT
dMBjPqmSmkwsp/F50zvw7PDAy6BVyLuVJM/1oh3MrdSF17fX2psHs0dZhsU5
sbPK0KELN+MvnRQPu+V7Ajsq2KBVb2joX5h55m8QparfSY634w/ru7S14qo2
TjqffbkWiY5qBvuERNiO/4qwG60K+aKsD7qObSYnnS6277wTH3ch3rN66bM7
/cvNH1BLAQI0AxQAAAAIAAAQIexP8WLf1wAAAEACAAALAAAAAAAAAAEAAACk
gQAAAABfcmVscy8ucmVsc1BLAQI0AxQAAAAIAAAQIezVJ+rNxQEAAAgFAAAN
AAAAAAAAAAEAAACkgQABAAB4bC9zdHlsZXMueG1sUEsBAjQDFAAAAAgAABAh
7JvbRkAMAQAA5QEAABEAAAAAAAAAAQAAAKSB8AIAAGRvY1Byb3BzL2NvcmUu
eG1sUEsBAjQDFAAAAAgAABAh7MjB8ieLAAAA4QAAABAAAAAAAAAAAQAAAKSB
KwQAAGRvY1Byb3BzL2FwcC54bWxQSwECNAMUAAAACAAAECHsniikzbgAAACW
AQAAGgAAAAAAAAABAAAApIHkBAAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJl
bHNQSwECNAMUAAAACAAAECHs9oueoSABAACEAwAAEwAAAAAAAAABAAAApIHU
BQAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQI0AxQAAAAIAAAQIex7CkjVxgAA
ADIBAAAPAAAAAAAAAAEAAACkgSUHAAB4bC93b3JrYm9vay54bWxQSwECNAMU
AAAACAAAECHsPVhiPHAAAACKAAAAIwAAAAAAAAABAAAApIEYCAAAeGwvd29y
a3NoZWV0cy9fcmVscy9zaGVldDEueG1sLnJlbHNQSwECNAMUAAAACAAAECHs
F4ecKOsBAADJAwAAGAAAAAAAAAABAAAApIHJCAAAeGwvd29ya3NoZWV0cy9z
aGVldDEueG1sUEsFBgAAAAAJAAkATgIAAOoKAAAAAA==And this is decoded version
PK!Ob@ _rels/.relsN0 _%}M7$в]&*`Qb=bh;ZfBxM e`à±»[~}^ѧj$HÕºØź9:A'7m{w2Uy 1<5{K*{o9P3?.@ |tkп8krKt( _CY</^Ò¥h9#}
wPK!'
xl/styles.xmlT] +q.tRÚ¥Wg AÍibm sν^oR( Ь !gBwvi `nÄNGVTUD6nuj'>m×aZUe/ /IaD* Pß>{dMÒ
3\ ÃJNr=eE"@0-wPp4CδAkPFh77z:-PźNCMBQ(!JWpÓ]Û
á¶ÒM[$:^Pcy!X}$Ó4*z.?g2'ì³Fl!t
vSZ1Å¡
M>jyE6fS+P. *IEæ½U |}'$Tx IX?V H ) HPK!F@ docProps/core.xmlmN0 _ʽuiDmvE nQb&I;/\l{$A$4IVJÛº$o.Ý-/c[>j 0f$ rFl ~Þ8'ä·¨yQ( TrR ß%4hcQgoN\ Ñp ìn9r>^ǯÚ(D %(b0O
TÉ g/&SJ+bwkFWGx} cu}+PK!'docProps/app.xml
0EdoS DJ.PK{!yF /r8½Z!eOŮiEhy(z."$Ǭ ;)] ) (LiNd m6t[_#˷(5/PK!(͸xl/_rels/workbook.xml.rels
0 _ev+J Ö VQP«|OVKßyn0NRd-SI86Õ:×cO KCpKD5Ii}Bl}NVU4e;SW$o&
2N"D>8Eh˲ѴØ
>+_p:'xPMo^_PK!ö¡ [Content_Types].xmln0 EZXJ:Ea;C c!Uc!zATRKM,qLEsZHhÙ/X^mfòjszYs|UN"<MÚÔ¦Rb T|.`M\<Of2FkÌB >@;Øw×(Sz"3 Î
COzd4kt:u
&wh[{G]FBBK\V!G3 {+0 -࿯1dg +ÝÊ4~b,r[5?PK!{
H2xl/workbook.xmln0 _% RFÕ B0qi&
+o}]nq4(հZ`0C}X|®3`t;I
}Si=F'K0Gåys (>lt!P; kÄe*}^Nl˸:7
m<$Q/"/`` Zojg
;?PK!=Xb<p#xl/worksheets/_rels/sheet1.xml.relsUK!Bz40F'41 _zeOÔZ,
T;Ì7Óy)b!Î#g6.syÖiLÆG
p PK!(xl/worksheets/sheet1.xmlSn0 CïÝ N Rd - 7ŦmhHtGI
(7sV'/`Bl.0Ôx}Zz@J8ܸL4D*M]@+ ;0Rm%kudZ^V*#bXU[, "$ 5suLpCf mYw cRtG2ku:Æ
wa'2%G8)w
O"#tI+k{B&xZFP ,"z?{
aye&U[EJ<ȱۼ[̹×Br^b HѳØZ tiYtc>L,y;Ë UÈ»$ ÌÔ
×·ÚGY9С 7/{;*Ø Uoh_yoIë»´6N:}jDØ
m&'. w!Þ³z; PK4!Ob@ _rels/.relsPK4!'
xl/styles.xmlPK4!F@ docProps/core.xmlPK4!'+docProps/app.xmlPK4!(͸xl/_rels/workbook.xml.relsPK4!ö¡ [Content_Types].xmlPK4!{
H2%xl/workbook.xmlPK4!=Xb<p#xl/worksheets/_rels/sheet1.xml.relsPK4!(xl/worksheets/sheet1.xmlPK N
Isn't that awkward?
josephecombs
commented
4 years ago I'm on Rails 5.2, and got the error in this issue - I got this working by calling the new #render method and omitting the base64 option in the mailer itself:
str = MyXLSXController.render(:test_xlsx, locals: { some_local: @some_local }, layout: false)
options = {
xlsx: str,
email_array: ['asdf@gmail.com'],
}
JoeMailer.joe_mailer_instance_method(options).deliver_nowin JoeMailer:
def joe_mailer_instance_method(options)
xlsx = options[:xlsx]
attachments["test_filename.xlsx"] = { mime_type: Mime[:xlsx], content: xlsx }
mail from: 'qwer@gmail.com', to: options[:email_array], subject: "Email Subject"
end
ksdputra
commented
3 years ago I dont know if this is helping for others.
I had problems sending xlsx attachment. I dont know the exact problem, but the file always corrupt (can't be opened). I use sendgrid.
After 2 hours debugging, I found my root cause is the base64 encoding itself, ruby adds \n every 60 chars. (see in this stackoverflow question for more information.)
So I use Base64.strict_encode(xlsx) instead of Base64.encoding(xlsx), and the problem solved.
straydogstudio
commented
3 years ago @ksdputra Excellent work! I'll change the README (unless you want to do a PR for that.) That would definitely cause problems.
dtakeshta
commented
3 years ago I'm getting the "Excel cannot open the file ..." error.
Rails 6.1 caxlsx (3.1.0) caxlsx_rails (0.6.2)
I was hoping the strict_encode64 was going to solve this, but it didn't. What I find strange is the file opens perfectly fine when I export using a link_to, but I'm unable to open the file when attaching to a mailer.
xlsx =
render_to_string layout: false,
formats: [:xlsx],
template: 'frontend/v1/users/index',
locals: {
users: users,
relocations: relocations
}
attachment = Base64.strict_encode64(xlsx)
attachments['user_export.xlsx'] = {
mime_type: Mime[:xlsx],
content: attachment,
encoding: 'base64'
}@dtakeshta try omitting the base64 argument or generally following my workaround detailed in my comment above from about a year ago.
Hey there, I'm trying to attach an xlsx spreadsheet to a Sidekiq delayed email (only difference is that it's in the background), and I'm getting a
WARN: invalid byte sequence in UTF-8that blows up the sending job. I've tried all manner of different encoding options for the output fromrender_to_string, but no dice. This happens even when using very basic . The spreadsheet renders fine from the console and from a controller action. The email sends fine with no attachments. The following code is exactly what I'm running, with some names switched out. Gem version 0.3.0, Rails 4.1.7, Ruby 2.2.0_reportmailer.rb
report.xlsx.axlsx
_Output from a pry session right after the render_tostring call
Thanks in advance for your help.