Re: Unable to send the xls attachment file with the Mail::Sender

[jmcnamara]

If you are using Spreadsheet::WriteExcel to generate the XLS file then you need to ensure that you close() the workbook prior to attaching it to an email. From the docs:

In general your Excel file will be closed automatically when your program ends or when the Workbook object goes out of scope, however the close() method can be used to explicitly close an Excel file. ... An explicit close() is required if the file must be closed prior to performing some external action on it such as copying it, reading its size or attaching it to an email.

--
John.

[mrguy123]

Hi John, that's a good call. Had the same problem myself a few months ago
I hope this solves Ree's problem

[vinoth.ree]

Thanks jmcnamara ++

I am using the Spreadsheet::WriteExcel perl module to generate the xls file. I also checked the code and found that I did not close that file. Once I generate this xls file I am sending this xls file name for EmailSending program. Now I modified the code let me check and confirm.

Update:

Its working fine! thanks a lot

[Ravi V]

thanks ... :)