php工具如何使用PHPExcel处理表格_php工具报表生成的操作方法

require_once 'PHPExcel/Classes/PHPExcel.php';

// 实例化 PHPExcel 对象
$objPHPExcel = new PHPExcel();

// 设置文档属性（可选）
$objPHPExcel->getProperties()
    ->setCreator("Your Name")
    ->setTitle("销售报表")
    ->setSubject("月度销售数据");

// 获取活动工作表
$objSheet = $objPHPExcel->getActiveSheet();
$objSheet->setTitle('销售数据');

// 写入表头
$objSheet->setCellValue('A1', '订单编号');
$objSheet->setCellValue('B1', '客户姓名');
$objSheet->setCellValue('C1', '金额');
$objSheet->setCellValue('D1', '日期');

// 模拟数据写入
$data = [
    ['SO001', '张三', 299.50, '2024-04-01'],
    ['SO002', '李四', 450.00, '2024-04-02'],
    ['SO003', '王五', 199.99, '2024-04-03']
];

$rowIndex = 2; // 从第2行开始写入数据
foreach ($data as $row) {
    $objSheet->setCellValue('A' . $rowIndex, $row[0]);
    $objSheet->setCellValue('B' . $rowIndex, $row[1]);
    $objSheet->setCellValue('C' . $rowIndex, $row[2]);
    $objSheet->setCellValue('D' . $rowIndex, $row[3]);
    $rowIndex++;
}

header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="sales_report.xls"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('./reports/sales_report.xls');