Samsun Hidayat asked 4 years ago
Dear Abu,
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?
Regards,
Samsun
1 Answers
Abu Ghufran Staff answered 4 years ago
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
You can also check stackoverflow for phpexcel api usage and apply it in grid callback function.
Your Answer
