Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
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.


Comment on Re: Two issues with XLSX reporting
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?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (12)
As of 2015-07-08 06:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (96 votes), past polls