会php的猪 2016-05-03 03:14 采纳率: 0%
浏览 1660
已结题

php导出excel用的是phpexcel类库和thinkphp3.2.2

(导出数量超过26条就会报这个错误,26条以及26以内就没问题)

Invalid cell coordinate [1
错误位置
FILE: D:\www\ziyuan\ThinkPHP\Library\Vendor\PHPExcel\Cell.php  LINE: 558
TRACE
#0 D:\www\ziyuan\ThinkPHP\Library\Vendor\PHPExcel\Style.php(236): PHPExcel_Cell::coordinateFromString('[1')
#1 D:\www\ziyuan\ThinkPHP\Library\Vendor\PHPExcel\Style\Font.php(250): PHPExcel_Style->applyFromArray(Array)
#2 D:\www\ziyuan\sundata_course\Application\Common\Common\function.php(469): PHPExcel_Style_Font->setName('Candara')
#3 D:\www\ziyuan\sundata_course\Application\Admin\Controller\SuperController.class.php(966): exportExcel(Array, '????????????', Array)
#4 [internal function]: Admin\Controller\SuperController->exportOrderListExcel()
#5 D:\www\ziyuan\ThinkPHP\Library\Think\App.class.php(155): ReflectionMethod->invoke(Object(Admin\Controller\SuperController))
#6 D:\www\ziyuan\ThinkPHP\Library\Think\App.class.php(193): Think\App::exec()
#7 D:\www\ziyuan\ThinkPHP\Library\Think\Think.class.php(120): Think\App::run()
#8 D:\www\ziyuan\ThinkPHP\ThinkPHP.php(96): Think\Think::start()
#9 D:\www\ziyuan\sundata_course\index.php(24): require('D:\www\ziyuan\T...')
#10 {main}

  • 写回答

2条回答 默认 最新

  • ZEUSSXB 2016-05-03 06:24
    关注

    26?是不是把excel里cell的行列顺序搞颠倒了?检查一下,数据的循环。

    评论

报告相同问题?