在TP5中使用PHPExcel可以通过composer安装PHPExcel库,并在控制器中引入PHPExcel类来进行操作。具体步骤如下:
- 使用composer安装PHPExcel库:
composer require phpoffice/phpexcel
- 在控制器中引入PHPExcel类:
use PhpOfficePhpSpreadsheetSpreadsheet;
use PhpOfficePhpSpreadsheetWriterXlsx;
- 创建PHPExcel对象,并设置相关属性:
$spreadsheet = new Spreadsheet();
$spreadsheet->getActiveSheet()->setTitle("Sheet1");
- 向PHPExcel对象添加数据:
$spreadsheet->getActiveSheet()->setCellValue("A1", "Hello World!");
- 将PHPExcel对象保存为Excel文件:
$writer = new Xlsx($spreadsheet);
$writer->save("hello_world.xlsx");
- 使用composer安装PHPExcel库:
composer require phpoffice/phpexcel
- 在控制器中引入PHPExcel类:
use PhpOfficePhpSpreadsheetSpreadsheet;
use PhpOfficePhpSpreadsheetWriterXlsx;
- 创建PHPExcel对象,并设置相关属性:
$spreadsheet = new Spreadsheet();
$spreadsheet->getActiveSheet()->setTitle("Sheet1");
- 向PHPExcel对象添加数据:
$spreadsheet->getActiveSheet()->setCellValue("A1", "Hello World!");
- 将PHPExcel对象保存为Excel文件:
$writer = new Xlsx($spreadsheet);
$writer->save("hello_world.xlsx");