Thank you John, I've got another issue fixed. the content_type should be 'application/zip' which resolved my issue.

Lihao, here's what i used and it doesn't work: my $mail = MIME::Lite->new(
From =>'abc@host.com',
To =>'abc@host.com',
#Cc =>'def@host.com',
Subject =>'Hello!',
Data =>"How's it goin', eh?",
Type => 'multipart/mixed',
content-type.charset => 'UTF-8',
content-type => 'application/zip'
);


$mail->attach(
Type => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
#Encoding => 'base64',
Path => 'report.xlsx',
#Filename => 'report.xlsx'
Disposition => 'attachment'
);

please advise!

There is no $mail->send(); so after constructing the mail, nothing happens with it. Also consider enabling debugging (see MIME::Lite), and use code tags when posting, see How do I post a question effectively?.

Good to know about the application/zip type.

Sparklines are on the TODO list but I don't have a timeframe for them, at the moment.

--
John.

Update: Sparklines have been added to Excel::Writer::XLSX in version 0.55.

--
John.