官方文档Spout
execl导入功能
/ * Common import file * @param $filePath string * @author : patti */ public static function importFile($filePath) {
try{
ini_set('memory_limit', '100M'); set_time_limit(1000); $reader=ReaderEntityFactory::createXLSXReader(); $reader->open($filePath); foreach ($reader->getSheetIterator() as $sheet) {
foreach ($sheet->getRowIterator() as $row) {
$rowArr[] = $row->toArray(); } } unset($rowArr[0]); $reader->close(); }catch (\Exception $e){
throw new \Exception($e->getMessage()); } return $rowArr; } execl导出功能
/ * Common export file * @param $headerCell array * @param $name string * @param $data array * @author : patti */ public static function exportFile($headerCell=[],$name='test.xls',$data=[]) {
try{
ini_set('memory_limit', '100M'); set_time_limit(1000); //BACKGROUND $backStyle = (new StyleBuilder()) ->setBackgroundColor(Color::LIGHT_BLUE) ->setFontColor(Color::BLACK) ->setFontBold() ->build(); //BORDER LINE $border=(new BorderBuilder())->setBorderTop(Color::BLACK,Border::WIDTH_THIN) ->setBorderLeft(Color::BLACK,Border::WIDTH_THIN) ->setBorderRight(Color::BLACK,Border::WIDTH_THIN) ->setBorderBottom(Color::BLACK,Border::WIDTH_THIN) ->build(); $borderStyle=(new StyleBuilder())->setBorder($border)->build(); //CREATE $writer = WriterEntityFactory::createXLSXWriter(); foreach ($headerCell as $val){
$cells[] = WriterEntityFactory::createCell($val,$backStyle); } $singleRow = WriterEntityFactory::createRow($cells)->setStyle($borderStyle); $writer->openToBrowser("php://output/" . $name) ->addRow($singleRow); foreach ($data as $value) {
$rowFromValues = WriterEntityFactory::createRowFromArray($value); $writer->setDefaultRowStyle($borderStyle)->addRow($rowFromValues); } $writer->close(); return true; }catch (\Exception $e){
throw new \Exception($e->getMessage()); } } 版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请联系我们举报，一经查实，本站将立刻删除。
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/231062.html原文链接：https://javaforall.net
