转载 | phpspreadsheet开发手记

require ‘vendor/autoload.php‘;

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spredsheet = new Spreadsheet();
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue("A1", 'Hello World !');
         
$writer = new Xlsx($spreadsheet);
$writer->save('hello world.xlsx');

//通过工厂模式创建内容
        $spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load('template.xlsx');

        $worksheet = $spreadsheet->getActiveSheet();

        $worksheet->getCell('A1')->setValue('John');
        $worksheet->getCell('A2')->setValue('Smith');
        //通过工厂模式来写内容
        $writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Xls');
        $writer->save('write.xls');

$spreadsheet->disconnectWorksheets();
unset($spreadsheet);

$worksheet->getCell(‘A1‘)->setValue(‘John‘);
$sheet->setCellValue(‘A1‘, ‘Hello World !‘);
$sheet->setCellValueByColumnAndRow($columnIndex, $rowIndex, $value);

        header(‘Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet‘);//告诉浏览器输出07Excel文件
//header(‘Content-Type:application/vnd.ms-excel‘);//告诉浏览器将要输出Excel03版本文件
        header(‘Content-Disposition: attachment;filename="01simple.xlsx"‘);//告诉浏览器输出浏览器名称
        header(‘Cache-Control: max-age=0‘);//禁止缓存
        $writer = new Xlsx($spreadsheet);
        $writer->save(‘php://output‘);

  function autoFitColumnWidthToContent($sheet, $fromCol, $toCol) {
        if (empty($toCol) ) {//not defined the last column, set it the max one
            $toCol = $sheet->getColumnDimension($sheet->getHighestColumn())->getColumnIndex();
        }
        for($i = $fromCol; $i <= $toCol; $i++) {
            $sheet->getColumnDimension($i)->setAutoSize(true);
        }
        $sheet->calculateColumnWidths();
    }

$worksheet->setCellValue(‘A12‘, ‘=DMIN(A4:E10,"Profit",A1:A2)‘);

$retVal = $worksheet->getCell(‘A12‘)->getCalculatedValue();
// $retVal = 225