phpexcel教程

composer require phpoffice/phpspreadsheet

require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'Hello World !');

$writer = new Xlsx($spreadsheet);
$writer->save('hello_world.xlsx');
echo 'Excel file已成功创建!';

require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\IOFactory;

$reader = IOFactory::createReader('Xlsx');
$spreadsheet = $reader->load('example.xlsx');
$sheet = $spreadsheet->getActiveSheet();
$cellA1 = $sheet->getCell('A1')->getValue();
echo $cellA1;

$styleArray = [
    'font' => [
        'bold' => true,
    ],
    'alignment' => [
        'horizontal' => \PhpOffice\PhpSpreadsheet\Cell\Alignment::HORIZONTAL_CENTER,
    ],
];
$sheet->getStyle('A1:C1')->applyFromArray($styleArray);

$reader = IOFactory::createReader('Xlsx');
$spreadsheet = $reader->load('data_import.xlsx');
$sheet = $spreadsheet->getActiveSheet();

$data = [];
$highestRow = $sheet->getHighestRow();
$highestColumn = $sheet->getHighestColumn();

for ($row = 1; $row <= $highestRow; $row++) {
    $rowData = [];
    for ($column = 'A'; $column <= $highestColumn; $column++) {
        $cell = $sheet->getCell($column . $row);
        $rowData[] = $cell->getValue();
    }
    $data[] = $rowData;
}

// 处理数据

$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save('data_export.xlsx');