mtrajano / simple-excel
phpexcel 包的包装器,提供数组访问和一些额外功能
dev-master
2017-05-28 16:10 UTC
Requires
- phpoffice/phpexcel: ^1.8
Requires (Dev)
- phpunit/phpunit: ^5.7
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);