PHP 创建 Excel 电子表格，然后将其作为附件通过电子邮件发送

使用PHP创建Excel电子表格，并通过电子邮件发送作为附件是一种常见的开发需求。PHP提供了许多库和函数来处理Excel文件，并且发送电子邮件也是PHP的一项强大功能。在本文中，我们将探讨如何使用PHP来实现这一需求，并提供相应的案例代码。

php
// 引入PHPExcel库
require_once 'PHPExcel/PHPExcel.php';
// 创建一个Excel对象
$objPHPExcel = new PHPExcel();
// 设置表格属性
$objPHPExcel->getProperties()
    ->setTitle("My Excel File")
    ->setSubject("Creating Excel using PHP")
    ->setDescription("This is a sample Excel file created using PHP.");
// 创建一个工作表
$objPHPExcel->setActiveSheetIndex(0);
$sheet = $objPHPExcel->getActiveSheet();
// 设置单元格内容
$sheet->setCellValue('A1', 'Hello');
$sheet->setCellValue('B1', 'World');
// 保存Excel文件
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('my_excel_file.xlsx');
// 清空内存
$objPHPExcel->disconnectWorksheets();
unset($objPHPExcel);

php
// 邮件接收者和主题
$to = 'receiver@example.com';
$subject = 'Email with Excel attachment';
// 邮件内容
$message = 'Please find the attached Excel file.';
// 设置邮件头
$headers = "From: sender@example.com\r\n";
$headers .= "Reply-To: sender@example.com\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: multipart/mixed; boundary=\"boundary\"\r\n";
// 读取Excel文件内容
$fileContent = file_get_contents('my_excel_file.xlsx');
// 添加Excel文件作为附件
$attachment = chunk_split(base64_encode($fileContent));
$body = "--boundary\r\n";
$body .= "Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; name=\"my_excel_file.xlsx\"\r\n";
$body .= "Content-Transfer-Encoding: base64\r\n";
$body .= "Content-Disposition: attachment\r\n";
$body .= "\r\n";
$body .= $attachment . "\r\n";
$body .= "--boundary--";
// 发送邮件
$mailSent = mail($to, $subject, $message, $headers, "-f sender@example.com");
// 检查邮件是否发送成功
if ($mailSent) {
    echo "Email sent successfully.";
} else {
    echo "Failed to send email.";
}

php
// 创建一个Excel对象
$objPHPExcel = new PHPExcel();
// 设置表格属性
$objPHPExcel->getProperties()
    ->setTitle("My Excel File")
    ->setSubject("Creating Excel using PHP")
    ->setDescription("This is a sample Excel file created using PHP.");
// 创建一个工作表
$objPHPExcel->setActiveSheetIndex(0);
$sheet = $objPHPExcel->getActiveSheet();
// 设置单元格内容
$sheet->setCellValue('A1', 'Hello');
$sheet->setCellValue('B1', 'World');
// 保存Excel文件
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('my_excel_file.xlsx');
// 发送邮件
$to = 'receiver@example.com';
$subject = 'Email with Excel attachment';
$message = 'Please find the attached Excel file.';
$headers = "From: sender@example.com\r\n";
$headers .= "Reply-To: sender@example.com\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: multipart/mixed; boundary=\"boundary\"\r\n";
$fileContent = file_get_contents('my_excel_file.xlsx');
$attachment = chunk_split(base64_encode($fileContent));
$body = "--boundary\r\n";
$body .= "Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; name=\"my_excel_file.xlsx\"\r\n";
$body .= "Content-Transfer-Encoding: base64\r\n";
$body .= "Content-Disposition: attachment\r\n";
$body .= "\r\n";
$body .= $attachment . "\r\n";
$body .= "--boundary--";
$mailSent = mail($to, $subject, $message, $headers, "-f sender@example.com");
// 检查邮件是否发送成功
if ($mailSent) {
    echo "Email sent successfully.";
} else {
    echo "Failed to send email.";
}