用PHP语言实现excel文件到.csv文件的自定义数据发送

<?php
require 'PHPExcel/PHPExcel.php'; // 导入PHPExcel库

// 读取Excel文件
$excelFile = 'path/to/excel.xlsx';
$excelReader = PHPExcel_IOFactory::createReaderForFile($excelFile);
$excelObj = $excelReader->load($excelFile);
$worksheet = $excelObj->getActiveSheet();

// 解析Excel数据
$data = [];
foreach ($worksheet->getRowIterator() as $row) {
    $rowData = [];
    foreach ($row->getCellIterator() as $cell) {
        $rowData[] = $cell->getValue();
    }
    $data[] = $rowData;
}

// 转换为CSV格式
$csvFile = 'path/to/output.csv';
$fileHandle = fopen($csvFile, 'w');
foreach ($data as $rowData) {
    fputcsv($fileHandle, $rowData);
}
fclose($fileHandle);

// 自定义数据发送
$to = 'recipient@example.com';
$subject = 'CSV File';
$message = 'Please find the attached CSV file.';
$from = 'sender@example.com';

// 使用PHPMailer发送邮件
require 'PHPMailer/PHPMailer.php';
$mail = new PHPMailer\PHPMailer\PHPMailer();
$mail->setFrom($from);
$mail->addAddress($to);
$mail->Subject = $subject;
$mail->Body = $message;
$mail->addAttachment($csvFile);

if ($mail->send()) {
    echo 'Email sent successfully.';
} else {
    echo 'Email sending failed.';
}
?>