Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: Two issues with XLSX reporting

by jmcnamara (Monsignor)
on Sep 27, 2012 at 20:26 UTC ( #996074=note: print w/replies, xml ) Need Help??


in reply to Two issues with XLSX reporting

The first issue is a bug. I'll post a fix for it shortly.

I don't know what the second issue is. Does it happen when you use a file generated by Excel rather than by Excel::Writer::XLSX?

Update: The first issue is fixed on the master branch in the Github repo and will make its way into version 0.52 in a few weeks.

--
John.

Replies are listed 'Best First'.
Re^2: Two issues with XLSX reporting
by lihao (Monk) on Sep 27, 2012 at 22:10 UTC

    Thank you John, I've got another issue fixed. the content_type should be 'application/zip' which resolved my issue.

      Lihao, here's what i used and it doesn't work: my $mail = MIME::Lite->new(
      From =>'abc@host.com',
      To =>'abc@host.com',
      #Cc =>'def@host.com',
      Subject =>'Hello!',
      Data =>"How's it goin', eh?",
      Type => 'multipart/mixed',
      content-type.charset => 'UTF-8',
      content-type => 'application/zip'
      );


      $mail->attach(
      Type => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
      #Encoding => 'base64',
      Path => 'report.xlsx',
      #Filename => 'report.xlsx'
      Disposition => 'attachment'
      );

      please advise!
Re^2: Two issues with XLSX reporting
by lihao (Monk) on Sep 27, 2012 at 22:33 UTC
    I have one more question, can we make Sparklines (similar to Charts) with Excel::Writer::XLSX. that would be really cool if it does..:)

      Good to know about the application/zip type.

      Sparklines are on the TODO list but I don't have a timeframe for them, at the moment.

      --
      John.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://996074]
help
Chatterbox?
[talexb]: TStanley I'm flying to Vegas in two weeks time. After that flights leaving Vegas and Phoenix are late at night .. I've been hearing that it gets so hot that the air isn't dense enough for planes to take off. Weird. Guess you won't have that problem.
[Corion]: Yay, vacation time now - one week off work (but a Perl workshop in the middle ;)) )
[talexb]: TStanley I just realized that I was in your area for a convention back in April. We were at the high school for the weekend, the one with the long driveway. Nice spot.
[TStanley]: I am heading to Arlington, Virginia next week, then I get to spend an entire week at home. Looking forward to that as I will have spent 7 weeks on the road by the end of next week
[talexb]: That's a long road trip. I haven't travelled for business in years.

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (10)
As of 2017-06-23 14:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (548 votes). Check out past polls.