Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

Re: Two issues with XLSX reporting

by MidLifeXis (Monsignor)
on Sep 27, 2012 at 17:30 UTC ( #996055=note: print w/ replies, xml ) Need Help??

in reply to Two issues with XLSX reporting

Can you generate a short perl script that illustrates the issue? Include the version of E::W::XLSX that you are using, and please wrap your example in <code>...</code> tags.


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

    issues are: without adjusting '&', I will get a warning notification and the url won't work in the Excel. the email attachment won't work at all for my configurations with MIME::Lite. I am using perl 5.8.8 (servers are RHEL 5.8 or 6.2). Excel::Writer::XLSX version 0.51, MIME::Lite version 3.027. A sample is shown below, many thanks.

    #!/usr/bin/perl use strict; use warnings; use Excel::Writer::XLSX; use MIME::Lite; my $report_file = 'hyperlink.xlsx'; # Create a new workbook and add a worksheet my $workbook = Excel::Writer::XLSX->new($report_file); my $worksheet = $workbook->add_worksheet('Hyperlinks'); # Add the standard url link format. my $url_format = $workbook->add_format( color => 'blue', underline => 1, ); $worksheet->write( 'A1', 'Some Content'); $worksheet->write( 'A3', '', $url_format, +'Perl home with query string' ); $workbook->close(); my $msg = MIME::Lite->new( From => '', To => '', Subject => "Testing Report - 2012-09-27", Type => 'multipart/mixed' ); $msg->attach( Type => 'text/plain', Data => 'This is a testing email', ); $msg->attach( #Type => 'AUTO', #Type => 'application/', Type => 'application/vnd.openxmlformats-officedocument.spre +adsheetml.sheet', Path => $report_file, Disposition => 'attachment', ); $msg->send(); __END__

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://996055]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (6)
As of 2015-11-29 03:54 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (746 votes), past polls