mtrajano/simple-excel

phpexcel 包的包装器,提供数组访问和一些额外功能

dev-master 2017-05-28 16:10 UTC

This package is auto-updated.

Last update: 2024-08-29 04:31:21 UTC


README

SimpleExcel 是 PHPOffice/PHPExcel 包的包装器,提供了额外的功能。其中一些功能包括

矩阵数组访问

//PHPExcel.php
$workbook = new PHPExcel();
$worksheet = $workbook->getActiveSheet();

$worksheet->setCellValue('A1', 'A test value');
//SimpleExcel.php
$workbook = new Mtrajano\SimpleExcel\Workbook();
$worksheet = $workbook->getActiveSheet();

$worksheet[1]['A'] = 'A test value';

数值列访问

//PHPExcel.php
$worksheet->setCellValue('B1', 'Another test value');
//SimpleExcel.php
$worksheet[1][1] = 'Another test value';

无缝导出

//PHPExcel.php
$writer = new PHPExcel_Writer_Excel2007($workbook);
$writer->save("phpexcel.xlsx");

$writer = new PHPExcel_Writer_Excel5($workbook);
$writer->save("phpexcel.xls");
//SimpleExcel.php
$workbook->save("simple.xlsx", Workbook::WRITE_Excel2007);
$workbook->save("simple.xls", Workbook::WRITE_Excel5);