While open excel file getting error

Question

I have an excel file attachment and try to send an email. I'm able to send an email successfully, but I'm getting an error while opening the attached excel file which is given below:

error :-

"Excel cannot open the file "test.xlsx" because the file format or file extension is not valid. 
Verify that the file has not been corrupted and that the file extension matches the format of the file."

Code:-

$WRKDIR="/tmp/xpyt/"
$EXCEL_FILE="test.xlsx"
$EMAIL_FROM="xxx@in.imk.com"
$EMAIL_TO="yyy@in.imk.com"
$EMAIL_SUBJECT="Excel Report"
$EMAIL_TYPE="multipart/mixed"


$msg = MIME::Lite->new(
    From    => $EMAIL_FROM,
    To      => $EMAIL_TO,
    Subject => $EMAIL_SUBJECT,
    Type    => $EMAIL_TYPE,
);

$msg->attach(
    Type     => 'TEXT',
    Data     => "Here's the excel file you wanted"
);

chmod 0755, $EXCEL_FILE_PATH;

$msg->attach(
    Type     => 'application/vnd.ms-excel',
    Path     => $WRKDIR,
    Filename => $EXCEL_FILE,
    Disposition => 'attachment'
);

$msg->send();

Any help will be appreciated.

score 1 · Answer 1 · answered Jun 07 '18 at 12:09

1

application/vnd.ms-excel is for BIFF (.xls) files.

For Excel 2007 and above (.xlsx) files, use:

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

^(Source)

...so, either change your extension or the attachment type, so they match.

answered Jun 07 '18 at 12:09

ashleedawg

20,365
9
72
105

thanks for your answer I made the changes what did you suggest but still i'm getting same error. – user9318576 Jun 07 '18 at 13:09

score 0 · Accepted Answer · answered Jun 07 '18 at 15:30

0

change Path => $WRKDIR to Path => $WRKDIR.$EXCEL_FILE and try again

path is the full path to your attachement, filename is the recommended filename to appear in the mail

answered Jun 07 '18 at 15:30

Reflective

3,854
1
13
25

While open excel file getting error

2 Answers2