PHP Export on Excel cell with small green triangle processing

Actual problem: Statistical data in Excel does not count against a green triangle, which is considered a text format, not a number format, and does not participate in summing

Solution: Online information, about Excel This occurs because the cell format is in text format, but the content is the number of this situation occurs

Solution: First check whether the current data format is number, usually the digital format is not a problem

Attach how to set the cell to the destination format:

$objSheet -getStyle (' A1 ')->getnumberformat ()
// format cells as ' #,# #0.

Format cell contents:

$objSheet ' 123123 ', \phpexcel_cell_datatype::type_string);

PHP Export on Excel cell with small green triangle processing