PHPExcel 设置单元格的值

<?php
    require 'vendor/autoload.php';
    $phpexcel = new PHPExcel();
    $phpwriter = new PHPExcel_Writer_Excel2007($phpexcel);  // 高版本扩展名 xlsx
    
    /*
    设置单元格的值
    $phpexcel->getActiveSheet()->setCellValue('A1','string');
    $phpexcel->getActiveSheet()->setCellValue('A2',12);
    $phpexcel->getActiveSheet()->setCellValue('A3',true);
    $phpexcel->getActiveSheet()->setCellValue('C5','=SUM(C2:C4)');
    $phpexcel->getActiveSheet()->setCellValue('B8','=MIN(B2:C5)');
    excel公式 大部分都可以在这里使用
    */
    
    $phpexcel->getActiveSheet()->setCellValue('A1','string');
    $phpexcel->getActiveSheet()->setCellValue('C5','=SUM(C2:C4)');
    $phpwriter->save('4.xlsx');