PHPExcel-在写入值之前设置单元格类型 [英] PHPExcel - set cell type before writing a value in it

问题描述

您知道在写入值之前如何设置单元格类型吗?我希望能够设置常规"，文本"和数字"等类型.

Do you know how can I set the cell type before writing a value in it? I would like to be able to set types like "General", "Text" and "Number".

谢谢.

推荐答案

当文本是带有前导零的数字时，请执行以下操作: (Ccero el texto es unnúmeroque empieza por ceros，hacer)

When the text is a number with leading zeros, then do: (Cuando el texto es un número que empieza por ceros, hacer)

$objPHPExcel->getActiveSheet()->setCellValueExplicit('A1', $val,PHPExcel_Cell_DataType::TYPE_STRING);

这篇关于PHPExcel-在写入值之前设置单元格类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！