echo ""; echo ""; echo ""; echo ""; if(!is_admin){echo "";} » 在使用PHPExcel导出Excel时出现的几个错误的解决办法 仲子说

2009-06-22

在使用PHPExcel导出Excel时出现的几个错误的解决办法

Posted in PHP, FreeBSD/Unix服务器 at 13:55 Author:仲远

标签:

PHPExcel?PHP???????????????Microsoft Excel????????????????????????

??Microsoft Office?????????Office2003?????????????????????????Office?????????????????????????????????????Microsoft Office Word?Microsoft Office PowerPoint?Microsoft Office Excel?????Microsoft Office 2007???????????XML????????????????????Office2007???Open Office XML?OOXML?????????????????????????????4???ISO???????????????OOXML????????????????????

???OOXML??????“?????????????”?“?????????”?????????????????????????????????PHPExcel???????????????????PHP????????Excel?????Excel2007?????????????????????

?????????PHPExcel?????Microsoft Office???????????Excel????????????????????PHPExcel???Excel????MS Excel????????????????EditPlus?????Excel????????????????????????????

?1?Fatal error: Maximum execution time of 30 seconds exceeded??????
????php.ini????????Ubuntu 9.04 Server????????/etc/php5/apache2/???php.ini??????Freebsd????/usr/local/lib/???php.ini?????sudo??????????

??????
max_execution_time = 30
????
max_execution_time = 300
????PHP?????????30????300??

??????Apache???????Ubuntu Server??????????????
sudo /etc/init.d/apache2 restart

?2?Fatal error: Allowed memory size of 16777216 bytes exhausted ?????
???????php.ini???

??????
memory_limit = 16M
????
memory_limit = 512M

????PHP???????????16M???512M?????????????????

??????Apache????

???????
?1??????????????????????????????????????????PHPExcel?????PHP?????????????????????
?2????php.ini???????Apache????????????
?3?php.ini?????????????????????

本文可以自由转载,转载时请保留全文并注明出处:
转载自仲子说 [ http://www.wangzhongyuan.com/ ]
原文链接:

5 Comments »

  1. 张鹏 said,

    2009年July27日 at 0:15

    phpmyadmin使用cvs来导入excel数据,这种方法和cvs导入有什么区别吗?

  2. 仲远 said,

    2009年July27日 at 10:22

    这篇文章中的导入Excel表的方式比CVS导入具有更强大的功能。例如,CVS只能导入简单的文本,而PHPExcel甚至可以导入文字上附带的链接。

  3. 如月 said,

    2010年March16日 at 16:28

    真想知道用PHP将SQL中的内容导入excel的时候,对于大段文本的longblob要怎么办?或者可以预设excel的某一列属性是“文本”?

  4. 我要DVD said,

    2010年May14日 at 11:29

    路过,支持一下!

  5. 500W条数据 said,

    2011年September13日 at 16:23

    使用phpexcel导出500W条数据,相当杯具,内存修改为512M也扛不住……

Leave a Comment

*
To prove you're a person (not a spam script), type the security text shown in the picture. Click here to regenerate some new text.
Click to hear an audio file of the anti-spam word