创建.xls文件并使用php通过邮件发送

<?php
require_once 'PHPExcel/Classes/PHPExcel.php';

// 创建一个新的Excel对象
$objPHPExcel = new PHPExcel();

// 设置文件属性
$objPHPExcel->getProperties()->setCreator("Your Name")
                             ->setLastModifiedBy("Your Name")
                             ->setTitle("Excel File")
                             ->setSubject("Excel File")
                             ->setDescription("Generated by PHPExcel")
                             ->setKeywords("excel")
                             ->setCategory("Test");

// 添加数据到单元格
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', 'Hello')
            ->setCellValue('B1', 'World');

// 保存Excel文件
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('example.xls');
?>

<?php
require 'PHPMailer/PHPMailerAutoload.php';

// 创建PHPMailer对象
$mail = new PHPMailer;

// 配置SMTP服务器设置
$mail->isSMTP();
$mail->Host = 'smtp.example.com';
$mail->SMTPAuth = true;
$mail->Username = 'your-email@example.com';
$mail->Password = 'your-email-password';
$mail->SMTPSecure = 'tls';
$mail->Port = 587;

// 配置发件人和收件人
$mail->setFrom('your-email@example.com', 'Your Name');
$mail->addAddress('recipient@example.com', 'Recipient Name');

// 添加附件
$mail->addAttachment('example.xls');

// 设置邮件内容
$mail->Subject = 'Excel File';
$mail->Body = 'Please find the attached Excel file.';

// 发送邮件
if (!$mail->send()) {
    echo 'Message could not be sent.';
    echo 'Mailer Error: ' . $mail->ErrorInfo;
} else {
    echo 'Message has been sent.';
}
?>