lihao has asked for the wisdom of the Perl Monks concerning the following question:
(1) I am using Excel::Writer::XLSX, one of the issues is that the function write_url() does not work well when there is any '&' on the URL. this looks OK if I change '&' to '&', I am not sure if this is a correct solution, the resulting XLSX file yields some waring information after being opened.
(2) need to send out daily report (i.e. report-yyyymmdd.xlsx) in an email attachment by using MIME::Lite. I tried setting Type as 'AUTO', 'application/vnd.ms-excel', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'. none of these are working and the attached file can not be opened properly. The file is OK if I scp to my local server and open it directly (not in email attachment).
I was using Spreadsheet::WriteExcel and Excel 97-2003, no above issues at all. but I do need some new functionality in Excel 2010. Any suggestions
many thanks in advance
lihao
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Two issues with XLSX reporting
by jmcnamara (Monsignor) on Sep 27, 2012 at 20:26 UTC | |
by lihao (Monk) on Sep 27, 2012 at 22:10 UTC | |
by kinipranav (Initiate) on Nov 28, 2013 at 11:47 UTC | |
by marto (Cardinal) on Dec 05, 2013 at 14:20 UTC | |
by lihao (Monk) on Sep 27, 2012 at 22:33 UTC | |
by jmcnamara (Monsignor) on Sep 28, 2012 at 09:34 UTC | |
by jmcnamara (Monsignor) on Nov 12, 2012 at 13:20 UTC | |
Re: Two issues with XLSX reporting
by MidLifeXis (Monsignor) on Sep 27, 2012 at 17:30 UTC | |
by lihao (Monk) on Sep 27, 2012 at 19:11 UTC |