I have field with varchar type and the contain is number like 1234567899907777776, the problem is when exported to excel the character become E+17. How to solve the problem?
You can set cell value type to string using phpexcel api. set $column, $rowno, $value.
$type = PHPExcel_Cell_DataType::TYPE_STRING;
$sheet->getCellByColumnAndRow($column, $rowno)->setValueExplicit($value, $type);
You can have this code in http://gridphp.com/demo/demos/export/export-phpexcel.phps line 55
Abu Ghufran - Dev Team
Grid 4 PHP Framework
You can also check stackoverflow for phpexcel api usage and apply it in grid callback function.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?