P is for Practical | |
PerlMonks |
Two issues with XLSX reportingby lihao (Monk) |
on Sep 27, 2012 at 17:20 UTC ( [id://996053]=perlquestion: print w/replies, xml ) | Need Help?? |
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
Back to
Seekers of Perl Wisdom
|
|