PHPexcel通常用于从PHP导出excelcsv。本文整理了一些其他的解决方案。高性能Excel扩展sudoapt-getinstall-yzlib1g-devgitclonehttps://github.com/jmcnamara/libxlsxwriter.gitcdlibxlsxwritermake&&sudomakeinstall//https://github.com/viest/php-excel-writer//https://laravel-china.org/topics/6888/php-high-performance-excel-extension-five-hundred-year-formula-no-memory-leak#reply37308for($index=0;$index<10000;$index++){$data[$index]=['viest',23,66666666666666666,'No.银河市地球区程序村PHP群66菜鸟湾',15666666666];}$timeStart=microtime(true);$config=['path'=>'/vagrant/',];$excel=new\Vtiful\Kernel\Excel($config);$textFile=$excel->fileName("test.xlsx")->header(['name','age','id_card','address','phone'])->data($data)->输出（）;$timeEnd=微时间（真）；$time=$timeEnd-$timeStart;echo"ExportExcelcost:$timeseconds\n";laravel-excelcomposerrequiremaatwebsite/excel//导出Excel直接在浏览器下载https://laravel-china.org/主题/1918/extension-how-to-deal-with-the-excel-file-in-the-laravel-project#$export_file_name=生成Excel的文件名::create($export_file_name,function($excel){$excel->sheet('Sheetname',function($sheet){$sheet->appendRow(['data1','data2']);$sheet->appendRow(['data3','data4']);$sheet->appendRow(['data5','data6']);});})->download('xls');//导出Excel并存入指定目录Excel::create($export_file_name,function($excel){$excel->sheet('Sheetname',function($sheet){$sheet->appendRow(['data1','data2']);$sheet->appendRow(['数据3','数据4']);$sheet->appendRow(['数据5','数据6']);});})->store('xls',$object_path);问题：1.var_dump($reader->toArray());//第一行内容是关键，如果是中文，需要修改excel.php的'to_ascii'=>false,2.大数字变成科学计数法如11111111111显示为1.11111E+29exportexcelerrorPHPExcel_Calculation_Exception:Q5!A65→FormulaError:Anunexpectederroroccurredin/application/www/web_git-pull/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell.php:291excel中如果一个单元格以“=”开头，表示该单元格是根据其他单元格的值计算的，“=”后面必须是合法的表达式，而且那个字符串是用户输入的，显然不应该是合法的表达式，所以应该在代码中过滤掉或者$str="\t".$str;单个文件//https://github.com/mk-j/PHP_XLSXWriter/tree/master/examples有很多测试代码include_once("xlsxwriter.class.php");ini_set('display_errors',0);ini_set('log_errors',1);error_reporting(E_ALL&~E_NOTICE);$filename="example.xlsx";//for($index=0;$index<250000;$index++){$data[$index]=['viest',23,666666666666666666,'银河市土区程序村PHP群菜鸟湾66号',15666666666];}$timeStart=microtime(true);$writer=newXLSXWriter();$writer->writeSheet($data);$writer->writeToFile('example.xlsx');$timeEnd=microtime(true);$time=$timeEnd-$timeStart;echo"导出Excel需要：$time秒\n";回显'#'。floor((memory_get_peak_usage())/1024/1024)."MB"."\n";Excel处理包//https://github.com/bean-du/excel$writer=newExcelWriter();对于($i=0;$i<100;$i++){对于($j=0;$j<10;$j++){$data[$i][$j]='test['.$i.']+['.$j.']';}}$writer->setWidth(range('A','J'))->setValue($data)->setFormat('xls')->setAlignment(array('A1','C1'),'CENTER')->setBackgroundColor(array('A1','C1'),'#ccccc')->setAlignment(array('A2','C2'),'RIGHT')->setActiveSheetName('Bean')->outPut('test.xls');down??csvfunctionexport_csv($filename){header("Content-type:text/csv");header("Content-Disposition:attachment;filename=".$filename);header('Cache-Control:must-revalidate,post-check=0,pre-check=0');header('Expires:0');header('Pragma:public');}PDF,PPT,Excel,word,视频等格式文件在线预览http://jquery.malsup.com/media/https://view.officeapps.live....{yourFileOnlinePath}上传超大文件的Laravel扩展包https:///github.com/peinhu/aet...PHP高效导出Excelhttps://segmentfault.com/a/11...打造最全面的PHPExcel开发解决方案https://segmentfault.com/a/11...
