in reply to excel sheet as attachment

That's easy. Create your data as Excel sheet via Spreadsheet::WriteExcel and then attach it to the mail you send via MIME::Lite.