PHP：PhpSpreadsheet实现Excel的读取和写入

PhpSpreadsheet is the next version of PHPExcel.

• 文档: https://phpspreadsheet.readthedocs.io/en/latest/
• github: https://github.com/PHPOffice/PhpSpreadsheet

安装

composer require phpoffice/phpspreadsheet

  
 

  
1
 

示例

<?php

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');
  
 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
  
11
  
12
  
13
  
14
 

文章来源: pengshiyu.blog.csdn.net，作者：彭世瑜，版权归原作者所有，如需转载，请联系作者。

原文链接：pengshiyu.blog.csdn.net/article/details/120707141